Oracle Database 19c: PL/SQL Workshop

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