Turn what you know into an opportunity and reach millions around the world.

Your cart is empty.

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

A Comprehensive Guide to Make You a Job-Ready PL/SQL Developer.Also Covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics

Bestseller

Role Play

Created byDatabase Masters | 300,000+ Successful Students Worldwide, Code Star Academy

Last updated 2/2026

English

What you'll learn

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!

Course content

18 sections • 206 lectures • 26h 8m total length

Course Introductory Video4:28
UDEMY 101: How to Use Udemy? +Some Useful Tips5:01
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
What is PL/SQL and Why to Use?5:35
This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.
PL/SQL Architecture9:33
What is Pluggable Database?3:13
In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.
The Sample (HR) Schema Used in This Course7:14
Welcoming Gifts: Course Material & PL/SQL Cheatsheet0:30
Quiz 1

About the Database Installation3:02
The Ways to Get a Database14:50
In this SQL tutorial, the participants will learn how to get a database to proceed with The Complete PL/SQL Bootcamp: "Beginner to Advanced PL/SQL" course.
Option 1: Downloading Oracle Database 23ai The Virtual Machine Image (.ova) File2:18
In this PL SQL tutorial, the Complete PL SQL Bootcamp course participants will learn how to download the Oracle Database 23ai Virtual Machine Image (OVA) file, set up a fully functional database ready for use.
Option 1: Downloading and Installing VirtualBox3:14
In this PL SQL tutorial, the Complete Oracle PL SQL Bootcamp course participants will learn how to download and install the VirtualBox virtualization software, enabling them to use the image we downloaded in the previous lesson. This software will provide access to a pre-configured Linux operating system with an installed database, ready for use.
Option 1: Getting Started with VirtualBox: Setup and Configuration5:13
In this PL SQL tutorial, the Complete Oracle PL SQL Bootcamp participants will learn how to import the VirtualBox image we downloaded in the previous lesson into the VirtualBox software, ensuring a seamless setup and smooth operation.
Option 1: Configuring SQL Developer for the Virtual Machine11:46
In this PL SQL bootcamp tutorial, the Complete Oracle PL SQL Bootcamp participants will learn how to download and install the SQL Developer tool on their Windows machine, and connect it to a database running on a Linux server that we set up in previous lessons. The advantage of this setup is that we’ll use the pre-configured Linux image solely as the database server, while SQL Developer, installed on Windows, will handle the queries. This configuration enhances both performance and stability, allowing SQL Developer to run faster and more smoothly.
Option 1: Using SQL Developer with Virtual Machines4:19
In this PL SQL tutorial, the Complete PL SQL Bootcamp participants will learn how to use the SQL Developer tool to run queries and follow along with the course content.
Option 1: How to Install the Virtual Box on Mac OS X?1:51
Important Note0:43
For the students who could succeed to complete the Option-1
Option 2: Downloading and Installing the Oracle Database18:00
In this PL/SQL tutorial, the PL/SQL course participants will learn about the Oracle Database 19c installation.
Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".
Option 2: Unlocking the HR Schema7:34
In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.
Option 2: Configuring and Using the SQL Developer22:14
This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.
Option 2: Installing Sample Schemas in Oracle Database7:44
In this tutorial, the course participants will learn about the easiest way how to install Oracle Sample Schemas to be able to work with many database sample schemas provided by Oracle.
Option 2: HR Schema Create Code (if you could not get the HR user in other ways)32:33
This code includes the required SQL script to generate the HR schema with all its data.
Note 1: You can use this script if you could not have the HR schema properly.
Note 2: Just select all of the scripts and execute them in one step when connected as the SYS or SYSTEM user.
Option 3: Using Oracle Live SQL7:40
Option 3: About Oracle Live SQL Restrictions0:29

What are Variables and Why to Use Them?8:36
Naming Rules & Naming Conventions4:24
Declaring & Initializing & Using Variables - Part 110:44
In this lecture you will learn how to use variables with different ways.
Declaring & Initializing & Using Variables - Part 210:22
In this lecture you will learn how to use variables with different ways.
Declaring & Initializing & Using Variables (Code Samples)0:23
Using %TYPE Attribute7:07
In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.
Using %Type Attribute (Code Samples)0:06
PL/SQL Delimiters and Commenting Your Code5:36
In this lesson you will learn how to use delimiters and how to write comments and why to use them.
PL/SQL Delimiters and Commenting (Code Samples)0:07
PL SQL Variable Scope11:15
This lecture is about the scopes of variables in the blocks.
PL SQL Variable Scope (Code Samples)0:09
Using Bind Variables10:53
In this lesson you will learn a performance variable, bind variables.
Using Bind Variables (Code Samples)0:19
These are the codes that we used in Using Bind Variables Lesson
Quiz (Variables)

What are Control Structures & IF Statements13:57
What are Control Structures & IF Statements (Code Samples)0:34
Case Expressions14:48
In this lecture you will learn how to use case expressions and case statements in PL/SQL. These are the control structures like If statements.
Case Expressions (Code Samples)0:38
What are Loops - Basic Loops10:11
In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..
Basic Loops (Code Samples)0:13
While Loops5:32
In this lecture you will learn how to use while loops of PL/SQL..
While Loops (Code Samples)0:10
For Loops9:54
For Loops (Code Samples)0:08
Nested Loops & Loop Labeling16:00
In this lecture you will learn how to use a loop inside another one and exiting the outer loop with using labels in PL/SQL.
Nested Loops & Loop Labeling (Code Samples)0:27
Continue Statement10:23
In this lecture you will learn how to use continue statement in PL/SQL Loops
Continue Statement (Code Samples)0:27
GOTO Statement13:30
GOTO Statement (Code Samples)0:33
Here you will find the codes of the examples that we did in our GOTO Statement lecture..
Quiz (Control Structures)

Operating with Selected Database Data..18:26
In this lecture you will learn how to operate data that you queried from a table.
Operating With Selected Queries (Code Samples)0:35
DML Operations in PL/SQL12:46
In this lecture, you will see how to insert, update and delete data in your tables with the help of PL/SQL.
DML Operations in PL/SQL (Code Samples)0:19
Using Sequences in PL/SQL12:37
You will learn how to use sequence objects in PL/SQL
Using Sequences in PL/SQL (Code Samples)0:31
In this lecture you will learn how to use sequences in PL/SQL with different ways.
Extra - Enabling Server Outputs by Default4:39
In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.
Quiz (Using SQL in PL/SQL)

Simple Data Types vs Composite Data Types7:52
In this lecture you will learn the difference between scalar data types and complex data types.
PL/SQL Records - Part 116:40
PL/SQL Records - Part 216:30
In this lecture, you will learn how to create a complext type and a real-world like example about PL/SQL Records
PL/SQL Records (Code Samples)0:56
Easy DML With Records8:14
With this lecture, you will learn how to insert or update the data in your table with using records, easily.
Easy DML With Records (Code Samples)0:22
What Are Collections?6:14
In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.
Varrays & Collection Methods22:59
Varrays (Code Samples)1:39
Nested Tables10:57
Nested Tables (Code Samples)0:50
PL&SQL Associative Arrays (Part 1)18:54
PL&SQL Associative Arrays (Part 2)14:53
Associative Arrays (Code Samples)2:34
Storing Collections in Tables - (Part 1)14:07
Storing Collections in Tables - (Part 2)11:15
Storing Collections in Tables (Code Samples)1:13
Here is the code samples that we used in composite data types section.
Quiz (Composite Data Types)

What are Cursors and Cursor Types in PL SQL?8:05
Using Explicit Cursors11:13
Using Explicit Cursors (Code Samples)0:21
Using Cursors with Records6:11
In this lecture you will learn how to use PL SQL records with cursors including cursor type records.
Cursors with Records (Code Samples)0:22
Looping with Cursors12:16
In this lecture you will learn how to loop with PL SQL cursors in many different ways.
Looping with Cursors (Code Samples)0:46
In this article you will find the sample codes that we did in "Looping with Cursors" lecture
PL SQL Cursors with Parameters13:33
In this lecture you will learn how to use parameters with cursors. So you will use the same cursor with different parameters and you will get different results from the same cursor.
PL SQL Cursors with Parameters (Code Samples)1:36
In this article you will find the sample codes that we did in "Cursors with Parameters" lecture
PL SQL Cursor Attributes8:28
PL SQL Cursor Attributes (Code Samples)0:14
In this article you will find the sample codes that we did in "Cursor Attributes" lecture
For Update Clause20:32
In this lecture you will learn how to use the for update clause to lock the related rows
For Update Clause (Code Samples)0:39
Where Current Of Clause9:52
In this lecture you will learn how to update and delete the rows faster with using the wehre current of clause
Where Current Of Clause (Code Samples)0:31
Reference Cursors24:10
This lecture will be online today. It is processing and it takes some time.
Reference Cursors - (Code Samples)2:16
Here are the codes that we did in our lecture
Quiz (Cursors)
Mastering PL/SQL Cursors

What are the Exceptions?9:15
What are the Exceptions (Code Sample)0:03
Handling the Exceptions!17:55
Handling the Exceptions (Code Samples)1:26
Handling the Nonpredefined Exceptions6:24
Handling Nonpredefined Exceptions (Code Sample)0:10
Handling & Raising User-Defined Exceptions7:53
In this lecture you will learn how to handle the user-defined exceptions and raise an exception to its caller
Handling & Raising User-Defined Exceptions (Code Samples)0:51
Using RAISE_APPLICATION_ERROR() Procedure7:49
In this lecture you will learn how to raise an exception to the caller application with using pl sql raise_application_error procedure
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)0:33
Quiz (Exceptions)

What are Functions & Procedures and Why We Use?8:36
A brief description of the functions and procedures, and the difference between them and the anonymous blocks
What are Functions & Procedures and Why We Use (Code Samples)0:33
Creating and Using Stored Procedures16:51
Creating and Using Stored Procedures (Code Samples)0:44
Using IN & OUT Parameters14:34
In this lecture you will learn how to pass parameters to your procedures
Using IN & OUT Parameters (Code Samples)0:57
Named & Mixed Notations and Default Option16:25
Named & Mixed Notations and Default Option (Code Samples)0:33
Creating and Using Functions (Part 1)16:31
Creating and Using Functions (Part 2)7:21
Creating and Using PL/SQL Functions (Code Samples)0:19
Local Subprograms14:48
In this PL/SQL tutorial, the Complete PL/SQL Bootcamp course participants will learn why and how to create local functions and local procedures of PL SQL.
Local Subprograms (Code Samples)0:55
Overloading the Subprograms13:11
In this lecture you will learn how to overload the functions and procedures
Overloading the Subprograms (Code Samples)0:46
Handling the Exceptions in Subprograms19:42
Handling the Exceptions in Subprograms (Code Samples)0:52
Finding & Removing the Subprograms11:02
In this lecture you will learn how to find your subprograms and how to drop the functions & procedures
Regular & Pipelined Table Functions19:32
In this lecture you will learn how to query a function just like a table.
Regular & Pipelined Table Functions (Code Samples)0:32
Quiz (PL/SQL Functions & Procedures)

Requirements

Basic knowledge of Oracle SQL

Description

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!

Who this course is for:

Anyone who wants to learn PL/SQL Programming Language
Anyone who is looking for Beginner PL/SQL Subjects
Anyone who is looking for Advanced PL/SQL Subjects
Anyone who wants to pass "Oracle 1Z0-144 Program with PL/SQL" Exam
Anyone who wants to pass "Oracle 1Z0-148 Advanced PL/SQL" Exam
Anyone who wants to pass "Oracle 1Z0-149: Program with PL/SQL" Exam with Oracle Database 19c
SQL Developers (All Levels)
Beginner & Intermediate PL/SQL Developers
Database Administrators
Application Designers
Software Developers

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

What you'll learn

Explore related topics

Course content

What is PL/SQL ?7 lectures • 36min

Software Installation16 lectures • 2hr 24min

Let's Start Coding!2 lectures • 22min

PL/SQL Variables13 lectures • 1hr 10min

Control Structures16 lectures • 1hr 37min

Using SQL in PL/SQL7 lectures • 50min

Composite Data Types17 lectures • 2hr 36min

PL/SQL Cursors18 lectures • 2hr 1min

PL/SQL Exceptions10 lectures • 52min

PL/SQL Functions & Procedures20 lectures • 2hr 45min

Requirements

Description

Who this course is for: