Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.
It introduces a number of new features and enhancements, including support for multitenant databases, automatic indexing, and enhanced performance and security. Multitenant databases allow multiple independent databases to be hosted on a single instance of Oracle Database, while automatic indexing automates the creation and maintenance of indexes.
These new features make Oracle Database 19c an attractive option for enterprise customers looking to consolidate their database infrastructure. In addition, the enhanced performance and security make it an ideal choice for mission-critical applications.
Overview
Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.
This Oracle Database course 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.
In Oracle Database 19c: Advanced PL/SQL training you will learn 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.
Skills Covered
After completing this course, you will be able to:
- 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
Prerequisites
- Basic Knowledge of SQL, PL / SQL
- Familiarity with programming languages
- Oracle Database SQL and PL / SQL New Features
- Oracle Database: Introduction to SQL / PLSQL Accelerated
- Oracle Database SQL Tuning for Developers
- Oracle Database: Develop PL / SQL Program Units
Target Audience
This course intended for Application Developers and Database Administrators.
Course Contents
1. Introduction
2. Working with Exadata Express Cloud Service
3. Overview of Collections
4. Using Collections
5. Handling Large Objects
6. JSON Data in Database
7. Advanced Interface Methods
8. Performance and Tuning
9. Improving Performance with Caching
10. Analyzing PL / SQL Code
11. Profiling and Tracing PL / SQL Code
12. Securing Applications through PL / SQL
13. Safeguarding Your Code against SQL Injection Attacks
14. Advanced Security Mechanisms
Dates & Locations
August 10, 2026 - August 12, 2026
August 10, 2026 - August 12, 2026
October 12, 2026 - October 14, 2026
October 12, 2026 - October 14, 2026
December 7, 2026 - December 9, 2026
December 7, 2026 - December 9, 2026
Exam & Certification
Oracle Database 19c: Advanced PL/SQL Certification Training Course.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
