Introduction to PL/SQL
Course Outline

DURATION	2 Days
PREREQUISITES	A basic level of SQL knowledge, and some understanding of relational database (RDBMS) concepts is assumed. For students who do not have experience in these areas the Introduction to SQL class is recommended.
DESCRIPTION	This course will give you an introduction to Oracle Corporation’s proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database.
COURSE DATES	Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Wed, 8-Jun-11 and Thu, 9-Jun-11 09:00 - 17:00 £714.00 Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

INtroduction to PL/SQL

• Relation between SQL and PL/SQL
• Advantages of PL/SQL
• A Simple PL/SQL Block
• Declaration using attributes
• Loop Statements
• Displaying the user messages on screen

Cursors and Error Handling

• Cursors
• Using the Explicit Cursors
• Explicit Cursor Attributes
• Implicit Cursor Attributes
• Example of an Explicit Cursor and Attribute
• Error handling in PL/SQL
• Stored Procedures, Functions and Packages

Stored Procedures

• Stored Procedures
• How Oracle creates a Procedure?
• Advantages of Procedures
• Deleting the Procedure

Functions

• Stored Functions
• How Oracle creates a Function?
• Advantages of Functions
• Creating a Function
• Deleting a Function

Triggers

• Use of Database Triggers
• Applying a Database Trigger
• Types of Triggers
• Before Vs After Triggers
• Creating a Trigger
• Deleting a Trigger