Oracle Database 19c: Advanced PL/SQL
Skip to Scheduled Dates
Course Overview
This Oracle Database 19c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.
Who Should Attend
Database Administrators
Developers
Course Objectives
Write powerful PL/SQL programs.
Explore programming efficiency.
Apply PL/SQL designing best practices.
Create PL/SQL applications that use collections.
Write code to interface with large objects and use SecureFile LOBs.
Write and tune PL/SQL code effectively to maximize performance.
Gain an understanding of the Oracle Database Exadata Express Cloud Service.
Course Outline
Introduction
Working with Exadata Express Cloud Service
Overview of Collections
Using Collections
Handling Large Objects
JSON Data in Database
Advanced Interface Methods
Performance and Tuning
Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracking PL/SQL Code
Securing Applications Through PL/SQL
Safeguarding Your Code Against SQL Injection Attacks
Advanced Security Mechanisms
< Back to Course Search
Class times are listed Central time
This is a 3-day class
Class dates not listed.
Please contact us for available dates and times.