Course Outline

•     Declaring PL/SQL Variables
•     Writing Executable Statements
•     Using SQL Statements Within a PL/SQL Block
•     Writing Control Structures
•     Working with Composite Data Types
•     Using Explicit Cursors
•     Handling Exceptions
•     Creating Procedures and Functions
•     Debugging Subprograms
•     Creating and working with Packages
•     Using Oracle-Supplied Packages in Application Development
•     Using Dynamic SQL
•     Creating Compound, DDL, and Event Database Triggers
•     Design Considerations for the PL/SQL Code
•     Tuning the PL/SQL Compiler
•     Managing Dependencies
•     Using SQL Developer and SQL*Plus
•     Commonly Used SQL Commands
•     REF Cursors
•     Managing PL/SQL Code
•     Implementing Triggers
•     Using the DBMS_SCHEDULER and HTP Packages