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

or call:408-759-5074

Alternatively you can request a callback or schedule a call with a Training Advisor

Course PDF


Share this Course


Recommend this Course