Oracle Database 19c: PL/SQL Workshop Course Overview

The Oracle Database 19c: PL/SQL Workshop is a comprehensive course designed to introduce learners to the fundamentals and advanced features of PL/SQL, a procedural language extension for SQL provided by Oracle. The course begins with an introduction to PL/SQL and progresses through a series of modules that cover everything from Declaring variables and Writing executable statements to creating complex Stored procedures, Functions, Packages, and Triggers.

Participants will learn how to enhance the capabilities of SQL with PL/SQL programming constructs, Control structures, Exception handling, and the use of Oracle-supplied Packages. The workshop also delves into Dynamic SQL, design considerations, PL/SQL code tuning, and Managing dependencies to ensure efficient and maintainable database applications. By the end of the course, learners will have a strong foundation in PL/SQL, enabling them to write robust database-centric programs and optimize their performance, which is crucial for professional development in the field of database administration and development.