Oracle Database: Advanced PL/SQL Programming

Oracle Database: Advanced PL/SQL Programming is a continuation of the ‘Oracle Database: PL/SQL Programing’ course and it is intended to extend your knowledge and practical skills in PL/SQL programming language. The course covers the stored procedures and functions, triggers, collections, advanced exception handling and packages.

The course is hands-on and you will be provided with full course notes, sample database, instructions how the install Oracle XE on your computer and as well all the examples.
A link to the video recoding of the lecturer’s screen will be sent to you after each session.


  • Declaring procedures and functions
  • Using parameters
  • Calling procedures and functions
  • Procedures and functions as database objects
  • Creating triggers
  • Row level and statement level triggers
  • Database triggers
  • Dynamic SQL
  • Collections
  • Raising application errors
  • Creating Packages


This course is for application developers, database administrators and developers.


Students taking this course should have taken the following classes or have equivalent knowledge of:

Duration and Training Formats

The overall duration of the course is 10 hours

Training Formats

  • At your site
  • Live on-line instructor-led
  • Public classes

Course Language

  • English