Oracle SQL Syllabus
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Other Database Objects
Controlling User Access
Using SET Operators
Enhancements to the GROUP BY Clause
Hierarchical Retrieval
Advanced Subqueries
Extensions to DML and DDL Statements

Oracle Pl-SQL syllabus
Programming in PL/SQL
PL/SQL Program Structure
Creating and Running PL/SQL Code
Loop Basics
Exception Handlers
Strings
Numbers
Records
Collections
Miscellaneous Datatypes
SQL in PL/SQL
Data Retrieval
Procedures, Functions, and Parameters
Packages
Triggers
Managing PL/SQL Code
I/O and PL/SQL
Oracle Forms Developer 10g: Build Internet Applications
Oracle Reports Developer 10g: Build Reports