Oracle SQL Advanced — A 2 day course

contact usEnquire about this course


This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.


To provide the skills needed to use the more advanced features of Oracle SQL. The delegates will practise:

Suitable For

Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.


Before attending this course delegates must have attended the Oracle SQL course or have equivalent experience.


Together with the SQL course, this course covers the major topics required for the following Oracle examinations: Introduction to Oracle9i: SQL (1Z0-007) and Oracle Database SQL Expert (IZ0-047).

Exams are not included as part of the course nor in the course fee.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.


Course Introduction

Retrieve Data Using Subqueries

Hiearchical Queries

Enhanced Grouping Features

Manage Large Data Sets

Flashback Technology

Date, Time and Timezone Support

Regular Expression Support

Manage Objects with the Data Dictionary

Manage Schema Objects

Access Control