Oracle Database 11g: Advanced PL/SQL Developer OCP Training & Certification Courses
 800 Ratings

Oracle Authorized Training Partner Expert Chat

Oracle #1 Training Partner

Guarantee to Run the Classes

Get Trained by Industry Expert


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. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.

To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals. To know more, please write to us at

Course Content / Exam(s)

Schedule for Oracle Database 11g: Advanced PL/SQL Developer OCP

Course # Course Name Exam # Duration (days)
1Z0-061 Oracle Database: Introduction to SQL

Course Content

Course 1Z0-061: Oracle Database: Introduction to SQL

  • Retrieving Data using the SQL SELECT Statement
  • Introduction to Data Dictionary Views
  • Manipulating Data by Using Subqueries
  • Managing Data in Different Time Zones
  • Introduction
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
Oracle Database: Program with PL/SQL

Course Content

Course : Oracle Database: Program with PL/SQL

  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions and Debugging Subprograms
  • Packages
  • Deploying Packages
  • Implement Oracle-Supplied Packages in Application Development
  • Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • PL/SQL Compiler
  • Manage Dependencies
Oracle Database 11g: Advanced PL/SQL

Course Content

Course : Oracle Database 11g: Advanced PL/SQL

  • Introduction
  • PL/SQL Programming Concepts Review
  • Designing PL/SQL Code
  • Using Collections
  • Manipulating Large Objects
  • Using Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Implementing VPD with Fine-Grained Access Control
  • Safeguarding Your Code Against SQL Injection Attacks
Total 13

Oracle Database 11g: Advanced PL/SQL Developer OCP Benefits

Upon Completion of this Course, you will accomplish following:-

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle 11g: Advance PL/SQL Developer OCP Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Recommended Courses and Certification:

Enquire Now



Processing data, please wait...