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

Audience: An ideal course for anyone who wants to learn querying an Oracle database.
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

Using the SET Operators