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 and PL/SQL : 11g New Features (1 day)

Audience: An ideal course for anyone who wants to learn the new features of Oracle 10g SQL and PL/SQL.
 
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Language Functionality Enhancements

Performance Enhancements

PL/SQL Language Enhancements

Trigger Enhancements

SecureFile LOBs

PIVOT and UNPIVOT Clauses of the SELECT Statement

Edition-Based Redefinition

SQL Tuning

Profiling PL/SQL Applications