ORACLE PL_SQL_WS | Oracle Database 19c PL/SQL Workshop
 
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.
 
Benefits to you
Declare Variables
Write Executable Statements
Write Control Structures
Create Procedures and Functions
Create Packages
Create Triggers
 
Role
Application Developer
Database Developer
Developer
 
Course Outline
Module 1: Course Overview
Course Overview - Oracle Database 19c: PL/SQL Workshop
Module 2: Introduction
Introduction
Practice 1-1: Getting Started
Module 3: Introduction to PL/SQL
Introduction to PL/SQL
Practice 2-1: Introduction to PL/SQL
Module 4: Declaring PL/SQL Variables
Declaring PL/SQL Variables
The %TYPE Attribute
Practice 3-1: Declaring PL/SQL Variables
Module 5: Writing Executable Statements
Writing Executable Statements
Practice 4-1: Writing Executable Statements
Module 6: Using SQL Statements Within a PL/SQL Block
Using SQL Statements Within a PL/SQL Block
Practice 5-1: Using SQL Statements Within a PL/SQL
Module 7: Writing Control Structures
Writing Control Structures
Basic Loop: Example
Practice 6-1: Writing Control Structures
Module 8: Working with Composite Data Types
Working with Composite Data Types
Associative Arrays (INDEX BY Tables)
Practice 7-1: Working with Composite Data Types
Module 9: Using Explicit Cursors
Using Explicit Cursors
Cursor FOR Loops
Practice 8-1: Using Explicit Cursors
Practice 8-2: Using Explicit Cursors: Optional
Module 10: Handling Exceptions
Handling Exceptions
Practice 9-1: Handling Predefined Exceptions
Practice 9-2: Handling Standard Oracle Server Exceptions
Module 11: Introducing Stored Procedures and Functions
Introducing Stored Procedures and Functions
Practice 10-1: Creating and Using Stored Procedures
Module 12: Creating Procedures
Creating Procedures
Practice 11-1: Creating and Using a New SQL Developer Database Connection
Practice 11-2: Creating, Compiling, and Calling Procedures
Module 13: Creating Functions
Creating Functions
Practice 12-1: Creating Functions
Module 14: Debugging Subprograms
Debugging Subprograms
Practice 13-1: Introduction to the SQL Developer Debugger
Module 15: Creating Packages
Creating Packages
Practice 14-1: Creating and Using Packages
Module 16: Working with Packages
Working with Packages
Practice 15-1: Working with Packages
Module 17: Using Oracle-Supplied Packages in Application Development
Using Oracle-Supplied Packages in Application Development
Practice 16-1: Using the UTL_FILE Package
Module 18: Using Dynamic SQL
Using Dynamic SQL
Practice 17-1: Using Native Dynamic SQL
Module 19: Creating Triggers
Creating Triggers
Practice 18-1: Creating Statement and Row Triggers
Module 20: Creating Compound, DDL, and Event Database Triggers
Creating Compound, DDL, and Event Database Triggers
Practice 19-1: Managing Data Integrity Rules and Mutating Table Exceptions
Module 21: Design Considerations for the PL/SQL Code
Design Considerations for the PL/SQL Code
Practice 20-1: Using Bulk Binding and Autonomous Transactions
Module 22: Tuning the PL/SQL Compiler
Tuning the PL/SQL Compiler
Practice 21-1: Using the PL/SQL Compiler Parameters and Warnings
Module 23: Managing Dependencies
Managing Dependencies
Practice 22-1: Managing Dependencies in Your Schema
 
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.