contact us

Oracle PL/SQL Developer

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

Program Overview

Through our Oracle PL/SQL Developer course, one can create anonymous PL/SQL blocks as well as stored procedures and functions and helps you to use the advanced features of program design, packages, cursors, extended interface methods, large objects and collections.


You call them instructors, we call them your Mentors!

They are the catalysts under whose supervision and arm’s length support our students are empowered to accomplish expertise in advanced technology. We boast of enterprising and talented resources with proven track records who are working in tandem with our goal to provide inspiring and enduring technical learning experience to our students.


1) The Oracle Certified Associate (OCA): Oracle Database 11 G PL/SQL Developer

• Use conditional compilation to customize the functionality in an PL/SQL application without removing any source code
• Create and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Create overloaded package sub-programs for more flexibility
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL sub-programs
• Handle runtime errors
• Describe stored procedures and functions
• Design PL/SQL code for predefined data types, local sub-programs, additional programs and standardized constants and exceptions
• Create triggers to solve business challenges
• Design PL/SQL anonymous block that execute efficiently

2) The Oracle Certified Professional (OCP): Oracle Database 11 G <strong>Advanced

• Tune PL/SQL code
• Categorize and explain various types of SQL injection attacks
• Apply coding standards to eliminate SQL injection vulnerabilities
• Create sub-types 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: PL/SQL Developer’ course.

Additionally, students can sit the Oracle Certified Associate (OCA): PL/SQL Developer certification (exam: 1Z1:144), prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G PL/SQL Developer certification.

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
    19 05 19