Oracle Database 12c R2: Program with PL/SQL Ed 2/1Z0-144


Oracle Database 12c R2: Program with PL/SQL Ed 2 Certification Training Course Overview

Oracle Database 12c R2: Program with PL/SQL Ed 2 training course is designed to introduce about PL/SQL and then explores the benefits of this powerful programming language. In this training class, you'll learn to develop stored procedures, functions, packages and more.

Target Audience:

  • Application Developers
  • Database Administrators
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant
This course prepares you for Exam 1Z0-144. Test your current knowledge Qubits42

Oracle Database 12c R2: Program with PL/SQL Ed 2 (40 Hours) Download Course Contents

Instructor - Led Online Training Fee For Both Group Training & 1-on-1 Training 3050
Group Training

19,20,21,22,23 Apr
09:00 AM - 05:00 PM CST
(8 Hours/Day)

03,04,05,06,07 May
09:00 AM - 05:00 PM CST
(8 Hours/Day)

07,08,09,10,11 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End


Start Time : At any time

12 AM
12 PM


Classroom training is available in select Cities

Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

  • Manage dependencies between PL/SQL subprograms
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
  • Write dynamic SQL for more coding flexibility
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Design PL/SQL packages to group related constructs
  • Handle runtime errors