Course Brief:

This comprehensive course provides foundational knowledge in PL/SQL programming, Oracle database development, and database application creation. Students will learn essential PL/SQL programming skills including procedures, functions, packages, triggers, exception handling, and performance optimization. The course is designed for individuals seeking to develop their database programming capabilities and prepare for Oracle development roles.

Course Structure:

Fundamentals
Defining Variables and Datatypes
Using SQL in PL/SQL
Program Structures to Control Execution Flow
Using Cursors and Parameters
Using Composite Datatypes
Exception Handling
Using and Managing Procedures
Using and Managing Functions
Using and Managing Packages
Getting the Best Out of Packages
Improving PL/SQL Performance
Using and Managing Triggers
Recognizing and Managing Dependencies
Using the PL/SQL Compiler