contact us

Oracle Database 11 G: Advanced PL/SQL

Program Overview |Testimony |curriculum |Certification |Who should do this course? |faq |Calendar

Program Overview

The Oracle Certified Professional (OCP): Oracle Database 11 G Advanced PL/SQL course, you will 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 advanced pl/sql programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.


After the completion of this course, you will be able to:

• Tune PL/SQL code
• Categorize and explain various types of SQL injection attacks
• Apply coding standards to eliminate SQL injection vulnerabilities
• Create subtypes based on existing types for an application
• Create and use collections
• Execute external C programs from PL/SQL
• Execute Java programs from PL/SQL
• Describe the process of fine-grained access control
• Create and maintain LOB data types
• Use the DBMS_LOB PL/SQL package to control LOBs
• Describe SecureFile LOB features
• Identify guidelines for cursor design
• Enable SecureFile LOB de-duplication, compression, and encryption
• Improve memory usage by caching SQL result sets
• Set up PL/SQL functions to use PL/SQL result caching
• Profile PL/SQL applications


Certificate of participation in ‘Oracle Database 11 G: Advanced PL/SQL’ course.

Who should do this course?

Students and working professionals who wish to gain expertise in Advanced PL/SQL programming.



  • Session one
    08 July 2017
    16 06 17
  • Session two
    12 October 2017
    29 09 17
  • Session three
    08 February 2018
    31 01 18