Oracle Database 19c: Advanced PL/SQL

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Mar 13, 202309:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Jun 12, 202309:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Sep 25, 202311:0007:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Dec 11, 202309:0005:00ESTToronto - In Class or by Video Conference3$3,600 USDPurchase


O19C: ADV PL/SQL

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

Audience

  • 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

Topics

  • 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