Oracle Database 19c: Advanced PL/SQL Course Overview

Oracle Database 19c: Advanced PL/SQL Course Overview

The Oracle Database 19c: Advanced PL/SQL course is designed for experienced PL/SQL programmers who want to learn advanced features and best practices for building robust and secure applications. This comprehensive SQL PLSQL course goes beyond the basics, empowering learners to write efficient and complex PL/SQL code.

Starting with an introduction to the course structure, Module 1 sets the stage for a deep dive into advanced programming topics. Each subsequent module tackles a specific aspect of PL/SQL, from leveraging Exadata Express Cloud Service in Module 2 for cloud-based solutions, to understanding and using collections in Modules 3 and 4. The course also covers handling large objects, utilizing JSON data, and implementing advanced interface methods.

Performance tuning, caching strategies, and code analysis are thoroughly explored to enhance application efficiency. Security is a major focus, with modules dedicated to application security, preventing SQL injection attacks, and employing advanced security mechanisms to protect sensitive data. Overall, this course equips learners with sophisticated tools and knowledge to excel in PL/SQL development.

Koenig's Unique Offerings


1-on-1 Training

Schedule personalized sessions based upon your availability.


Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.


4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.


Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

Fee On Request

  • Live Online Training (Duration : 24 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 24 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Course Prerequisites

To ensure that students can successfully grasp the content and derive maximum benefit from the Oracle Database 19c: Advanced PL/SQL course, the following are the minimum prerequisites that should be met:

  • Basic knowledge of database concepts and familiarity with the Oracle database environment.
  • Understanding of SQL, including the ability to write queries and manipulate data using DML (Data Manipulation Language).
  • Prior experience with basic PL/SQL such as writing simple blocks, functions, and procedures.
  • Familiarity with Oracle Database 19c fundamentals. It is advantageous if the student has completed the Oracle Database 19c: Introduction to SQL or has equivalent experience.
  • Ability to navigate the Linux operating system, as it is commonly used for Oracle Database installations.
  • Enthusiasm to learn advanced database programming and a commitment to apply the concepts learned in practical scenarios.

These prerequisites are designed to ensure that students have a solid foundation upon which they can build advanced PL/SQL skills. While some topics may be challenging, the course is structured to guide learners through progressively more complex concepts, with the goal of making them proficient in using advanced features of PL/SQL in Oracle Database 19c.

Target Audience for Oracle Database 19c: Advanced PL/SQL

  1. The Oracle Database 19c: Advanced PL/SQL course is designed for experienced professionals seeking to deepen their expertise in Oracle PL/SQL, database management, and performance tuning.

  2. Target Audience for the Course:

  • Database Administrators
  • PL/SQL Developers
  • Data Analysts
  • Software Engineers with a focus on database systems
  • IT Professionals working with Oracle Databases
  • System Integrators
  • Technical Consultants
  • Data Warehouse Specialists
  • Application Developers working with Oracle Database 19c
  • Database Designers
  • Security Administrators
  • Performance Tuning Specialists

Learning Objectives - What you will Learn in this Oracle Database 19c: Advanced PL/SQL?

Introduction to Course Learning Outcomes:

Gain advanced skills in Oracle PL/SQL for optimizing, securing, and writing powerful database-centric applications with Oracle Database 19c.

Learning Objectives and Outcomes:

  • Understand the architecture and functionality of Exadata Express Cloud Service for efficient database management.
  • Master the use of collections in PL/SQL for handling complex data types and improving application performance.
  • Learn to manage and manipulate Large Objects (LOBs) for handling multimedia and long-form textual data within the database.
  • Acquire the ability to store, query, and manipulate JSON data directly in Oracle Database 19c.
  • Explore advanced interface methods to integrate PL/SQL with external applications and services.
  • Implement performance tuning techniques to optimize PL/SQL code execution and database response times.
  • Apply caching strategies to enhance application performance by reducing redundant database access.
  • Analyze and refine PL/SQL code for maintainability, efficiency, and adherence to best practices.
  • Employ profiling and tracing tools to diagnose performance bottlenecks and optimize PL/SQL procedures and functions.
  • Enhance application security by preventing SQL injection attacks and using advanced security mechanisms to protect sensitive data.