The WHERE and ORDER BY Clause

• WHERE, ORDER BY Clause
• Using the Data Dictionary
• Hierarchical Queries

Single Row Functions

• Single Row vs. Group Functions
• Date and Numeric Format Models
• Data Conversion
• Control Statements
• Regular Expressions

Joining Data from Multiple Tables in Queries

• The JOIN Condition / The Cartesian Product
• Outer JOINs
• SET Operators
• ANSI SQL99 Joins

Group Functions and the GROUP BY Clause

• Group Functions
• Distinct Operator in Group Functions
• GROUP BY, WITH Clause, ROLLUP, CUBE

Using Subqueries and CASE Clauses

• Single-Row, Multi-Row, Multi-Column Subqueries
• Subqueries in a WHERE Clause
• Subqueries in the FROM Clause ? In-Line Views
• Subqueries In the SELECT Clause ? Scalar Subqueries
• Correlated Subqueries

PL/SQL Basics

• PL/SQL anonymous block structure and Datatypes
• Variable declarations
• Object naming rules
• Executable Statements
• Repetition control
• CASE Expressions and Statements
• Basic Coding Standards

Working With Database Data

• Referencing other variables or a database column?s datatypes
• Implicit cursor attributes
• Transaction control commands
• Selecting data into PL/SQL variables
• Declaring explicit cursors

Exception Handling

• Handling predefined and user-defined exceptions
• Preventing unhandled exceptions
• Controlling exception processing

Stored PL/SQL Objects

• Introduction to procedures and functions stored in the database
• Creating stored PL/SQL objects
• Creating procedures, functions, packages, package bodies
• Introduction to database triggers
• Viewing and recompiling stored code