Total Time: 5 hour(s)

Summary: 
This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.

Ojectives: 
After completing this course, students will 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

Topics: 
PL/SQL
PL/SQL Structures
Packages
Triggers
Stored Procedures

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.