Oracle Database 19c: PL/SQL Workshop

Skip to Scheduled Dates

Course Overview

PL/SQL isn’t just an add-on to SQL—it’s a foundational skill for any serious Oracle professional. Used to automate, extend, and secure data operations within the Oracle ecosystem, PL/SQL enables you to build database-resident program units like procedures, functions, packages, and triggers.

In this hands-on course, you’ll learn the syntax, structure, and core capabilities of PL/SQL. You’ll explore how PL/SQL fits into application architecture, and how it’s used to build modular, reusable, high-performance database applications.

Who Should Attend

  • Database Administrators
  • Developers

Course Objectives

    This course teaches students how to write structured, maintainable PL/SQL code for Oracle-based applications. You'll start with language fundamentals and progress to reusable, production-ready components.

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

Course Outline

Getting Started with PL/SQL

  • Selection & Setup of the Database Interface
  • Choosing a Database Programming Language
  • About Bind & Substitution Variables

PL/SQL Language Fundamentals

  • Writing PL/SQL Blocks
  • DECLARE Section (variables, data types)
  • BEGIN Section (executable logic, embedding SQL)
  • EXCEPTION Section (error handling and propagation)

Working with Cursors

  • Beyond the Basics: Explicit Cursors
  • Advanced Cursor Techniques (parameterized, FOR UPDATE, etc.)

Creating Stored Program Units

  • Introducing Database-Resident Program Units
  • Creating Stored Procedures & Functions
  • Executing Stored Procedures & Functions

Maintaining Stored Program Units

  • Managing Dependencies

Modularizing Code with Packages

  • Creating & Maintaining Packages
  • Advanced Package Capabilities (state, overloading, globals)

Leveraging Oracle-Supplied Packages

  • Using System-Supplied Packages (DBMS_OUTPUT, UTL_FILE, DBMS_SQL)

Working with Triggers

  • Database Trigger Concepts
  • Creating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Event Triggers

Performance and Modern Enhancements

  • Design Considerations for PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Recent Enhancements (Oracle 12c and beyond)

< Back to Courses

Class Dates & Times

Class times are listed Eastern time

This is a 5-day class

Price: $4,000.00

Class dates not listed.
Please contact us for available dates and times.