651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Oracle Database 19c: Advanced PL/SQL

3 days

Description

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

Skills Gained

  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

Audience

  • Database Administrators
  • Developers

Upcoming Classes

Virtual Classroom Live
December 11, 2024

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
January 20, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
April 30, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Introduction
  • Working with Exadata Express Cloud Service
  • Overview of Collections
  • 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 Tracking PL/SQL Code
  • Securing Applications Through PL/SQL
  • Safeguarding Your Code Against SQL Injection Attacks
  • Advanced Security Mechanisms

Upcoming Classes

Virtual Classroom Live
December 11, 2024

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
January 20, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
April 30, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

  • Oracle Database 19c: SQL Workshop
  • Oracle Database 19c: PL/SQL Workshop

Upcoming Classes

Virtual Classroom Live
December 11, 2024

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
January 20, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Virtual Classroom Live
April 30, 2025

$3,600.00
3 days    9 AM ET - 5 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date