Oracle Database 19c: PL/SQL Workshop

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.

BENEFITS TO YOU:

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

Audience

• Database Administrators
• Developers

Suggested Preqrequisites

• Oracle Database 19c: SQL Workshop

Topics

• 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 Trigge3rs
• Design Considerations for the PL/SQL Code
• Tuning the PL/SQL Compiler
• Managing Dependencies