Oracle: Introduction to PL/SQL

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

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.