What is PL/SQL ?
Course Introductory Video
UDEMY 101: How to Use Udemy? +Some Useful Tips
What is PL/SQL and Why to Use?
PL/SQL Architecture
The Sample (HR) Schema Used in This Course
Bonus Materials : Course Material & PL/SQL Cheatsheet
Quiz 1
Software Installation
About the Database Installation
Which Option to Have a Database?
Option 1: Having the Database with the Oracle Virtual Box
Option 1: How to Install the Virtual Box on Mac OS X?
What is Pluggable Database?
Option 2: Downloading and Installing the Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using the SQL Developer
Option 3: Using Oracle Live SQL
Option 3: About Oracle Live SQL Restrictions
Let's Start Coding!..
Anonymous Blocks
PL/SQL Outputs
Quiz 2
PL/SQL Variables
What are Variables and Why to Use Them?
Naming Rules & Naming Conventions
Declaring & Initializing & Using Variables - Part 1
Declaring & Initializing & Using Variables - Part 2
Declaring & Initializing & Using Variables (Code Samples)
Using %TYPE Attribute
Using %Type Attribute (Code Samples)
PL/SQL Delimiters and Commenting Your Code
PL/SQL Delimiters and Commenting (Code Samples)
PL SQL Variable Scope
PL SQL Variable Scope (Code Samples)
Using Bind Variables
Using Bind Variables (Code Samples)
Quiz 3 - Variables
Control Structures
What are Control Structures & IF Statements
What are Control Structures & IF Statements (Code Samples)
Case Expressions
Case Expressions (Code Samples)
What are Loops - Basic Loops
Basic Loops (Code Samples)
While Loops
While Loops (Code Samples)
For Loops
For Loops (Code Samples)
Nested Loops & Loop Labeling
Nested Loops & Loop Labeling (Code Samples)
Continue Statement
Continue Statement (Code Samples)
GOTO Statement
GOTO Statement (Code Samples)
Quiz 4 - Control Structures
Using SQL in PL/SQL
Operating with Selected Database Data..
Operating Wİth Selected Queries (Code Samples)
DML Operations in PL/SQL
DML Operations in PL/SQL (Code Samples)
Using Sequences in PL/SQL
Using Sequences in PL/SQL (Code Samples)
Bonus - Enabling Server Outputs by Default.
Quiz 5 - Using SQL in PL/SQL
Composite Data Types
Simple Data Types vs Composite Data Types
PL/SQL Records - Part 1
PL/SQL Records - Part 2
PL/SQL Records (Code Samples)
Easy DML With Records
Easy DML With Records (Code Samples)
What Are Collections?
Varrays & Collection Methods
Varrays (Code Samples)
Nested Tables
Nested Tables (Code Samples)
PL&SQL Associative Arrays (Part 1)
PL&SQL Associative Arrays (Part 2)
Associative Arrays (Code Samples)
Storing Collections in Tables - (Part 1)
Storing Collections in Tables - (Part 2)
Storing Collections in Tables (Code Samples)
Quiz 6 - Composite Data Types
PL/SQL Cursors
What are Cursors and Cursor Types in PL SQL?
Using Explicit Cursors
Using Explicit Cursors (Code Samples)
Using Cursors with Records
Cursors with Records (Code Samples)
Looping with Cursors
Looping with Cursors (Code Samples)
PL SQL Cursors with Parameters
PL SQL Cursors with Parameters (Code Samples)
PL SQL Cursor Attributes
PL SQL Cursor Attributes (Code Samples)
For Update Clause
For Update Clause (Code Samples)
Where Current Of Clause
Where Current Of Clause (Code Samples)
Reference Cursors
Reference Cursors - (Code Samples)
PL/SQL Exceptions
What are the Exceptions?
What are the Exceptions (Code Sample)
Handling the Exceptions!
Handling the Exceptions (Code Samples)
Handling the Nonpredefined Exceptions
Handling Nonpredefined Exceptions (Code Sample)
Handling & Raising User-Defined Exceptions
Handling & Raising User-Defined Exceptions (Code Samples)
Using RAISE_APPLICATION_ERROR() Procedure
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
PL/SQL Functions & Procedures
What are Functions & Procedures and Why We Use?
What are Functions & Procedures and Why We Use (Code Samples)
Creating and Using Stored Procedures
Creating and Using Stored Procedures (Code Samples)
Using IN & OUT Parameters
Using IN & OUT Parameters (Code Samples)
Named & Mixed Notations and Default Option
Named & Mixed Notations and Default Option (Code Samples)
Creating and Using Functions (Part 1)
Creating and Using Functions (Part 2)
Creating and Using PL/SQL Functions (Code Samples)
Local Subprograms
Local Subprograms (Code Samples)
Overloading the Subprograms
Overloading the Subprograms (Code Samples)
Handling the Exceptions in Subprograms
Handling the Exceptions in Subprograms (Code Samples)
Finding & Removing the Subprograms
Regular & Pipelined Table Functions
Regular & Pipelined Table Functions (Code Samples)
PL/SQL Packages
What Are Packages?
Creating & Using & Modifying & Removing the Packages
Creating & Using & Modifying & Removing the Packages (Code Samples)
Visibility of Package Objects
Visibility of Package Objects (Code Samples)
Illegal Object Reference & Forward Declaration
Package Initialization
Persistent State of Packages - Part 1
Persistent State of Packages - Part 2
Persistent State of Packages (Code Samples)
Using Collections in Packages - Part 1
Using Collections in Packages - Part 2
Using Collections in Packages (Code Samples)
How Can I Find the Packages?
PL/SQL Triggers
What are Triggers & Trigger Types
Understanding DML Triggers
Specifying the Timing of Triggers
Specifying the Timing of Triggers (Code Samples)
Statement & Row Level Triggers
Statement & Row Level Triggers (Code Samples)
Using New & Old Qualifiers in Triggers
Using New & Old Qualifiers in Triggers (Code Samples)
Using Conditional Predicates
Using Conditional Predicates (Code Samples)
Using RAISE_APPLICATION_ERROR Procedure in Triggers
Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
Using Update Of Event in Triggers
Using Update Of Event in Triggers (Code Samples)
Using WHEN Clause in Triggers
Using When Clause in Triggers (Code Samples)
INSTEAD OF Triggers
Instead of Triggers (Code Samples)
Exploring & Managing the Triggers
Creating Disabled Triggers
Creating Disabled Triggers (Code Samples)
Additional Real-World Examples for DML Triggers
Additional Real-World Examples for DML Triggers (Code Samples)
Compound Triggers
Compound Triggers (Code Samples)
Handling Mutating Table Errors
Handling Mutating Table Errors (Code Samples)
PL/SQL Debugging: Debugging Your Codes & Subprograms
PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
Granting Debug Privileges to a User
PL/SQL Debugging: Debugging the Anonymous Blocks
Source Code: Debugging the Anonymous Blocks
Using Dynamic SQL in PL/SQL!
For Your Attention!..
Using PL/SQL Objects
On Production
Using PL/SQL Compiler
On Production
Using Large Objects(LOB) in PL/SQL
Thank you for your understanding..
PL/SQL Performance & Tuning
On Production
Bonus (+) Section
Bonus (+) Lecture: Special Discounts for Our Students!
Appendix
Appendix 1: Oracle Database 12c Installation into Your Computer
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c