Course Name

Oracle Database 19c: Advanced PL/SQL

  • Code: D80343GC20
  • Duration: 3 Day(s)
  • Date: 09 Sep, 2024
  • Price: R21, 750.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

In this three-day instructor led course you will learn to handle complex data. You 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. Apart from handling complex data, you will learn how to interface database with other programming languages such as C and Java. 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.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:
Application Developers and Database Administrators

Course Prerequisites

  • A thorough knowledge of the SQL language
  • Working experience with SQL *Plus
  • Working experience on developing applications with PL/SQL Oracle requires and recommends that delegates have attended the following course prior to attending this course:
  • Required Course: Oracle Database: Introduction to SQL
  • Required Course: Oracle Database: Program with PL/SQL

Course Objectives

Upon completion, students will be able to:

  • Write powerful PL/SQL programs
  • Explore programming efficiency
  • Use external C and Java routines
  • Apply PL/SQL designing best practices
  • Create PL/SQL applications that use collections
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with external C and Java applications
  • Write code to interface with large objects and use SecureFile LOBs
  • Write and tune PL/SQL code effectively to maximize performance

Course Content

  • Module 1: Introduction
  • Module 2: Working with Exadata Express Cloud Service
  • Module 3: Designing PL/SQL Code
  • Module 4: Overview of Collections
  • Module 5: Using Collections
  • Module 6: Handling Large Objects
  • Module 7: JSON Data in Database
  • Module 8: Advanced Interface Methods
  • Module 9: Performance and Tuning
  • Module 10: Improving Performance with Caching
  • Module 11: Analyzing PL/SQL Code
  • Module 12: Profiling and Tracing PL/SQL Code
  • Module 13: Securing Applications through PL/SQL
  • Module 14: Safeguarding Your Code against SQL Injection Attacks
  • Module 15: Advanced Security Mechanisms
  • Module 16: Table Descriptions and Data
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

In this three-day instructor led course you will learn to handle complex data. You 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. Apart from handling complex data, you will learn how to interface database with other programming languages such as C and Java. 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.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:
Application Developers and Database Administrators

Course Prerequisites

  • A thorough knowledge of the SQL language
  • Working experience with SQL *Plus
  • Working experience on developing applications with PL/SQL Oracle requires and recommends that delegates have attended the following course prior to attending this course:
  • Required Course: Oracle Database: Introduction to SQL
  • Required Course: Oracle Database: Program with PL/SQL

Course Objectives

Upon completion, students will be able to:

  • Write powerful PL/SQL programs
  • Explore programming efficiency
  • Use external C and Java routines
  • Apply PL/SQL designing best practices
  • Create PL/SQL applications that use collections
  • Implement a virtual private database with fine-grained access control
  • Write code to interface with external C and Java applications
  • Write code to interface with large objects and use SecureFile LOBs
  • Write and tune PL/SQL code effectively to maximize performance

Course Content

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

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US