Oracle SQL Advanced

Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. The more advanced topics are covered in this course for the Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007).

Course Content

How to use iSQLPlus
ANSI-Compliant Inner Joins
ANSI-Compliant Outer and Self Joins
Hierarchical Queries
Enhanced Grouping Extensions and Functions
TIMESTAMP, TIMEZONE and INTERVAL Datatypes
TIMESTAMP and INTERVAL Functions and Literals
Overview of Analytic Functions
Ranking Data by Value and Percentile
Providing Cumulative, Moving and Centered Aggregates
POSIX Compliant Regular Expression Notation
Regular Expression Functions
Enhanced Subquery Functions
CASE Expressions
Extended Insert and Merge Operations on Tables
Creating and Using External Tables

Skills

By the end of this course, the delegate will be able to:
Use iSQLPlus
Implement ANSI-Compliant Table Joins
Develop Hierarchical Queries
Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions
Use the GROUPING and GROUPING_ID Functions
Handle DATE, TIMESTAMP and INTERVAL Datatypes and Functions
Create Queries to Rank Data by Value
Create Queries to Calculate Percentiles
Use Reporting and Windowing Aggregate Functions
Understand Regular Expression Notation
Use Regular Expression Functions
Implement CASE Expressions in SQL Statements
Implement Enhanced Table Handling Features

Prerequisites

Delegates should have attended the SQL course or have a similar level of experience.

Before taking any exam, ensure you have the recommended experience.