Oracle Database 19c: Advanced PL/SQL

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Mar 28, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Jun 20, 202211:0007:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Sep 7, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Dec 5, 202209:0005:00ESTToronto - In Class or by Video Conference3$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.

Further, 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. In addition, you will be introduced to various security mechanisms that can be used to secure applications

Duration: 3 days

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