Data Deliverance Courseware

Oracle® PL/SQL®

Summary
This course gives an introduction to ORACLE® PL/SQL®, an application development environment which enables the writing of programs and stored procedures using both SQL and PL/SQL commands.

It is based on version 8 of the ORACLE relational database but the principles learnt may be applied to both version 7.3 and version 8i.

Prerequisites
Attendance on the Introduction to SQL course or equivalent or extensive experience of another Relational Database, such as Informix or Sybase.

Next Steps

Length
2 days

Format
Instructor-led course, with many practical computer-based exercises.

Course Outline

Day 1

Day 2

Hardware and Software Requirements
Each student should have access to a PC running Windows 95/98/ME or NT Workstation/2000 Professional with at least 500Mb of free space on the C drive and a CDROM. However, the PCs do NOT have to be on a network.
Note to Oracle licensees
Your Oracle license may not allow the use of the software for providing training to people outside your organisation. Contact Oracle if you are planning to provide third-party training and have any doubts about your license in this regard.