Summary
Objectives
Topics
Other Trainings

This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL. Learn how to efficiently design and tune PL/SQL to interface with the database and integrate with the other applications. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

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
  • 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
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

Topics

  • Introduction
  • Oracle Database Exadata Express Cloud Service
  • Overview of Collections
  • Using Collections in PL/SQL
  • Manipulating Large Objects
  • Working with JSON Data
  • Using Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Securing application through PL/SQL
  • Safeguarding Your Code Against SQL Injection Attacks
  • Security Features implemented through PL/SQL

Other Trainings

Database
91 Training Set
Back to Trainings