Oracle 11g Advanced PL SQL

3 days


In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding your code against SQL Injection attacks.


  • Developer
  • Application Developers
  • PL/SQL Developer

Skills Gained

  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with large objects and use SecureFile LOBs
  • Safeguard code against SQL injection attacks
  • Design PL/SQL packages and program units that execute efficiently


Required Prerequisites:

  • Oracle Database 11g: Introduction to SQL
  • Oracle Database 11g: Program with PL/SQL

Suggested Prerequisites:

  • Experience with SQL and PL/SQL required
  • Familiarity with the Oracle Database

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite3 2700 AU$2700 2019-07-18
London3 1500 £1500 2019-07-23
London3 1350 £1350 2019-08-05
London3 1500 £1500 2019-10-09
London3 1500 £1500 2019-10-14
London3 1350 £1350 2019-10-30