Oracle Database 19c: Advanced PL/SQL Ed 2

COURSE TOPICS

Module 1 : Introduction

• Introduction

Module 2 : Working with Exadata Express Cloud Service

• Working with Exadata Express Cloud Service

Module 3 : Overview of Collections

• Overview of Collections
• Practice 3-1: Analyzing Collections

Module 4 : Using Collections

• Using Collections
• Practice 4-1: Using Collections

Module 5 : Handling Large Objects

• Handling Large Objects
• Practice 5-1: Working with LOBs

 Module 6 : JSON Data in Database

• JSON Data in Database
• Practice 6-1: JSON Data in Tables
• Practice 6-2: JSON Data in PL/SQL Blocks

Module 7 : Advanced Interface Methods

• Advanced Interface Methods
• Practice 7-1: Using Advanced Interface Methods

Module 8 : Performance and Tuning

• Performance and Tuning
• Practice 8-1: Performance and Tuning (Part 1)
• Practice 8-1: Performance and Tuning (Part 2)

Module 9 : Improving Performance with Caching

• Improving Performance with Caching
• Practice 9-1: Improving Performance with Caching

Module 10 : Analyzing PL/SQL Code

• Analyzing PL/SQL Code
• Practice 10-1: Analyzing PL/SQL Code

Module 11 : Profiling and Tracing PL/SQL Code

• Profiling and Tracing PL/SQL Code
• Practice 11-1: Profiling and Tracing PL/SQL Code

Module 12 : Securing Applications through PL/SQL

• Securing Applications through PL/SQL
• Practice 12-1: Implementing Fine-Grained Access Control for VPD

Module 13 : Safeguarding Your Code against SQL Injection Attacks

• Safeguarding Your Code against SQL Injection Attacks
• Practice 13-1: Safeguarding Your Code against SQL Injection Attacks

Module 14 : Advanced Security Mechanisms

• Advanced Security Mechanisms