Overview

Latest Course Updates: (May 2025): "Oracle-Supplied PL/SQL Packages" section was added!(Feb 2025): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!(Jan 2025): High-Quality Closed-Captions are added!(Dec 2024): 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 ScalabilityPortability and Security of Database and PL/SQL ProgrammingAnd also our students will be prepared for:(NEW!) Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL Oracle Certification ExamExam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL Oracle Certification ExamExam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL Oracle Certification ExamExam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL Oracle Certification ExamOur PL/SQL Programming Bootcamp Covers:PL/SQL TerminologiesPL/SQL ArchitecturePL/SQL VariablesPL/SQL Control StructuresIf-Then-Else StructureCase ExpressionsLoops While LoopFor LoopNested LoopLoop LabelingContinue StatementGOTO StatementUsing SQL inside PL/SQLPL/SQL CursorsUsing PL/SQL Program Units (Functions & Procedures)PL/SQL PackagesPL/SQL Exceptions & Exception Handling PL/SQL DebuggingDynamic SQL & PL/SQLPL/SQL Composite Data Types (Collections)Associative ArraysNested TablesVarraysRecordsPL/SQL TriggersOracle-Supplied PackagesUsing Large Objects in PL/SQL (LOBs)Using PL/SQL Object OrientedUsing PL/SQL CompilerPL/SQL Performance &TuningPL/SQL CachingPL/SQL SecurityPL/SQL Fine-Grained Access Control (VPD)PL/SQL HintsPL/SQL Object DependenciesDesigning Better PL/SQLUsing Java/C in PL/SQLManaging DependenciesImportant Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQLSee you in the first lecture!

Skills

Reviews