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.

curriculum

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

Certification

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.

faq

Calendar

  • Session one
    12 November 2016
    30 09 16
    Apply
  • Session two
    04 February 2017
    13 01 17
    Apply
  • Session three
    08 July 2017
    16 06 17
    Apply