| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Dec 11, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Mar 10, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Jun 9, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Sep 22, 2025 | 11:00 | 07:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Dec 15, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
Oracle Database 19c: Advanced PL/SQL
In this course, you will learn to handle complex data. You will learn about collections, which enable you to work with a logical group of homogenous data. You will also learn to manage large objects and JSON data in the database. You will be introduced to utilities such as PL/Scope and hierarchical profiler to analyze, trace, and profile PL/SQL code. These functions help you in improving the performance of the application. Further, you will be introduced to various security mechanisms that can be used to secure applications.
Duration: 3 Days
Audience
- Application Developers
- Database Developers
Learning Objectives
- Use PL/SQL programming structure
- Use explicit and implicit cursors in PL/SQL
- Understand for, while and basic loop processing in PL/SQL
- Discuss programmer defined procedures and functions
- Use UTL_FILE and directories for I/O
- Understand exception handling
Topics
- Working with Exadata Express Cloud Service
- 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 Tracing PL/SQL Code
- Securing Applications through PL/SQL
- Safeguarding Your Code Against SQL Injection Attacks
- Advanced Security Mechanisms
