Oracle Advanced PL/SQL — A 3 day course

contact usEnquire about this course


This course is designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors, large objects and collections.

It also introduces some of the Oracle-supplied packages.

This course is suitable for users of Oracle Database 10g and Oracle Database 11g.


By the end of this course delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL; use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets and apply coding standards to avoid SQL injection attacks. The delegates will practise:

Suitable For

Software development personnel and Oracle database administrators who need to take advantage of the advanced features of PL/SQL in Oracle Database 10g and Oracle Database 11g


Practical experience of Oracle SQL and the PL/SQL programming language is required. This can be gained by attendance on the pre-requisite courses:


This course is suitable for delegates intending to sit the Oracle examination #1Z0-146: Oracle Database 11g: Advanced PL/SQL. Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

The exam is not taken during the course nor is it included in the course fee.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 24 March 2020, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1250 (+VAT)


Course Introduction

Designing PL/SQL Code for Performance

Use Collections

Advanced Interface Methods

VPD and Fine-Grained Access Control

Manipulate Large Objects

Administer SecureFile LOBS

Tuning PL/SQL Code for Performance

Use SQL and PL/SQL Caching to Imrpove Performance

Analyse PL/SQL Code

Profile and Trace PL/SQL Code

Safeguard Code