I. Overview:

Enroll for the 3-day Oracle Database 19c: Advanced PL/SQL course from Koenig Solutions accredited by Oracle. This 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.

II. Duration:

03 days (24 hours)

III. Objectives:

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

IV. Intended Audience:

This course intended for Application Developers and Database Administrators.

V. 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

VI. Course outlines:

Module 1: Introduction

Module 2: Working with Exadata Express Cloud Service

Module 3: Overview of Collections

Module 4: Using Collectionss

Module 5: Handling Large Objects

Module 6: JSON Data in Database

Module 7: Advanced Interface Methods

Module 8: Performance and Tuning

Module 9: Improving Performance with Caching

Module 10: Analyzing PL / SQL Code

Module 11: Profiling and Tracing PL / SQL Code

Module 12: Securing Applications through PL / SQL

Module 13: Safeguarding Your Code against SQL Injection Attacks

Module 14: Advanced Security Mechanisms