Application Express (APEX)

Introduction to APEX
Intermediate APEX
APEX Administration
APEX New Features


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


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