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

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!

Latest Course Updates:

• (Aug2024) : "Oracle-Supplied PL/SQLPackages" section was added!

• (Jun 2024): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

• (May 2024) : High-Quality Closed-Captions are added!

• (Apr 2024): New Quiz Questions are added!

Become an Oracle Database PL/SQL Developer Certified Professional!

This comprehensive PL/SQLProgramming 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/SQLCoding Skills

• SQL & PL/SQL Performance

• PL/SQLScalability

• 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/SQLProgramming Bootcamp Covers:

• PL/SQL Terminologies

• PL/SQLArchitecture

• PL/SQL Variables

• PL/SQLControl Structures

  • If-Then-Else Structure

  • Case Expressions

  • Loops

    • While Loop

    • For Loop

    • Nested Loop

    • Loop Labeling

    • Continue Statement

    • GOTOStatement

• Using SQL inside PL/SQL

• PL/SQLCursors

• Using PL/SQLProgram Units (Functions & Procedures)

• PL/SQLPackages

• PL/SQLExceptions &Exception Handling

• PL/SQL Debugging

• Dynamic SQL & PL/SQL

• PL/SQLComposite Data Types (Collections)

  • Associative Arrays

  • Nested Tables

  • Varrays

  • Records

• PL/SQLTriggers

• Oracle-Supplied Packages

• Using Large Objects in PL/SQL(LOBs)

• Using PL/SQL Object Oriented

• Using PL/SQL Compiler

• PL/SQLPerformance &Tuning

• PL/SQLCaching

• PL/SQLSecurity

• PL/SQLFine-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!