Course Highlights
  • Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
  • Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
  • Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
  • Every Subject is Explained from the Easiest to the Most Advanced.
  • Real-World Examples for Every Section
  • Some Advanced SQL Techniques
  • Use SQL Developer Efficiently for PL/SQL
  • Learn PL/SQL Architecture Very Well
  • Improve Performance of SQL& PL/SQL Codes
  • Create Your Dynamic SQL & PL/SQL Queries
  • Learn PL/SQL Object Oriented Programming
  • Learn PL/SQL Tuning for Performance
  • Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
  • Become a Job-Ready Oracle PL/SQL Developer Certified Professional!
Skills you will learn!
Curriculum

8 Topics
Course Introductory Video
UDEMY 101: How to Use Udemy? +Some Useful Tips
What is PL/SQL and Why to Use?
PL/SQL Architecture
What is Pluggable Database?
The Sample (HR) Schema Used in This Course
Welcoming Gifts: Course Material & PL/SQL Cheatsheet
Quiz 1

17 Topics
About the Database Installation
The Ways to Get a Database
Option 1: Installing VMware and VirtualBox on Windows
Option 1: How to Install the Virtual Box on Mac OS X?
Option 1: Downloading Virtual Machine Image(19c)
Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
Option 1: Configuring the VMware Virtualization Software
Option 1: Configuring the Oracle VirtualBox Virtualization Software
Option 1: Configuring SQL Developer inside of the Virtual Machine
Important Note
Option 2: Downloading and Installing the Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using the SQL Developer
Option 2: Installing Sample Schemas in Oracle Database
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)
Option 3: Using Oracle Live SQL
Option 3: About Oracle Live SQL Restrictions

3 Topics
Anonymous Blocks
PL/SQL Outputs
Quiz (First Steps)

14 Topics
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 (Variables)

17 Topics
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 (Control Structures)

8 Topics
Operating with Selected Database Data..
Operating With 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)
Extra - Enabling Server Outputs by Default
Quiz (Using SQL in PL/SQL)

18 Topics
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 (Composite Data Types)

18 Topics
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)
Quiz (Cursors)

11 Topics
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)
Quiz (Exceptions)

21 Topics
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)
Quiz (PL/SQL Functions & Procedures)

15 Topics
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 PL/SQL Packages - Part 1
Using Collections in PL/SQL Packages - Part 2
Using Collections in PL/SQL Packages (Code Samples)
How Can I Find the Packages?
Quiz (Packages)

28 Topics
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)
Quiz (Triggers)

6 Topics
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

17 Topics
Introduction to Dynamic SQL and Dynamic PL/SQL
Native Dynamic SQL PL/SQL
EXECUTE IMMEDIATE Statement
Execute Immediate Statement (Code Samples)
EXECUTE IMMEDIATE STATEMENT with the USING Clause
EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses
EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)
EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause
Execute Immediate with Bulk Collect (Code Samples)
Dynamic PL/SQL Blocks
Dynamic PL/SQL Blocks (Code Sample)
OPEN - FOR FETCH Statements
OPEN - FOR FETCH Statements (Code Sample)
Using the DMBS_SQL Package (The Method 4)
Using the DBMS_SQL Package (Code Samples)
Quiz (Dynamic SQL)

11 Topics
What are Oracle Supplied Packages?
Using the DBMS_OUTPUT Package
Using the DBMS_OUTPUT Package (Code Samples)
Using the UTL_FILE Package (Part 1)
Using the UTL_FILE Package (Part 2)
Using the UTL_FILE Package (Part 3)
Using the UTL_FILE Package (Code Samples)
Using the UTL_MAIL Package (Part 1)
Using the UTL_MAIL Package (Part 2)
Using the UTL_MAIL Package (Code Samples)
Quiz (Oracle-Supplied Packages)

4 Topics
Managing Security for Definer's Rights and Invoker's Rights (Part 1)
Managing Security for Definer's Rights and Invoker's Rights (Part 2)
Managing Security for Definer's Rights and Invoker's Rights (Code Samples)
Quiz (Miscellaneous Topics)

4 Topics
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
How to Uninstall Oracle Database?

1 Topic
Bonus Lecture

  Write a Review

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

Go to Paid Course