Oracle Database: Develop PL/SQL Program Units Ed 2


The Oracle Database: Develop PL/SQL Program Units Ed 2 training course will give a detailed overview on how to create, and execute stored procedures and functions, Design and use PL/SQL packages,Create overloaded package subprograms for more flexibility. During the training you will also learn to Utilize Oracle-Supplied Packages in Application Development, Create triggers to solve business challenges, Build and execute SQL statements dynamically.

Who Should Do Oracle Database: Develop PL/SQL Program Units Ed 2 training?

  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • Database Administrators
  • System Analysts
  • Technical Consultant
This course prepares you for Exam 1Z0-148. Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 3 Days
Fee : India : $1,700 , Dubai : $3,000

08-10 (Dubai)
12-14 (Dubai)

Enquire Now

Input symbols

Course Prerequisites

  • Basic understanding of data processing concepts and technique
  • Fundamental knowledge of programming languages

Upon Completion of this course you will know following:

  • Using conditional PL/SQL compilation and obfuscate (hide) code
  • Creating triggers to solve business challenges & Managing dependencies between PL/SQL subprograms
  • Using the compiler warnings infrastructure
  • Create, use, and debug stored procedures and functions
  • Designing and using PL/SQL packages
  • Generate screen output, file output, and mail output
  • Dynamic SQL Code