Oracle Fast Track PL/SQL  (4 days)

Audience: A fast track course for anyone who wants a good grounding in PL/SQL – covering commonly used topics from introductory level through to advanced level
 
Pre-requisites: A good knowledge of SQL

Course content:

Introduction to PL/SQL

Declaring and using variables

Interacting with the Oracle Server

Writing Control Structures

Working with Composite Data Types

Using Explicit Cursors

Handling Exceptions

Creating Stored Procedures

Creating Stored Functions

Creating Packages

Working With Packages

Creating Triggers

Creating Compound, DDL, and Event Database Triggers

Using Collections

Implementing VPD with Fine-Grained Access Control

Tuning and Performance

Improving Performance with PL/SQL Caching (11g only)