I. Overview:

Oracle 19C PL/SQL Fundamentals provides a comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.

II. Duration:

05 days (40 hours)

III. Objectives:

• PLSQL programming structure
• Using Explicit and Implicit Cursors in PLSQL
• For, while and basic Loop Processing in PLSQL
• Programmer Defined Procedures and Functions
• Using UTL_FILE and Directories for I/O
• Exception Handling

IV. Intended Audience:

• End users
• Business analysts
• Application developers
• Database administrators

V. Prerequisites

Basic computer skills.

VI. Course outlines:

Module 1: Introduction

Module 2: Introduction to PL/SQL

Module 3: Declaring PL/SQL Variables

Module 4: Writing Executable Statements

Module 5: Using SQL Statements Within a PL/SQL Block

Module 6: Writing Control Structures

Module 7: Working with Composite Data Types

Module 8: Using Explicit Cursors

Module 9: Handling Exceptions

Module 10: Introducing Stored Procedures and Functions

Module 11: Creating Procedures

Module 12: Creating Functions

Module 13: Debugging Subprograms

Module 14: Creating Packages

Module 15: Working with Packages

Module 16: Using Oracle-Supplied Packages in Application Development

Module 17: Using Dynamic SQL

Module 18: Creating Triggers

Module 19: Creating Compound, DDL, and Event Database Triggers

Module 20: Design Considerations for the PL/SQL Code

Module 21: Tuning the PL/SQL Compiler

Module 22: Managing Dependencies