Oracle Database 19c: PL/SQL Workshop

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

  • Học trực tuyến

  • Học tại Hồ Chí Minh

  • Học tại Hà Nội

Các khóa học khác