SQL Advanced

2 Day Course
Code OSA

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite


Anyone who needs to use and understand iSQL*Plus and Oracle9i SQL*Plus to an advanced level, to retrieve data from and to update an Oracle database. The more advanced topics are covered in this course for the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Course topics: (13 topics)

  • Oracle9i Datatypes and Functions
  • Advanced Single Row Functions
  • Advanced Group Functions
  • Ansi Standard Table Joins
  • isql*Plus
  • Inline Views
  • Top-'N' Analysis
  • Inserting Rows into Multiple Tables
  • Merging Data into Tables
  • External Tables
  • CASE Expressions
  • Table Locking
  • Creation of User, Profiles and Roles


Delegates should have attended the Oracle SQL*Plus course or have a similar level of experience. Before taking any exam, ensure you have the recommended experience.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course