PL/SQL in Oracle 19C Training in Ontario

PL/SQL in Oracle 19C Training in Ontario, Canada

This course covers the basics of PL/SQL syntax, control structures, exception handling, procedures, functions, packages, triggers, and advanced features like bulk operations and dynamic SQL.

Enroll Now

PL/SQL in Oracle 19C Training is a professional training program delivered by ProgNXT in Ontario, Canada. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this PL/SQL in Oracle 19C Training course with hands-on, instructor-led sessions. This course is designed to introduce participants to PL/SQL, Oracle's procedural language extension to SQL, within the context of Oracle Database...

Expert Panel

Designed and delivered by the ProgNXT Database Management Expert Panel — a vetted team of industry professionals with 15+ years of hands-on experience in MySQL, PostgreSQL, Oracle, and database optimization

ProgNXT Database Management Expert Panel

Course Code: JQX46
21 Hrs
Last Updated: April 2026

Course Rating5/5

This course is designed to introduce participants to PL/SQL, Oracle's procedural language extension to SQL, within the context of Oracle Database 19c. It covers the basics of PL/SQL syntax, control structures, exception handling, procedures, functions, packages, triggers, and advanced features like bulk operations and dynamic SQL. Through practical exercises, learners will develop the skills to write, debug, and optimize PL/SQL code effectively for real-world database applications.

Welcome to the official PL/SQL in Oracle 19C Training certification program in Ontario, Canada. This comprehensive training is designed to elevate your professional skills and provide you with practical, industry-relevant knowledge locally. As a globally recognized corporate training provider operating in 55+ countries, ProgNXT ensures that our curriculum meets the highest standards of excellence.

Whether you are looking to upskill your team or advance your personal career, our expert-led sessions will guide you through the core concepts of this domain. Upon successful completion of the 21 Hrs program, participants will receive a globally accepted certification, demonstrating their proficiency and readiness to tackle complex challenges in the field.

Basic understanding of SQL and relational databases
Familiarity with Oracle Database fundamentals
Prior exposure to any programming language (preferred but not mandatory)

Upon completing the course, participants will be able to:

Understand PL/SQL architecture and syntax
Write and execute anonymous PL/SQL blocks
Develop stored procedures, functions, and packages
Handle exceptions and control program flow
Create and manage database triggers
Work with cursors and bulk data operations
Optimize PL/SQL code for performance

Procedural programming in Oracle 19c
Writing and managing PL/SQL blocks
Efficient error and exception handling
Use of cursors and bulk collect
Creation of modular PL/SQL using packages
Trigger-based automation
Dynamic SQL and performance tuning

PL/SQL block structure and execution
Control structures (IF, CASE, LOOP, WHILE)
Procedures and functions
Cursors: implicit, explicit, and FOR loops
Exception handling techniques
Packages: specification and body
Triggers: row-level, statement-level
Dynamic SQL using EXECUTE IMMEDIATE
Performance optimization strategies

Participants who attend all sessions and successfully complete the course assessments will receive a ProgNXT Certificate of Completion.

Course Agenda

Introduction to PL/SQL

What is PL/SQL?
Benefits and architecture
Anonymous blocks: DECLARE, BEGIN, EXCEPTION, END

PL/SQL Syntax and Variables

Declaring variables and constants
Data types and scope
Assignments and expressions

Control Structures

Conditional statements (IF-THEN-ELSE, CASE)
Loops (LOOP, WHILE, FOR)

Cursors and Records

Implicit vs. Explicit cursors
Cursor FOR loops
Working with records

Exception Handling

Predefined and user-defined exceptions
WHEN OTHERS clause
Logging and re-raising exceptions

Procedures and Functions

Creating stored procedures and functions
IN, OUT, IN OUT parameters
Calling and managing subprograms

Packages

Benefits of packages
Creating package specifications and bodies
Using and managing package components

Triggers

Trigger types and timing events
Row-level and statement-level triggers
Mutating tables and restrictions

Optimization and Best Practices

PL/SQL compiler settings
Performance tuning techniques
Coding standards and modularization

Hands-on Exercises

Oracle Database 19c PL/SQL Language Reference
Instructor slide decks and reference handouts
Hands-on lab guides and exercises
Sample PL/SQL scripts

Module-based quizzes and practice tasks
Coding exercises and reviews

ProgNXT Certificate of Completion will be awarded to participants who successfully complete the course and assessments.

PL/SQL in Oracle 19C Training Events in ontario

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

October 2026

🌐 Online Instructor-Led

24th Oct 2026→26th Oct 2026

📍 Ontario, Canada

28th Oct 2026→30th Oct 2026

November 2026

📍 Ontario, Canada

1st Nov 2026→3rd Nov 2026

🌐 Online Instructor-Led

6th Nov 2026→8th Nov 2026

📍 Ontario, Canada

18th Nov 2026→20th Nov 2026

🌐 Online Instructor-Led

18th Nov 2026→20th Nov 2026

December 2026

🌐 Online Instructor-Led

3rd Dec 2026→5th Dec 2026

📍 Ontario, Canada

10th Dec 2026→12th Dec 2026

📍 Ontario, Canada

19th Dec 2026→21st Dec 2026

🌐 Online Instructor-Led

19th Dec 2026→21st Dec 2026

Events for other courses in Ontario, Canada

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

PL/SQL in Oracle 19C Training in Ontario