Oracle 10g SQL

• Introduction to Oracle 10g

• Writing a Basic SQL Statement

• Restricting and Sorting Data

• Single Row Functions

• Displaying Data from Multiple Tables

• Aggregating Data by Using Group Functions

• Writing Subqueries

• Producing Readable Output with iSQL*Plus

• Manipulating Data

• Transactions

• Creating and Managing Tables

• Including Constraints

• Creating Views

• Other Database Objects

• Controlling User Access

• Using Set Operators

• Enhancements to the GROUP BY Clause

• Advanced Subqueries

• Hierarchical Retrieval

• Oracle 10G Extensions to DML and DDL Statements