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

Latest Course Updates: (Oct 2025) : Installing Oracle Database 23 AI section was added! (Brand New!) (Aug 2025) : "Oracle-Supplied PL/SQL Packages" section was added! (May 2025): "Using Dynamic SQL & PL/SQL in PL/SQL" section was added! (Feb 2025) : High-Quality Closed-Captions were added! (Dec 2024): New PL/SQL Quiz Questions were 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 - PL SQL While Loop - PL SQL For Loop - PL SQL Nested Loop - PL SQL Loop Labeling - PL SQL Continue Statement - PL SQL GOTO Statement - Using SQL inside PL/SQL - PL/SQL Cursors - Using PL/SQL Program Units (Functions & Procedures in PL/SQL) - PL/SQL Packages - PL/SQL Exceptions & Exception Handling - PL/SQL Debugging - Dynamic SQL & PL/SQL - PL/SQL Composite Data Types (Collections) - PL SQL Associative Arrays - PL SQL Nested Tables - PL SQL Varrays - PL SQL Records - PL/SQL Triggers - Oracle-Supplied Packages - Using PL/SQL Large Objects in PL/SQL (LOBs) (BLOB, CLOB, NLOB) - 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 our knowledge of Oracle PL/SQL See you in the first lecture!

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!