Oracle Database 19c: PL/SQL Workshop

Skip to Scheduled Dates

Course Overview

This course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.

Who Should Attend

  • Database Administrators
  • Developers

Course Objectives

    • Declare Variables
    • Write Executable Statements
    • Write Control Structures
    • Create Procedures and Functions
    • Create Packages
    • Create Triggers

Course Outline

  • Introduction
  • Introduction to PL/SQL
  • 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
  • Introducing Stored Procedures and Functions
  • Creating Procedures
  • Creating Functions
  • Debugging Subprograms
  • Creating Packages
  • Working With Packages
  • Using Oracle Supplied Packages in Application Development
  • Using Dynamic SQL
  • Creating Triggers
  • Creating Compound, DDL and Event Database Triggers
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies

< Back to Course Search

Class Dates & Times

Class times are listed Mountain time

This is a 5-day class

Price: $4,000.00

Register for Class

Register When Time Where How
Register 07/28/2025 7:00AM - 3:00PM Online VILT
Register 10/06/2025 7:00AM - 3:00PM Online VILT