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.
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
Prerequisites
Basic computer skills.
Target Audience
- End users
- Business analysts
- Application developers
- Database administrators
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
Dates & Locations
August 3, 2026 - August 7, 2026
August 3, 2026 - August 7, 2026
October 5, 2026 - October 9, 2026
October 5, 2026 - October 9, 2026
December 7, 2026 - December 11, 2026
December 7, 2026 - December 11, 2026
Exam & Certification
Oracle Database 19c: PL/SQL Workshop Certification Training Course.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
