Course Title/Code

PL/SQL Program Units (RC1002)

Course Description

This course is taught using the Oracle 9i database. It gives students a full and comprehensive introduction to the PL/SQL programming language. Students are taught to write PL/SQL program units, functions, procedures, packages, and database triggers using SQL*Plus. In addition, the course will teach students to manage PL/SQL program units and database triggers, and to manage dependencies and to use some of the Oracle-supplied packages.

Regular hands-on practise will reinforce the course concepts; indeed, one of the goals of the course is for students to apply the techniques learnt to build upon a small accounting application for a fictional online store selling CD’s.

Students will have the use of a computer. These are provided on a one computer per student basis.

This course will fully prepare the student for the following Oracle Certified Professional (OCP) exam(s):

IZ0-101 - PL/SQL Program Units

Cost

£680 (excluding VAT)

Includes course notes, lunch, and refreshments. (special requirements - LINK).

Duration

3 days (course start and end times –LINK)

Audience

Application Developers

Systems Analysts

Analyst/Programmers

Designer/Developers

Follow-On Course(s)

Build Internet Application I (RC003)

Pre-Requisites

Students must have a good understanding of SQL, so the following course is recommended first:

Introduction to Oracle 9i: SQL and PL/SQL (RC1001)

Click here to view the course content in a separate window