Oracle Database 19c: PL/SQL Workshop

Course code

19cDB-PLSQL-WS

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

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.

Objectives

Course 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

Prerequisites

Oracle Database 19c: SQL Workshop

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 trainings (Oracle)

Request the training

Oracle Database 19c: PL/SQL Workshop

Course code:

19cDB-PLSQL-WS

Duration:

5 Days, 40 Acad. Hours

21.04.25

Kyiv

Delivery format

Dates

21.04.25

Location

Kyiv

Apply

Download pdf