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

4.49 (15173 reviews)
Udemy
platform
English
language
Databases
category
82,350
students
26.5 hours
content
Jan 2024
last update
$149.99
regular price

What you will 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!

Description

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!

Content

What is PL/SQL ?

Course Introductory Video
UDEMY 101: How to Use Udemy? +Some Useful Tips
What is PL/SQL and Why to Use?
PL/SQL Architecture
The Sample (HR) Schema Used in This Course
Bonus Materials : Course Material & PL/SQL Cheatsheet
Quiz 1

Software Installation

About the Database Installation
Which Option to Have a Database?
Option 1: Having the Database with the Oracle Virtual Box
Option 1: How to Install the Virtual Box on Mac OS X?
What is Pluggable Database?
Option 2: Downloading and Installing the Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using the SQL Developer
Option 3: Using Oracle Live SQL
Option 3: About Oracle Live SQL Restrictions

Let's Start Coding!..

Anonymous Blocks
PL/SQL Outputs
Quiz 2

PL/SQL Variables

What are Variables and Why to Use Them?
Naming Rules & Naming Conventions
Declaring & Initializing & Using Variables - Part 1
Declaring & Initializing & Using Variables - Part 2
Declaring & Initializing & Using Variables (Code Samples)
Using %TYPE Attribute
Using %Type Attribute (Code Samples)
PL/SQL Delimiters and Commenting Your Code
PL/SQL Delimiters and Commenting (Code Samples)
PL SQL Variable Scope
PL SQL Variable Scope (Code Samples)
Using Bind Variables
Using Bind Variables (Code Samples)
Quiz 3 - Variables

Control Structures

What are Control Structures & IF Statements
What are Control Structures & IF Statements (Code Samples)
Case Expressions
Case Expressions (Code Samples)
What are Loops - Basic Loops
Basic Loops (Code Samples)
While Loops
While Loops (Code Samples)
For Loops
For Loops (Code Samples)
Nested Loops & Loop Labeling
Nested Loops & Loop Labeling (Code Samples)
Continue Statement
Continue Statement (Code Samples)
GOTO Statement
GOTO Statement (Code Samples)
Quiz 4 - Control Structures

Using SQL in PL/SQL

Operating with Selected Database Data..
Operating Wİth Selected Queries (Code Samples)
DML Operations in PL/SQL
DML Operations in PL/SQL (Code Samples)
Using Sequences in PL/SQL
Using Sequences in PL/SQL (Code Samples)
Bonus - Enabling Server Outputs by Default.
Quiz 5 - Using SQL in PL/SQL

Composite Data Types

Simple Data Types vs Composite Data Types
PL/SQL Records - Part 1
PL/SQL Records - Part 2
PL/SQL Records (Code Samples)
Easy DML With Records
Easy DML With Records (Code Samples)
What Are Collections?
Varrays & Collection Methods
Varrays (Code Samples)
Nested Tables
Nested Tables (Code Samples)
PL&SQL Associative Arrays (Part 1)
PL&SQL Associative Arrays (Part 2)
Associative Arrays (Code Samples)
Storing Collections in Tables - (Part 1)
Storing Collections in Tables - (Part 2)
Storing Collections in Tables (Code Samples)
Quiz 6 - Composite Data Types

PL/SQL Cursors

What are Cursors and Cursor Types in PL SQL?
Using Explicit Cursors
Using Explicit Cursors (Code Samples)
Using Cursors with Records
Cursors with Records (Code Samples)
Looping with Cursors
Looping with Cursors (Code Samples)
PL SQL Cursors with Parameters
PL SQL Cursors with Parameters (Code Samples)
PL SQL Cursor Attributes
PL SQL Cursor Attributes (Code Samples)
For Update Clause
For Update Clause (Code Samples)
Where Current Of Clause
Where Current Of Clause (Code Samples)
Reference Cursors
Reference Cursors - (Code Samples)

PL/SQL Exceptions

What are the Exceptions?
What are the Exceptions (Code Sample)
Handling the Exceptions!
Handling the Exceptions (Code Samples)
Handling the Nonpredefined Exceptions
Handling Nonpredefined Exceptions (Code Sample)
Handling & Raising User-Defined Exceptions
Handling & Raising User-Defined Exceptions (Code Samples)
Using RAISE_APPLICATION_ERROR() Procedure
Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)

PL/SQL Functions & Procedures

What are Functions & Procedures and Why We Use?
What are Functions & Procedures and Why We Use (Code Samples)
Creating and Using Stored Procedures
Creating and Using Stored Procedures (Code Samples)
Using IN & OUT Parameters
Using IN & OUT Parameters (Code Samples)
Named & Mixed Notations and Default Option
Named & Mixed Notations and Default Option (Code Samples)
Creating and Using Functions (Part 1)
Creating and Using Functions (Part 2)
Creating and Using PL/SQL Functions (Code Samples)
Local Subprograms
Local Subprograms (Code Samples)
Overloading the Subprograms
Overloading the Subprograms (Code Samples)
Handling the Exceptions in Subprograms
Handling the Exceptions in Subprograms (Code Samples)
Finding & Removing the Subprograms
Regular & Pipelined Table Functions
Regular & Pipelined Table Functions (Code Samples)

PL/SQL Packages

What Are Packages?
Creating & Using & Modifying & Removing the Packages
Creating & Using & Modifying & Removing the Packages (Code Samples)
Visibility of Package Objects
Visibility of Package Objects (Code Samples)
Illegal Object Reference & Forward Declaration
Package Initialization
Persistent State of Packages - Part 1
Persistent State of Packages - Part 2
Persistent State of Packages (Code Samples)
Using Collections in Packages - Part 1
Using Collections in Packages - Part 2
Using Collections in Packages (Code Samples)
How Can I Find the Packages?

PL/SQL Triggers

What are Triggers & Trigger Types
Understanding DML Triggers
Specifying the Timing of Triggers
Specifying the Timing of Triggers (Code Samples)
Statement & Row Level Triggers
Statement & Row Level Triggers (Code Samples)
Using New & Old Qualifiers in Triggers
Using New & Old Qualifiers in Triggers (Code Samples)
Using Conditional Predicates
Using Conditional Predicates (Code Samples)
Using RAISE_APPLICATION_ERROR Procedure in Triggers
Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)
Using Update Of Event in Triggers
Using Update Of Event in Triggers (Code Samples)
Using WHEN Clause in Triggers
Using When Clause in Triggers (Code Samples)
INSTEAD OF Triggers
Instead of Triggers (Code Samples)
Exploring & Managing the Triggers
Creating Disabled Triggers
Creating Disabled Triggers (Code Samples)
Additional Real-World Examples for DML Triggers
Additional Real-World Examples for DML Triggers (Code Samples)
Compound Triggers
Compound Triggers (Code Samples)
Handling Mutating Table Errors
Handling Mutating Table Errors (Code Samples)

PL/SQL Debugging: Debugging Your Codes & Subprograms

PL/SQL Debugging: Debugging Your Subprograms - (Part 1)
PL/SQL Debugging: Debugging Your Subprograms - (Part 2)
PL/SQL Debugging: Debugging Your Subprograms - (Part 3)
Granting Debug Privileges to a User
PL/SQL Debugging: Debugging the Anonymous Blocks
Source Code: Debugging the Anonymous Blocks

Using Dynamic SQL in PL/SQL!

For Your Attention!..

Using PL/SQL Objects

On Production

Using PL/SQL Compiler

On Production

Using Large Objects(LOB) in PL/SQL

Thank you for your understanding..

PL/SQL Performance & Tuning

On Production

Bonus (+) Section

Bonus (+) Lecture: Special Discounts for Our Students!

Appendix

Appendix 1: Oracle Database 12c Installation into Your Computer
Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?
Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c

Screenshots

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Screenshot_01The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Screenshot_02The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Screenshot_03The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Screenshot_04

Reviews

Michael
October 24, 2023
Great course with valuable code snippets. However, the instructor's accent is a little hard to understand when putting the video on higher speeds. (at least in the beginning)
Lino
October 23, 2023
Il corso è molto interessante poichè mi consente di approfondire ed ampliare le mie conoscenze nell'ambito dell'attività lavorativa che è rivolta allo sviluppo ed analisi di applicazioni che utilizzano data base relazionali.
Sachin
October 16, 2023
Very good course for the beginner ,explained all the topics in detail with Very good examples. Thanks Udemy for the wonderful course
Sila
August 30, 2023
instructors voice is not clear, transcripts are very wrong i found it very difficult to understand what he was trying to say at some much parts
Bereket
August 28, 2023
I am a software engineer at KNAPP, Currently i'm working in the oracle database and i need to know more about data manipulation language like pl\sql in the advanced way.
Francisco
August 25, 2023
porque desde el inicio del curso, explica como utilizar su espacio de trabajo y veo que las clases serán interactivas en lo suceso y explica con mucha claridad.
Sudipta
August 8, 2023
a realtime short project that boost my cofidence level is needed.so i suggest some good projects can be done
Carlos
August 7, 2023
Só não dei 5 estrelas porque o curso está incompleto - vários módulos propostos ainda não foram publicados. Mas apesar disso a explicação do instrutor é excelente, simples e objetiva.
Tracy
August 1, 2023
It's supposed to be modern and he doesn't mention Bulk and For-All at all. Completely disappointed -- will toss this one. So annoyed that I paid for this. Plus - he stole Steven Feuerstein's line. Ugh -- worst PL/SQL class ever.
Vipin
February 13, 2023
Detailed explanation, one can easily understand the use cases for each and with little practice one can get strong in all the concepts.
Péter
February 7, 2023
The course was clear and easy to understand. Coding challanges would be a nice addition to the course in my opinion.
Pratik
February 5, 2023
Some example taken are a bit harder to understand as a fresher to this course. Might have explain the same concept using simple and easy examples.
Abhishek
January 24, 2023
it Was an amazing course and it covered every bits of PLSQL i guess and it helped me a lot in my real working life.
Jenine
January 15, 2023
So far, I'm finding it a bit difficult to follow along with the instructor due to his accent. The quizzes are also a bit tricky because of the way they are phrased. I don't know if that's because of the English / language or, because that's the way he really wanted the questions worded. I'll press on and hope things improve.
Anja
January 4, 2023
Im taking this course as a brush-up after being away from Oracle some years And i do like the speed. It's detailed but not overly slow and focus on practical lots coding examples. I really enjoy it. I would like some more code challenges to try out tho - to practice each chapter without being guided.

Charts

Price

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Price chart

Rating

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Ratings chart

Enrollment distribution

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL" - Distribution chart
1312466
udemy ID
8/4/2017
course created date
11/22/2019
course indexed date
Bot
course submited by