Oracle Database 19c: Advanced PL/SQL

Duration : 3 Days (24 Hours)

Oracle Database 19c: Advanced PL/SQL Course Overview:

The Oracle Database 19c Advanced PL/SQL certification is intended for professionals seeking to validate their expertise in designing, creating, and managing PL/SQL application components within the Oracle 19c database. PL/SQL, or Procedural Language for SQL, is Oracle’s proprietary extension that enhances SQL commands with procedural capabilities. The certification covers advanced topics such as PL/SQL stored program units, server-side PL/SQL applications, and triggers. Holding this certification demonstrates advanced proficiency in handling complex database tasks, making it highly valuable in the IT industry, especially for roles like database administrators, software developers, and system analysts. It equips professionals with the skills to manage data-driven applications efficiently and securely.

Intended Audience:

  • Experienced Oracle Database users seeking advanced skills
  • IT professionals responsible for managing Oracle Database
  • Database administrators wanting in-depth understanding of PL/SQL
  • Software developers familiar with Oracle looking to enhance PL/SQL coding skills
  • System analysts working on Oracle applications
  • IT consultants utilizing Oracle Database in their projects

Learning Objectives of Oracle Database 19c: Advanced PL/SQL:

The Oracle Database 19c: Advanced PL/SQL course is designed to provide learners with an in-depth understanding of the features of Oracle Database 19c. The course focuses on mastering advanced aspects of PL/SQL, including writing efficient PL/SQL code, optimizing performance, and utilizing application architect features. Learners will also acquire knowledge on creating, managing, and effectively using collections, as well as implementing advanced coding techniques.

Moreover, the course covers topics related to handling packages, dealing with large objects, making use of compiler features, and executing external procedures. By the end of the course, learners will be proficient in designing and tuning PL/SQL code for optimal performance in their work environment.

 Module 1: Introduction

 Module 2: Working with Exadata Express Cloud Service

 Module 3: Overview of Collections

 Module 4: Using Collectionss

 Module 5: Handling Large Objects

 Module 6: JSON Data in Database

 Module 7: Advanced Interface Methods

 Module 8: Performance and Tuning

 Module 9: Improving Performance with Caching

 Module 10: Analyzing PL / SQL Code

 Module 11: Profiling and Tracing PL / SQL Code

 Module 12: Securing Applications through PL / SQL

 Module 13: Safeguarding Your Code against SQL Injection Attacks

 Module 14: Advanced Security Mechanisms

Oracle Database 19c: Advanced PL/SQL Course Prerequisites:

• Knowledge of SQL and PL/SQL fundamentals.
• Expertise in Oracle Database 12c or higher.
• Prior experience in database administration or application development.
• Understanding of database concepts and architecture, relational databases, data modeling, and basic UNIX commands.
• Familiarity with Oracle data types, triggers, packages, procedures, functions, and exception handling.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.