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

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

Cursors
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

After completing this course, students will know how to:

Use SQL, PL/SQL, and SQL*Plus. Use SQL*Plus commands.
Filter and sort data. Use built-in SQL functions.
Work with multiple tables.
Create and modify tables and constraints.
Create and use other database objects.
Build a PL/SQL block. Use PL/SQL control structures.
Process cursors in PL/SQL.
Handle runtime exceptions.
Develop procedures and functions.
Develop Oracle packages.
Create Oracle triggers.
Work with collections of data.

Prerequisites

Students should have knowldege of: Introduction to Oracle9i or equivalent.