Udemy

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

Name: The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"
Price: 139.99 USD
Availability: InStock
Rating: 4.5 (21353 reviews)

4.5(21,353)112k students

Korshub's take

PL/SQL from basics to oracle certification

If you're working toward Oracle certification (1Z0-149, 1Z0-148, or 1Z0-144), this bootcamp covers the full journey from beginner through advanced. The course teaches every major PL/SQL topic — variables, control structures, cursors, packages, triggers, exceptions, dynamic SQL, and even object-oriented approaches.

What sets it apart is the continuous update cycle: oracle database 23 AI tools were added in December 2025, oracle-supplied packages in August. Each section uses real-world examples, so you're not learning theory in a vacuum. Whether you're preparing for the exam or deepening production skills, the breadth and hands-on focus make it a complete reference.

About this course

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!