Back to Search Results

Training Course Summary:

Delegates:

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)

Objectives:

By the end of this course, the delegate will be able to:
Use Oracle9i datatypes and functions
Use advanced SQL*Plus functions
Use the ROLLUP, CUBE and GROUPING clauses
Use ANSI standard table joins
Use iSQL*Plus control and run time parameters
Create inline views and Perform Top-'N' analysis
Insert data into multiple tables
Merge data into tables
Create and use external tables
Use simple and searched CASE expressions
Enable table locking
Create users, profiles and roles

Topics Covered:

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

Requirements:

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.

Pre-Requisites Courses:

SQL*Plus


Follow-On Courses:

PL/SQL

DBA Part I - Architecture & Administration