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)

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.
CodeLocationDurationPrice Sep Oct Nov Dec Jan Feb
OSA 2 Days $1,215
Ask a Question

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course