SQL Advanced

2 Day Course
Code OSA

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

Overview

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.

Modules

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

Prerequisites

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.

Discounts

Different levels of discounts are available, ranging from 5 to 50%. 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.

Code Location Duration Price Sep Oct Nov Dec Jan Feb
OSA 2 Days $1,035
OSA 2 Days $1,035
OSA 2 Days $1,035
OSA 2 Days $1,035
OSA 2 Days $1,035
22-23
OSA 2 Days $1,035
08-09
OSA
Sunderland
2 Days $1,035
15-16

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections