| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| May 6, 2024 | 11:00 | 07:00 | EDT | Live Virtual Class | 5 | $4,000 USD | Purchase |
| Jul 8, 2024 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $4,000 USD | Purchase |
| Sep 9, 2024 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $4,000 USD | Purchase |
| Nov 18, 2024 | 11:00 | 07:00 | EST | Live Virtual Class | 5 | $4,000 USD | Purchase |
Oracle Database 19c: PL/SQL Workshop
This is a complete course on PL/SQL including an introduction to Programming and Managing the PL/SQL code.
Duration: 5 Days
Audience
- Database Developers
Learning Objectives
- Get an overview of PL/SQL
- Learn how to declare variables
- Write executable statements
- Learn how to use SQL statements in PL/SQL programming
Topics
- Declaring PL/SQL Variables
- Writing Executable Statements
- Using SQL Statements Within a PL/SQL Block
- Writing Control Structures
- Working with Composite Data Types
- Using Explicit Cursors
- Handling Exceptions
- Creating Procedures and Functions
- Debugging Subprograms
- Creating and Working with Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Creating Compound, DDL, and Event Database Triggers
- Design Considerations for the PL/SQL Code
- Tuning the PL/SQL Compiler
- Managing Dependencies
- Using SQL Developer and SQL*Plus
- Commonly Used SQL Commands
- REF Cursors
- Managing PL/SQL Code
- Implementing Triggers
- Using the DBMS_SCHEDULER and HTP Packages
