ORACLE ADV_PL_SQL | Oracle Database 19c Advanced PL/SQL
 
Role
Database Administrator
Database Developer
Developer
 
Course Outline
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
 
Descargue el temario para conocer el detalle completo de los contenidos.
 
Debido a las constantes actualizaciones de los contenidos de los cursos por parte del fabricante, el contenido de este temario puede variar con respecto al publicado en el sitio oficial, sin embargo, Netec siempre entregará la versión actualizada de éste.