contact us

Oracle Database 11 G: Advanced PL/SQL

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

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
    12 octobre 2018
    29 09 18
  • Session two
    12 février 2019
    25 12 18
  • Session three
    08 juillet 2019
    16 06 19