Skip to content

Campaigns
Free Workshops
Principals
Blog & Resources
2025 Training Calendar
Team Building

All Courses

Search for:

HRD Corp Claimable

Yayasan Peneraju Training and Certification

Yayasan Peneraju

My Account
- Username:
  Password:
  Remember Me
  Register
Request a Quote
WooCommerce Cart

Menu

Principals
All Courses
2025 Training Calendar
Blog & Resources
Campaigns
Facilities Rental
Free Workshops
Modalities
My Account

Cart

Search for:

Home » Oracle Database » OD-19c-PW: Oracle Database 19c: PL/SQL Workshop

OD-19c-PW: Oracle Database 19c: PL/SQL Workshop

Oracle Database Technologies.

Oracle Database offers market-leading performance, scalability, reliability, and security, both on-premises and in the cloud. Oracle Database 19c is the current long term release, and it provides the highest level of release stability and longest time-frame for support and bug fixes.

Get the best performance for your most demanding analytical and operational workloads with Oracle Database training and certification.

Fees:

RM6,500.00 – RM7,562.00

Course duration

5 days

Accredited by

Array
(
    [ID] => 8287
    [id] => 8287
    [title] => oracle
    [filename] => oracle.svg
    [filesize] => 1870
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
    [link] => https://trainocate.com.my/?attachment_id=8287
    [alt] => Oracle Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => oracle
    [status] => inherit
    [uploaded_to] => 9057
    [date] => 2021-08-25 01:59:22
    [modified] => 2021-12-24 07:10:28
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

Home » Oracle Database » OD-19c-PW: Oracle Database 19c: PL/SQL Workshop

OD-19c-PW: Oracle Database 19c: PL/SQL Workshop

Oracle Database Technologies.

Oracle Database offers market-leading performance, scalability, reliability, and security, both on-premises and in the cloud. Oracle Database 19c is the current long term release, and it provides the highest level of release stability and longest time-frame for support and bug fixes.

Get the best performance for your most demanding analytical and operational workloads with Oracle Database training and certification.

Course duration:

5 days

Fees:

RM6,500.00 – RM7,562.00

Accredited by:

Array
(
    [ID] => 8287
    [id] => 8287
    [title] => oracle
    [filename] => oracle.svg
    [filesize] => 1870
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
    [link] => https://trainocate.com.my/?attachment_id=8287
    [alt] => Oracle Training and Certification
    [author] => 1
    [description] => 
     => 
    [name] => oracle
    [status] => inherit
    [uploaded_to] => 9057
    [date] => 2021-08-25 01:59:22
    [modified] => 2021-12-24 07:10:28
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

HRD Corp Claimable Training and Certification

Yayasan Peneraju Training and Certification

Yayasan Peneraju Financing Scheme

Overview
Course Curriculum
Training Options
Exam & Certification
FAQs

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

Download Course Syllabus

First Name*

Last Name*

Email*

Phone*

Download Link

Request a callback*

Yes - Please reach out to me

No - That's all for now

This field should be left blank

Course Modules

Expand all Collapse all

Course Contents

1 :Introduction
2 :Introduction to PL/SQL
3 :Declaring PL/SQL Variables
4 :Writing Executable Statements
5 :Using SQL Statements Within a PL/SQL Block
6 :Writing Control Structures
7 :Working with Composite Data Types
8 :Using Explicit Cursors
9 :Handling Exceptions
10 :Introducing Stored Procedures and Functions
11 :Creating Procedures
12 :Creating Functions
13 :Debugging Subprograms
14 :Creating Packages
15 :Working with Packages
16 :Using Oracle-Supplied Packages in Application Development
17 :Using Dynamic SQL
18 :Creating Triggers
19 :Creating Compound, DDL, and Event Database Triggers
20 :Design Considerations for the PL/SQL Code
21 :Tuning the PL/SQL Compiler
22 :Managing Dependencies

Request More Information

Name*

Email*

Phone*

Estimated Headcount*

I'm inquiring as:

Self Sponsored

Company Sponsored

Yayasan Peneraju (Bumiputera Only)

Company*

Job Title*

By providing your contact details, you agree to our Privacy Policy

This field should be left blank

Training Options

Filter by:

ILT: Instructor-Led Training
VILT: Virtual Instructor-Led Training

Intake: 19-23 May 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 19-23 May 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 7-11 Jul 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 7-11 Jul 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 29 Sep - 3 Oct 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 29 Sep - 3 Oct 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 10-14 Nov 2025

Duration: 5 Days

Guaranteed: TBC

Modality: ILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Intake: 10-14 Nov 2025

Duration: 5 Days

Guaranteed: TBC

Modality: VILT

Price:

RM6,500.00Enroll Now

RM7,562.00Enroll Now

Exam: Add exam fees

Course added

View Quote Page

Course added

View Quote Page

Exam & Certification

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

Training & Certification Guide

Frequently Asked Questions

Stay connected. Be the first to know.

Company

About Us
Blog & Resources
Modalities
Career
Become Our Trainer
Contact Us

Customer Service

My Account
Payment & Policies
PDPA
Copyright & Trademarks

Principals

Microsoft Certified
Red Hat Training
Google Cloud Certified
IBM Education
DELL-EMC
View All

2024 TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE-01

HRD Corp Training Provider 2

Stay connected. Be the first to know.

TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE 2024

HRD Corp Training Provider 2

Trainocate: A Global Leader in Technology, Business, and People Development

In a world that never stands still, we help you move forward.

With over 30 years of experience, Trainocate has been empowering individuals and businesses to build the essential skills that drive growth and success. Whether it’s professionals advancing in their careers or organizations transforming their workforce, our training programmes deliver results.

Specializing in cloud computing, data & AI, cybersecurity, and digital leadership, our training is powered by industry-leading technology partners like AWS, Alibaba Cloud, Cisco, EC-Council, Fortinet, Google Cloud, IBM, ISACA, ISC2, Microsoft, NetApp, Nutanix, Oracle, Palo Alto, Splunk, Red Hat, Rocheston, Trend Micro, and VMware.

Trainocate Group operates in 24 countries blending global expertise with localized insights to train the next generation of tech professionals and business leaders.

Trainocate Malaysia, based in KL Eco City, is proud to be an HRD Corp Registered Training Provider and a Yayasan Peneraju ALTI, driving workforce development across Malaysia.

© Copyright Trainocate 2024. All rights reserved. IT Training Provider Malaysia

Use "Up" and "Down" arrows to move between options

Click the right arrow to expand children, left arrow to collapse.