Oracle Database 19c: Advanced PL/SQL Ed 2
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.
STUDENTS WILL LEARN TO
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
About the course
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
Register for Training
Schedule
| Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
|---|
