Application Express (APEX)

Introduction to APEX
Intermediate APEX
APEX Administration
APEX New Features

Languages

Oracle SQL Fundamentals
Oracle SQL Querying
Intermediate Oracle SQL
Introduction to PL/SQL
Intermediate PL/SQL
Advanced PL/SQL
Fast track PL/SQL

New Features for Developers

9i New features
10g New features
11g New features

Miscellaneous

Tuning for Developers
SQL Developer

Customised Courses

Oracle 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)