Oracle Database 19c: Advanced PL/SQL



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Mar 13, 202409:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Jun 12, 202411:0007:00EDTLive Virtual Class3$3,600 USDPurchase
Sep 25, 202409:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Dec 11, 202409:0005:00ESTLive Virtual Class3$3,600 USDPurchase


Oracle Database 19c: Advanced PL/SQL

In this course, you will learn to handle complex data. You will learn about collections, which enable you to work with a logical group of homogenous data. You will also learn to manage large objects and JSON data in the database. You will be introduced to utilities such as PL/Scope and hierarchical profiler to analyze, trace, and profile PL/SQL code. These functions help you in improving the performance of the application. Further, you will be introduced to various security mechanisms that can be used to secure applications.

Duration: 3 Days


  • Application Developers
  • Database Developers

Learning Objectives

  • Use PL/SQL programming structure
  • Use explicit and implicit cursors in PL/SQL
  • Understand for, while and basic loop processing in PL/SQL
  • Discuss programmer defined procedures and functions
  • Use UTL_FILE and directories for I/O
  • Understand exception handling


  • Working with Exadata Express Cloud Service
  • Using Collections
  • Handling Large Objects
  • JSON Data in Database
  • Advanced Interface Methods
  • Performance and Tuning
  • Improving Performance with Caching
  • Analyzing PL/SQL Code
  • Profiling and Tracing PL/SQL Code
  • Securing Applications through PL/SQL
  • Safeguarding Your Code Against SQL Injection Attacks
  • Advanced Security Mechanisms
Right Menu IconMENU