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 1 (2 days)

Audience: An ideal course for anyone who wants to learn the fundamentals of SQL.
 
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Basic Oracle Database Concepts

Using the Oracle SQL Developer GUI Tool

SQL Fundamentals

Retrieving all or specific column values

Single row functions

Aggregating data

Retrieving Data from multiple tables

Using Sub Queries

Introduction to different types of database objects