Course Code: 19192

Oracle Database 19c: Advanced PL/SQL

Class Dates:
10/21/2024
12/11/2024
9/25/2024
Length:
3 Days
Cost:
$3495.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • 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

Prerequisites

Course Disclaimer

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run the course. Course may run virtually as a virtual live instructor led class if the minimum enrollment is not met. For more information, please contact: 207-775-0244 or email: learn@vtec.org.

Remote Classroom Training
Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Course Details

  • Skills Gained
  • 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