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

15,862 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

15,862 students enrolled

Created by Oracle Master Training • 60,000+ Students Worldwide, Code Star Academy

Last updated 8/2020

English

English [Auto], Polish [Auto]

Preview this course

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

$139.99 $199.99 30% off

5 hours left at this price!

30-Day Money-Back Guarantee

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

+ – 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:10:02

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:19

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

10 more sections

Requirements

Basic knowledge of Oracle SQL

Description

Last Updates (Aug, 2020):

★ (Brand New!) "Using Dynamic SQL & PL/SQL in PL/SQL" sections are added!

★ 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