Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
Oracle: Introduction to PL/SQL provides an introduction to the PL/SQL Oracle's procedural language extension to SQL.

Audience
This course is for programmers and database administrators who will be using PL/SQL with Oracle database products or Oracle Developer/2000.

Time
5 hours

Product Code: PLSC01
After completing Oracle: Introduction to PL/SQL the user should be able to:
 
Describe the building blocks of PL/SQL and its environment
Explain the benefits of the basic components of PL/SQL structures
Explain the benefits of packages over stand-alone procedures and functions
Create various types of triggers
Create and use procedures

PL/SQL
 
PL/SQL Architecture
PL/SQL Basics

PL/SQL Structures
 
Simple Blocks
Control Structures

Packages
 
Creating Packages
Debugging Packages

Triggers
 
Creating a Trigger
Trigger Execution

Stored Procedures
 
Creating Stored Procedures
Invoking Stored Procedures

This course is distributed with
 
Exercises with sample files that allow users to practice in PL/SQL
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to the PL/SQL product
An Oracle glossary


 
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.