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 SQL & PL/SQL Tuning (3 days)

Audience: An ideal course for anyone who wants to learn about the various tuning methods available for SQL and PL/SQL and to gain a better understanding of how the optimizer works.
 
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Database Architecture overview

Introducing the optimizer

Optimizer Operations

Displaying Execution plans

Using TKPROF and TRCSESS

Identifying High Load SQL

Understand Basic Tuning Techniques

Optimizer Hints and Result Cache

SQL Plan Management

PL/SQL Tuning

Profiling PL/SQL Applications

Warnings