Oracle Database 12c: Program with PL/SQL

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. Download Course Contents

Schedule & Prices

Course Details	Schedule
Classroom Training* Duration : 5 Days Fee : London: £5,500, Dubai : $4,180 , India : $2,000	February 03-07 (Delhi) 03-07 (Goa) 03-07 (london) 09-13 (Dubai) 09-13 (Goa) 10-14 (Bangalore) 10-14 (Goa) 10-14 (london) 17-21 (Chennai) 17-21 (Goa) March 02-06 (Delhi) 02-06 (Goa) 02-06 (london) 08-12 (Dubai) 08-12 (Goa) 09-13 (Bangalore) 09-13 (Goa) 09-13 (london) 16-20 (Chennai) 16-20 (Goa) April 13-17 (Bangalore) 13-17 (Goa) 20-24 (Chennai) 20-24 (Goa)

Enquire Now

Input symbols

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