Oracle Database 12c R2: Advanced PL/SQL Ed 2


The Oracle Database 12c R2: Advanced PL/SQL Ed 2 training course will give you a detailed overview on using the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and integrate with the other applications efficiently. During the training you will get knowledge of writing powerful PL/SQL programs with the help of external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Who Should Do Oracle Database 12c R2: Advanced PL/SQL Ed 2 training?

  • Application Developers
  • Database Administrators
  • Support Engineer
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 3 Days
Fee :  London: £5,000, Dubai : $2,960 , India : $1,659

20-22 (Chennai)
20-22 (Goa)
03-05 (Delhi)
03-05 (Goa)
03-05 (london)
09-11 (Dubai)
09-11 (Goa)
10-12 (Bangalore)
10-12 (Goa)
10-12 (london)
02-04 (Delhi)
02-04 (Goa)
02-04 (london)
08-10 (Dubai)
08-10 (Goa)
09-11 (Bangalore)
09-11 (Goa)
09-11 (london)
16-18 (Chennai)
16-18 (Goa)
13-15 (Bangalore)
13-15 (Goa)

Enquire Now

Input symbols

Course Prerequisites

  • Fundamental awareness of SQL, PL/SQL
  • Basic knowledge of programming languages
  • Awareness of PL/SQL Program Units
  • Oracle Database: Develop PL/SQL Program Units Ed 2
  • Oracle Database: SQL Workshop I Ed 2

Upon Completion of this course you will know following:

  • Designing efficient PL/SQL packages and program units
  • Creating PL/SQL applications which use collections
  • Working with JSON data in relational database
  • Implementing a virtual private database with fine-grained access control
  • Writing code to interface with large objects and use SecureFile LOBs