Overview

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Learn To:

  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Work with JSON data in the database.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.

Skills Covered

Upon completing this course, the learner will be able to meet these overall objectives:
  • Design PL/SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL/SQL applications that use collections
  • Learn to work with JSON data in relational database
  • Write and tune PL/SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with large objects and use SecureFile LOBs

Who Should Attend

  • Application Developers
  • Database Administrators
  • Support Engineer
  • Technical Consultant

Course Curriculum

Prerequisites

  • Basic Knowledge of SQL, PL/SQL
  • Knowledge of PL/SQL Program Units
  • Familiarity with programming languages
  • Oracle Database: SQL Workshop I Ed 2
  • Oracle Database: Develop PL/SQL Program Units Ed 2

Download Syllabus

Course Modules

Request More Information