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

Latest Course Updates:

• (Dec, 2025) : Installing Oracle Database 23 AI section was added! (Brand New!)

• (Aug 2025) : "Oracle-Supplied PL/SQL Packages" section was added!

• (May 2025): "Using Dynamic SQL & PL/SQL in PL/SQL" section was added!

• (Feb 2025) : High-Quality Closed-Captions were added!

• (Dec 2024): New PL/SQL Quiz Questions were added!

Become an Oracle Database PL/SQL Developer Certified Professional!

This comprehensive PL/SQL Programming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for. 

Students will learn and improve their:

• PL/SQL Coding Skills

• SQL & PL/SQL Performance

• PL/SQL Scalability

• Portability and Security of Database and PL/SQL Programming

And also our students will be prepared for:

• (NEW!) Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL  Oracle Certification Exam

• Exam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL        | Oracle Certification Exam

• Exam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

• Exam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

Our PL/SQL Programming Bootcamp Covers:

• PL/SQL Terminologies

• PL/SQL Architecture

• PL/SQL Variables

• PL/SQL Control Structures

  • If-Then-Else Structure

  • Case Expressions

  • Loops

    • PL SQL While Loop

    • PL SQL For Loop

    • PL SQL Nested Loop

    • PL SQL Loop Labeling

    • PL SQL Continue Statement

    • PL SQL GOTO Statement

• Using SQL inside PL/SQL

• PL/SQL Cursors

• Using PL/SQL Program Units (Functions & Procedures in PL/SQL)

• PL/SQL Packages

• PL/SQL Exceptions & Exception Handling

• PL/SQL Debugging

• Dynamic SQL & PL/SQL

• PL/SQL Composite Data Types (Collections)

  • PL SQL Associative Arrays

  • PL SQL Nested Tables

  • PL SQL Varrays

  • PL SQL Records

• PL/SQL Triggers

• Oracle-Supplied Packages

• Using PL/SQL Large Objects in PL/SQL (LOBs) (BLOB, CLOB, NLOB)

• Using PL/SQL Object Oriented

• Using PL/SQL Compiler

• PL/SQL Performance & Tuning

• PL/SQL Caching

• PL/SQL Security

• PL/SQL Fine-Grained Access Control (VPD)

• PL/SQL Hints

• PL/SQL Object Dependencies

• Designing Better PL/SQL

• Using Java/C in PL/SQL

• Managing Dependencies

Important Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL

See you in the first lecture!