Oracle Database 19c: Advanced PL/SQL Ed 2

This course 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. In Oracle Database 19c: Advanced PL/SQL training you will learn 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.

STUDENTS WILL LEARN TO

After completing this course, you will be able to:

  • Design PL / SQL packages and program units that execute efficiently
  • Write code to interface with external applications and the operating system
  • Create PL / SQL applications that use collections
  • Write and tune PL / SQL code effectively to maximize performance
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with large objects and use SecureFile LOBs
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service
Phone
Phone
Product
Oracle
Code
D1101121C10
Duration
3 Days
Price (baht)
45,000

About the course

COURSE TOPICS

Module 1 : Introduction

  • Introduction

Module 2 : Working with Exadata Express Cloud Service

  • Working with Exadata Express Cloud Service

Module 3 : Overview of Collections

  • Overview of Collections
  • Practice 3-1: Analyzing Collections

Module 4 : Using Collections

  • Using Collections
  • Practice 4-1: Using Collections

Module 5 : Handling Large Objects

  • Handling Large Objects
  • Practice 5-1: Working with LOBs

 Module 6 : JSON Data in Database

  • JSON Data in Database
  • Practice 6-1: JSON Data in Tables
  • Practice 6-2: JSON Data in PL/SQL Blocks

Module 7 : Advanced Interface Methods

  • Advanced Interface Methods
  • Practice 7-1: Using Advanced Interface Methods

Module 8 : Performance and Tuning

  • Performance and Tuning
  • Practice 8-1: Performance and Tuning (Part 1)
  • Practice 8-1: Performance and Tuning (Part 2)

Module 9 : Improving Performance with Caching

  • Improving Performance with Caching
  • Practice 9-1: Improving Performance with Caching

Module 10 : Analyzing PL/SQL Code

  • Analyzing PL/SQL Code
  • Practice 10-1: Analyzing PL/SQL Code

Module 11 : Profiling and Tracing PL/SQL Code

  • Profiling and Tracing PL/SQL Code
  • Practice 11-1: Profiling and Tracing PL/SQL Code

Module 12 : Securing Applications through PL/SQL

  • Securing Applications through PL/SQL
  • Practice 12-1: Implementing Fine-Grained Access Control for VPD

Module 13 : Safeguarding Your Code against SQL Injection Attacks

  • Safeguarding Your Code against SQL Injection Attacks
  • Practice 13-1: Safeguarding Your Code against SQL Injection Attacks

Module 14 : Advanced Security Mechanisms

  • Advanced Security Mechanisms

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save