Course Summary

Price: £(POA)

Duration: 5 Day Course

Scheduled Dates:

Ask Us for more details
Call Us: 0118 979 4000

Introduction to Oracle9i: SQL PL/SQL, and SQL*Plus: Course

This course is no longer included in our schedule. It may still be available as a closed course, or there may be a more up to date alternative. Please contact a member of our sales team (Email: or Call: 0118 979 4000) for further advice.


This course has been retired. View the schedule of current Oracle Courses

This course introduces students to data server technology and explores the concepts of relational databases, the SQL*Plus interface tool, and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. The students will also learn to store, retrieve, and manipulate data. Finally, the students will learn how to create PL/SQL blocks of application code that can be used in Oracle® forms, reports, and other Oracle applications. This course will help the student to prepare for Oracle's exam, Introduction to Oracle9i SQL (1ZO-007).


Before taking this course, students should have taken the Introduction to Oracle9i course or have equivalent knowledge.

Topics Covered

Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus

  • Introduction to SQL*Plus and iSQL*Plus
  • Introduction to SQL
  • Introduction to PL/SQL

SQL*Plus Commands

  • Using SQL*Plus for Editing
  • Using SQL*Plus to Work with Files
  • Using SQL*Plus for Formatting Output
  • Using SQL*Plus Variables

Filtering and Sorting Data

  • WHERE Clause
  • ORDER BY Clause

SQL Functions

  • Expressions in a SELECT Statement
  • Single Row Functions
  • Group Functions

Working with Multiple Tables

  • Joins
  • Subqueries
  • Set Operators

Tables and Constraints

  • Creating and Modifying Tables
  • Integrity Constraints
  • Managing Data in Tables
  • Transaction Control Language Statements

Other Database Schema Objects

  • Sequences, Synonyms, and Indexes
  • Views
  • Database Object Security

Building PL/SQL Blocks

  • Creating PL/SQL Blocks
  • Manipulating Data in PL/SQL

PL/SQL Control Structures

  • Conditional Control Structures
  • Iterative Control Structures


  • Introduction to Cursors
  • Implicit Cursors
  • Explicit Cursors
  • Cursor Loops

Exception Handling

  • Introduction to Exception Handling
  • Types of Exceptions

Procedures and Functions

  • Developing Procedures and Functions
  • Passing Parameters

Oracle Packages

  • Developing Packages
  • Oracle-supplied Packages

Oracle Triggers

  • Building a Trigger
  • Trigger Restrictions

PL/SQL Collections

  • Defining and Using Collections
  • Collection Methods

Tables Used in the Course

  • Structure of the TablesTopic

Attendees of this course will enjoy a small class size with one workstation per delegate. The course fee includes training materials, refreshments and restaurant lunches for the duration.

This course qualifies for PTR's SAVEIT Scheme and would cost only £1100 per delegate with our entry level 10 Day Option.

Related Database Courses