Oracle Database 19c – Advanced PL/SQL

3 day course Oracle Database 19c: Advanced PL/SQL teaches participants how to use the advanced features of PL/SQL to design and tune PL/SQL for database interface and other applications. In the course, they will learn advanced program design features, packages, cursors, extended interface methods, and collections. This course will also introduce the concepts Oracle Database Exadata Express Cloud Service.

Who is it for?

The course is intended for application developers and database administrators.

What will you learn?

Participants in this course will learn to:

• Write powerful PL/SQL programs
• Explores scheduling efficiency
• Use C and Java external routines
• Apply PL/SQL design best practices
• Create PL/SQL applications that use collections
• Write code to interact with external C and Java applications
• Design PL/SQL packages and program units that execute efficiently
• Write code to interface with external applications and the operating system
• Write and tune PL/SQL code effectively to maximize performance
• Implement a virtual private database with fine-grained access control
• Write code for interacting with large objects and using SecureFile LOB
• Gain an understanding of the service Oracle Database Exadata Express Cloud Service

Prerequisites:

Before taking this course, it is recommended that participants:

• Has basic knowledge of SQL, PL/SQL
• Be familiar with programming languages
• Participate in the course Oracle Database 19c: SQL Tuning Workshop

Course schedule:

Course materials are in English. Teaching is done in Romanian.

Module 1: Introduction
Module 2: Working with Exadata Express Cloud Service
Module 3: Overview of Collections
Module 4: Using Collections
Module 5: Handling Large Objects
Module 6: JSON Data in Database
Module 7: Advanced Interface Methods
Module 8: Performance and Tuning
Module 9: Improving Performance with Caching
Module 10: Analyzing PL / SQL Code
Module 11: Profiling and Tracing PL / SQL Code
Module 12: Securing Applications through PL / SQL
Module 13: Safeguarding Your Code against SQL Injection Attacks
Module 14: Advanced Security Mechanisms

We recommend continuing with:

There are no recommendations at this time.

Certification programs

This course is part of the learning path for the certification exam Oracle Database Program with PL/SQL 1Z0-149, thus becoming Oracle Database PL/SQL Developer Certified Professional.