Back to Search Results

Training Course Summary:

Delegates:

This course is designed for anyone who needs to access and work with an Oracle9i Database. This course is suitable for delegates intending to sit the:- Introduction to Oracle9i:SQL Oracle Certified Professional examination (IZ0-007).

Objectives:

By the end of this course, the delegate will be able to:
Describe the structure of a relational database
Use the command line features of Oracle SQL*Plus and iSQL
Create SQL statements to select data from an Oracle database
Generate scripts and apply formatting to output
Use SQL control and run time parameters
Create and alter tables, indexes and views
Create, update and delete records
Create users, profiles and roles
Grant and revoke access privileges
Access the data dictionary

Topics Covered:

The Structure of a Relational Database
The Basic SQL and iSQL Select Statement
Selecting Data from Multiple Tables
Using Inner Joins, Outer Joins and Self Joins
Using Standard Oracle and ANSI Standard Joins
Sub-Queries
Grouping and Sorting Output
Advanced Group Functions
Character, Date and Numeric Functions
Oracle9i Datatypes and Functions
Run-Time Parameters and Variables
SQL Control Parameters
Producing Reports with SQL*Plus
Creating and Changing Tables and Views
Inline Views and Top-'N' Analysis
Constraints and Indexes
Inserting, Updating and Deleting Data
Inserting Rows into Multiple Tables
Simple and Searched CASE Expressions
Merging Data into Tables
External Tables
Basic Transaction Control
Table Locking
Controlling Access to the Database
Creation of User, Profiles and Roles
Related Data Dictionary Tables and Views

Requirements:

An understanding of IT is required.

Follow-On Courses:

PL/SQL

DBA Part I - Architecture & Administration