Development
Databases
Pl/SQL
The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"
4.4 (2,400 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,672 students enrolled

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

A Full-Real Guide to Make You a Real PL/SQL Developer! Also covers "Oracle 1Z0-144 and 1Z0-148" PL SQL Exams Completely!
Bestseller
4.4 (2,393 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
13,672 students enrolled
Created by Oracle Master Training • 60,000+ Students Worldwide, Code Star Academy
Last updated 2/2020
English
English [Auto-generated], Indonesian [Auto-generated], 3 more
  • Polish [Auto-generated]
  • Romanian [Auto-generated]
  • Thai [Auto-generated]
Preview this course
The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 20.5 hours on-demand video
  • 72 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Pass the Oracle 1Z0-144 : 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
  • Using SQL Developer Efficiently for PL/SQL
  • Improving Performance & Security of Your Codes
  • PL/SQL Architecture
  • Creating Dynamic Queries
  • Use PL/SQL Like Object Oriented Programming.
  • PL/SQL Tuning
Course content
Expand all 174 lectures 21:06:42
+ – What is PL/SQL ?
6 lectures 32:20
Course Introductory Video
Preview 04:28

This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.

UDEMY 101: How to Use Udemy? +Some Useful Tips
05:01

This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.

What is PL/SQL and Why to Use?
Preview 05:35
PL/SQL Architecture
09:33
The Sample (HR) Schema Used in This Course
07:14
Bonus Materials : Course Material & PL/SQL Cheatsheet
00:29

This Quiz is about the first lecture. What is PL/SQL and Why to Use it and PL/SQL Architecture.

Quiz 1
5 questions
+ – Software Installation
10 lectures 01:29:40
About the Database Installation
Preview 03:02
Which Option to Have a Database?
09:09

This lecture shows how to get Oracle database without installing, downloading and much more efforts.

We've prepared a virtual machine that contains a completely running Oracle database in it for you.

So you don't need to install Oracle database at all.

All you have to do is just to install the Oracle Virtual Box image.

Then, you'll get your database easily.

Option 1: Having the Database with the Oracle Virtual Box
16:29
Option 1: How to Install the Virtual Box on Mac OS X?
01:41

In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.

What is Pluggable Database?
03:13

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".

Option 2: Downloading and Installing the Oracle Database
18:18

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

Option 2: Unlocking the HR Schema
07:34

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

Option 2: Configuring and Using the SQL Developer
22:14
Option 3: Using Oracle Live SQL
07:40
Option 3: About Oracle Live SQL Restrictions
00:20
+ – Let's Start Coding!..
2 lectures 22:01
Anonymous Blocks
13:42
PL/SQL Outputs
08:19

This Quiz is about the anonymous blocks and PL/SQL Outputs

Quiz 2
6 questions
+ – PL/SQL Variables
13 lectures 01:09:55
What are Variables and Why to Use Them?
08:36
Naming Rules & Naming Conventions
04:24

In this lecture you will learn how to use variables with different ways.

Declaring & Initializing & Using Variables - Part 1
10:44

In this lecture you will learn how to use variables with different ways.

Declaring & Initializing & Using Variables - Part 2
10:22
Declaring & Initializing & Using Variables (Code Samples)
00:23

In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.

Using %TYPE Attribute
07:07
Using %Type Attribute (Code Samples)
00:06

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 Your Code
05:36
PL/SQL Delimiters and Commenting (Code Samples)
00:07

This lecture is about the scopes of variables in the blocks.

PL SQL Variable Scope
11:15
PL SQL Variable Scope (Code Samples)
00:09

In this lesson you will learn a performance variable, bind variables.

Using Bind Variables
10:53

These are the codes that we used in Using Bind Variables Lesson

Using Bind Variables (Code Samples)
00:11

In this quiz, you will find multiple choice questions about the PL/SQL Variables.

Quiz 3 - Variables
10 questions
+ – Control Structures
16 lectures 01:36:42
What are Control Structures & IF Statements
13:57
What are Control Structures & IF Statements (Code Samples)
00:27

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
14:48
Case Expressions (Code Samples)
00:32

In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..

What are Loops - Basic Loops
Preview 10:11
Basic Loops (Code Samples)
00:08

In this lecture you will learn how to use while loops of PL/SQL..

While Loops
05:32
While Loops (Code Samples)
00:06
For Loops
09:54
For Loops (Code Samples)
00:04

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
16:00
Nested Loops & Loop Labeling (Code Samples)
00:21

In this lecture you will learn how to use continue statement in PL/SQL Loops

Continue Statement
10:23
Continue Statement (Code Samples)
00:20
GOTO Statement
13:30

Here you will find the codes of the examples that we did in our GOTO Statement lecture..

GOTO Statement (Code Samples)
00:26

In this quiz you will find multiple choice quiz questions about the control strucures like if clause, loops, etc.

Quiz 4 - Control Structures
10 questions
+ – Using SQL in PL/SQL
7 lectures 50:05

In this lecture you will learn how to operate data that you queried from a table.

Operating with Selected Database Data..
18:26
Operating Wİth Selected Queries (Code Samples)
00:27

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
12:46
DML Operations in PL/SQL (Code Samples)
00:12

You will learn how to use sequence objects in PL/SQL

Using Sequences in PL/SQL
12:37

In this lecture you will learn how to use sequences in PL/SQL with different ways.

Using Sequences in PL/SQL (Code Samples)
00:57

In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.

Bonus - Enabling Server Outputs by Default.
04:39
Quiz 5 - Using SQL in PL/SQL
3 questions
+ – Composite Data Types
17 lectures 02:34:34

In this lecture you will learn the difference between scalar data types and complex data types.

Simple Data Types vs Composite Data Types
07:52
PL/SQL Records - Part 1
16:40

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 - Part 2
Preview 16:30
PL/SQL Records (Code Samples)
00:37

With this lecture, you will learn how to insert or update the data in your table with using records, easily.

Easy DML With Records
08:14
Easy DML With Records (Code Samples)
00:18

In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.

What Are Collections?
06:14
Varrays & Collection Methods
22:59
Varrays (Code Samples)
01:21
Nested Tables
10:57
Nested Tables (Code Samples)
00:41
PL&SQL Associative Arrays (Part 1)
18:54
PL&SQL Associative Arrays (Part 2)
14:53
Associative Arrays (Code Samples)
02:12
Storing Collections in Tables - (Part 1)
14:07
Storing Collections in Tables - (Part 2)
11:15

Here is the code samples that we used in composite data types section.

Storing Collections in Tables (Code Samples)
00:49
Quiz 6 - Composite Data Types
15 questions
+ – PL/SQL Cursors
17 lectures 02:00:51
What are Cursors and Cursor Types in PL SQL?
08:05
Using Explicit Cursors
11:13
Using Explicit Cursors (Code Samples)
00:21

In this lecture you will learn how to use PL SQL records with cursors including cursor type records.

Using Cursors with Records
06:11
Cursors with Records (Code Samples)
00:22

In this lecture you will learn how to loop with PL SQL cursors in many different ways. 

Looping with Cursors
12:16

In this article you will find the sample codes that we did in "Looping with Cursors" lecture

Looping with Cursors (Code Samples)
00:46

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
13:33

In this article you will find the sample codes that we did in "Cursors with Parameters" lecture

PL SQL Cursors with Parameters (Code Samples)
01:36
PL SQL Cursor Attributes
08:28

In this article you will find the sample codes that we did in "Cursor Attributes" lecture

PL SQL Cursor Attributes (Code Samples)
00:14

In this lecture you will learn how to use the for update clause to lock the related rows

For Update Clause
20:32
For Update Clause (Code Samples)
00:39

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
09:52
Where Current Of Clause (Code Samples)
00:31

This lecture will be online today. It is processing and it takes some time.

Reference Cursors
24:10

Here are the codes that we did in our lecture

Reference Cursors - (Code Samples)
02:00
+ – PL/SQL Exceptions
10 lectures 52:15
What are the Exceptions?
09:15
What are the Exceptions (Code Sample)
00:03
Handling the Exceptions!
17:55
Handling the Exceptions (Code Samples)
01:26
Handling the Nonpredefined Exceptions
06:24
Handling Nonpredefined Exceptions (Code Sample)
00:10

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
07:53
Handling & Raising User-Defined Exceptions (Code Samples)
00:45

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
Preview 07:49
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
00:33
+ – PL/SQL Functions & Procedures
20 lectures 02:44:41

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?
08:36
What are Functions & Procedures and Why We Use (Code Samples)
00:33
Creating and Using Stored Procedures
16:51
Creating and Using Stored Procedures (Code Samples)
00:44

In this lecture you will learn how to pass parameters to your procedures

Using IN & OUT Parameters
14:34
Using IN & OUT Parameters (Code Samples)
00:57
Named & Mixed Notations and Default Option
16:25
Named & Mixed Notations and Default Option (Code Samples)
00:33
Creating and Using Functions (Part 1)
16:31
Creating and Using Functions (Part 2)
07:21
Creating and Using PL/SQL Functions (Code Samples)
00:19

In this lecture you will learn why and how to create local functions and local procedures of PL SQL

Local Subprograms
14:48
Local Subprograms (Code Samples)
00:48

In this lecture you will learn how to overload the functions and procedures

Overloading the Subprograms
13:11
Overloading the Subprograms (Code Samples)
00:46
Handling the Exceptions in Subprograms
19:42
Handling the Exceptions in Subprograms (Code Samples)
00:52

In this lecture you will learn how to find your subprograms and how to drop the functions & procedures

Finding & Removing the Subprograms
11:02

In this lecture you will learn how to query a function just like a table.

Regular & Pipelined Table Functions
19:32
Regular & Pipelined Table Functions (Code Samples)
00:32
Requirements
  • Basic knowledge of Oracle SQL
Description

Updates:

★ Closed Captions are added!

★ New Quizzes are added!

This course is created for a 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 knows PL/SQL. Every student who wants to learn or become a hero in PL/SQL will find everything that they look for. 

Students will learn and increase their:

  • PL/SQL Coding Skills

  • SQL & PL/SQL Performance

  • PL/SQL Scalability

  • Portability and Security about Database and PL/SQL

And also students will be prepared for;

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

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

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

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 want to pass "Oracle 1Z0-144 Program with PL/SQL" Exam
  • Anyone who want to pass "Oracle 1Z0-148 Advanced PL/SQL" Exam
  • SQL Developers (All Levels)
  • Beginner & Intermediate PL/SQL Developers
  • Database Administrators
  • Application Designers
  • Software Developers