Latest Course Updates:
-
(Dec 2023) : “Oracle-Supplied PL/SQL Packages” section was added!
-
(Sep 2023): “Using Dynamic SQL & PL/SQL in PL/SQL” section is added!
-
(May 2023) : High-Quality Closed-Captions are added!
-
(Apr 2023): New Quiz Questions are 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
-
While Loop
-
For Loop
-
Nested Loop
-
Loop Labeling
-
Continue Statement
-
GOTO Statement
-
-
-
Using SQL inside PL/SQL
-
PL/SQL Cursors
-
Using PL/SQL Program Units (Functions & Procedures)
-
PL/SQL Packages
-
PL/SQL Exceptions & Exception Handling
-
PL/SQL Debugging
-
Dynamic SQL & PL/SQL
-
PL/SQL Composite Data Types (Collections)
-
Associative Arrays
-
Nested Tables
-
Varrays
-
Records
-
-
PL/SQL Triggers
-
Oracle-Supplied Packages
-
Using Large Objects in PL/SQL (LOBs)
-
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!
Software Installation
-
1Course Introductory Video
-
2UDEMY 101: How to Use Udemy? +Some Useful Tips
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
-
3What is PL/SQL and Why to Use?
This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.
-
4PL/SQL Architecture
-
5What is Pluggable Database?
In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.
-
6The Sample (HR) Schema Used in This Course
-
7Welcoming Gifts: Course Material & PL/SQL Cheatsheet
-
8Quiz 1
This Quiz is about the first lecture. What is PL/SQL and Why to Use it and PL/SQL Architecture.
Let's Start Coding!
-
9About the Database Installation
-
10The Ways to Get a Database
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.
-
11Option 1: Installing VMware and VirtualBox on Windows
In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.
-
12Option 1: How to Install the Virtual Box on Mac OS X?
-
13Option 1: Downloading Virtual Machine Image(19c)
In this tutorial, the participants will learn how to download the virtual machine image 19c.
-
14Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
In this tutorial, the participants will learn how to download the virtual machine image.
-
15Option 1: Configuring the VMware Virtualization Software
In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.
-
16Option 1: Configuring the Oracle VirtualBox Virtualization Software
In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.
-
17Option 1: Configuring SQL Developer inside of the Virtual Machine
In this SQL tutorial, the participants will learn how to configure Oracle SQL Developer inside of the Virtual Machine image that they downloaded step by step.
-
18Important Note
For the students who could succeed to complete the Option-1
-
19Option 2: Downloading and Installing the Oracle Database
In this lecture, students are going to learn the oracle database 19c installation.
Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".
-
20Option 2: Unlocking the HR Schema
In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.
-
21Option 2: Configuring and Using the SQL Developer
This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.
-
22Option 2: Installing Sample Schemas in Oracle Database
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.
-
23Option 2: HR Schema Create Code (if you could not get the HR user in other ways)
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.
-
24Option 3: Using Oracle Live SQL
-
25Option 3: About Oracle Live SQL Restrictions
PL/SQL Variables
Control Structures
-
29What are Variables and Why to Use Them?
-
30Naming Rules & Naming Conventions
-
31Declaring & Initializing & Using Variables - Part 1
In this lecture you will learn how to use variables with different ways.
-
32Declaring & Initializing & Using Variables - Part 2
In this lecture you will learn how to use variables with different ways.
-
33Declaring & Initializing & Using Variables (Code Samples)
-
34Using %TYPE Attribute
In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.
-
35Using %Type Attribute (Code Samples)
-
36PL/SQL Delimiters and Commenting Your Code
In this lesson you will learn how to use delimiters and how to write comments and why to use them.
-
37PL/SQL Delimiters and Commenting (Code Samples)
-
38PL SQL Variable Scope
This lecture is about the scopes of variables in the blocks.
-
39PL SQL Variable Scope (Code Samples)
-
40Using Bind Variables
In this lesson you will learn a performance variable, bind variables.
-
41Using Bind Variables (Code Samples)
These are the codes that we used in Using Bind Variables Lesson
-
42Quiz (Variables)
In this quiz, you will find multiple choice questions about the PL/SQL Variables.
Using SQL in PL/SQL
-
43What are Control Structures & IF Statements
-
44What are Control Structures & IF Statements (Code Samples)
-
45Case Expressions
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.
-
46Case Expressions (Code Samples)
-
47What are Loops - Basic Loops
In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..
-
48Basic Loops (Code Samples)
-
49While Loops
In this lecture you will learn how to use while loops of PL/SQL..
-
50While Loops (Code Samples)
-
51For Loops
-
52For Loops (Code Samples)
-
53Nested Loops & Loop Labeling
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.
-
54Nested Loops & Loop Labeling (Code Samples)
-
55Continue Statement
In this lecture you will learn how to use continue statement in PL/SQL Loops
-
56Continue Statement (Code Samples)
-
57GOTO Statement
-
58GOTO Statement (Code Samples)
Here you will find the codes of the examples that we did in our GOTO Statement lecture..
-
59Quiz (Control Structures)
In this quiz you will find multiple choice quiz questions about the control strucures like if clause, loops, etc.
Composite Data Types
-
60Operating with Selected Database Data..
In this lecture you will learn how to operate data that you queried from a table.
-
61Operating With Selected Queries (Code Samples)
-
62DML Operations in PL/SQL
In this lecture, you will see how to insert, update and delete data in your tables with the help of PL/SQL.
-
63DML Operations in PL/SQL (Code Samples)
-
64Using Sequences in PL/SQL
You will learn how to use sequence objects in PL/SQL
-
65Using Sequences in PL/SQL (Code Samples)
In this lecture you will learn how to use sequences in PL/SQL with different ways.
-
66Extra - Enabling Server Outputs by Default
In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.
-
67Quiz (Using SQL in PL/SQL)
This quiz will test your knowledge on using SQL in PL/SQL code
PL/SQL Cursors
-
68Simple Data Types vs Composite Data Types
In this lecture you will learn the difference between scalar data types and complex data types.
-
69PL/SQL Records - Part 1
-
70PL/SQL Records - Part 2
In this lecture, you will learn how to create a complext type and a real-world like example about PL/SQL Records
-
71PL/SQL Records (Code Samples)
-
72Easy DML With Records
With this lecture, you will learn how to insert or update the data in your table with using records, easily.
-
73Easy DML With Records (Code Samples)
-
74What Are Collections?
In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.
-
75Varrays & Collection Methods
-
76Varrays (Code Samples)
-
77Nested Tables
-
78Nested Tables (Code Samples)
-
79PL&SQL Associative Arrays (Part 1)
-
80PL&SQL Associative Arrays (Part 2)
-
81Associative Arrays (Code Samples)
-
82Storing Collections in Tables - (Part 1)
-
83Storing Collections in Tables - (Part 2)
-
84Storing Collections in Tables (Code Samples)
Here is the code samples that we used in composite data types section.
-
85Quiz (Composite Data Types)
This quiz will test your knowledge on using Composite Data Types in PL/SQL