Oracle SQL Advanced — A 2 day course

contact usEnquire about this course

Synopsis

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.

Objectives

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.

Prerequisites

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

Examination

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

Select a date to enquire about availability of places. For dates after 30 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

Birmingham — £795 (+VAT)

Bristol — £795 (+VAT)

Edinburgh — £795 (+VAT)

Leeds — £795 (+VAT)

London — £795 (+VAT)

Manchester — £795 (+VAT)

Sunderland — £795 (+VAT)


Contents

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