Mastering Oracle PL/SQL with Confidence

Excel in Oracle database programming with our three-day hands-on course designed for IT professionals looking to advance their skills using PL/SQL in Oracle 19c.

Course Thumbnail

Essential Skills Gained

Checkmark

Develop Oracle database applications using PL/SQL.

Checkmark

Integrate PL/SQL modules within application architecture.

Checkmark

Build and execute PL/SQL program units efficiently.

Checkmark

Implement robust error and exception handling in PL/SQL.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Oracle database users
  • Business data analysts
  • Software application developers
  • Database administrators (DBAs)

Description

In our hands-on Oracle PL/SQL course, you’ll get a comprehensive introduction to Oracle database programming using the dynamic PL/SQL language. Over three days, you'll navigate through foundational and advanced concepts, exploring language structures, syntax, and modern features of Oracle 19c. This course prepares you to develop robust, high-performance applications, focusing on stored procedures, functions, and triggers. While this is not Oracle University’s official content, our flexible and up-to-date curriculum equips you with necessary skills for today's fast-paced tech environments.

Calendar icon

Upcoming Course Dates

July 21-23, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$2395

September 24-26, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$2395

November 12-14, 2025

10:00 AM - 6:00 PM

Virtual: Online - US/Eastern

Enroll

$2395

Course Outline

Download PDF

Database Tools and Setup

  1. Evaluate Available Tools

  2. Choose Suitable Tools

  3. Establish Oracle Database Connections

  4. Set Up SQL Developer

  5. Configure SQL *Plus

  6. Use JDeveloper

  7. Understand Variables and Their Uses

  8. Operate Within SQL Developer

  9. Navigate SQL *Plus Environment

Selecting Programming Languages

  1. Database Programming Overview

  2. PL/SQL: A Primer

  3. PL/SQL Performance Benefits

  4. Integrate with Various Languages

PL/SQL Essentials

  1. Program Structure in PL/SQL

  2. Adhere to Syntax Rules

  3. Incorporate SQL

  4. Write and Generate Readable Code

  5. Output Database Results

DECLARE Section

  1. Understand Declaration Basics

  2. Define Primitive Types

  3. Explore Declaration Settings

  4. Use NOT NULL and CONSTANT

  5. Integrate Data Dictionary

  6. Declare User-Defined Types

BEGIN Section

  1. Manage Program Data

  2. Control Data Logic and Flow

  3. Employ Control Structures like GOTO and LOOP

EXCEPTION Section

  1. Identify Specific Exceptions

  2. Practical Use of PRAGMA Exception_INIT

  3. Handle SQLCODE and SQLERRM

Advanced Cursor Use

  1. Explore Explicit Cursor Techniques

  2. Implement FOR UPDATE and WHERE CURRENT Clauses

Database Programming Units

  1. Explore Stored Program Unit Types

  2. Recognize Design and Storage Benefits

Stored Procedures and Functions

  1. Create and Test Procedures and Functions

  2. Utilize Parameters and Privileges

  3. Perform Unit Testing

Programming Unit Maintenance

  1. Recompile and Manage Code

  2. Use Data Dictionary Metadata

Dependency Management

  1. Use Dependency Tracking Tools

  2. Apply Effective Dependency Strategies

Package Use and Maintenance

  1. Develop and Maintain Packages

  2. Evaluate Performance Considerations

Advanced Cursor Techniques

  1. Use SYS_REFCURSOR

  2. Apply Cursor Expressions

System Packages

  1. Utilize DBMS_OUTPUT and UTL_FILE

Database Trigger Concepts

  1. Describe Trigger Use Cases

  2. Implement Trigger Mechanisms

Creating and Maintaining Triggers

  1. Develop and Troubleshoot Triggers

  2. Work with Multiple Table Triggers

System Event Triggers

  1. Define and Use System Event Triggers

  2. Explore Available Events

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.