FORGOT YOUR DETAILS?

eluide9eb7f5d

Oracle Database 19c: Advanced PL/SQL

Cost
$3600 USD
Course Code
D1101121GC10
Duration
3 Days
Format
Live Virtual Class

Course Schedule

Oracle Database 19c: Advanced PL/SQL

$3,600.00

Scheduled, 07-Nov-2022 - 09-Nov-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 01-May-2023 - 03-May-2023, 09:00 AM - 05:00 PM US Eastern
Choose an option
Oracle Database 19c: Advanced PL/SQL – Scheduled, 07-Nov-2022 - 09-Nov-2022, 09:00 AM - 05:00 PM US Eastern
$3,600.00
Oracle Database 19c: Advanced PL/SQL – Scheduled, 01-May-2023 - 03-May-2023, 09:00 AM - 05:00 PM US Eastern
$3,600.00
Clear
SKU: D1101121GC10 Categories: , ,

Overview

This Oracle Database 19c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

  • 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

Suggested Prerequisites

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

Topics

  • 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

Overview

This Oracle Database 19c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

  • 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

Suggested Prerequisites

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

Topics

  • 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

Related Courses…

TOP
0