Overview

Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.

This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop 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.

Skills Covered

  • 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

Who Should Attend

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

Course Curriculum

Prerequisites

Basic computer skills.

Download Syllabus

Course Modules

Request More Information

Training Options

Intake: 26 Feb - 1 Mar 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 26 Feb - 1 Mar 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 1-5 Apr 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 1-5 Apr 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 24-28 Jun 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 24-28 Jun 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 19-23 Aug 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 19-23 Aug 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 7-11 Oct 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 7-11 Oct 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 16-20 Dec 2024
Duration: 5 Days
Guaranteed: TBC
Modality: ILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:
Intake: 16-20 Dec 2024
Duration: 5 Days
Guaranteed: TBC
Modality: VILT
Price:

RM6,500.00Enroll Now

RM7,680.00Enroll Now

Exam:

Exam & Certification

Oracle Database 19c: PL/SQL Workshop Certification Training Course.

Training & Certification Guide

Frequently Asked Questions