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

Descripción

Latest Course Updates: • (Sep, 2026) : Installing Oracle Database 23 AI section was added! (Brand New!) • (Aug 2026) : "Oracle-Supplied PL/SQL Packages" section was added! • (May 2026): "Using Dynamic SQL & PL/SQL in PL/SQL" section was added! • (Feb 2026) : High-Quality Closed-Captions were added! • (Dec 2025): 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 your knowledge of Oracle PL/SQL See you in the first lecture!

Lo que aprenderás

• 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!

Requisitos

• Basic knowledge of Oracle SQL