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: sales@ptr.co.uk or Call: 0118 979 4000) for further advice.

Course Overview

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).

Pre-Requisites

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


SQL*Plus Commands


Filtering and Sorting Data


SQL Functions


Working with Multiple Tables


Tables and Constraints


Other Database Schema Objects


Building PL/SQL Blocks


PL/SQL Control Structures


Cursors


Exception Handling


Procedures and Functions


Oracle Packages


Oracle Triggers


PL/SQL Collections


Tables Used in the Course



Course ID: PTR418