Live Chat Support

Oracle Database 12c R2: Advanced PL/SQL (D80343)

Oracle Database 12c R2: Advanced PL/SQL (D80343)

Overview

Duration: 3 Days 

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Learn To:

  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Work with JSON data in the database.
  • 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.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
    • 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
    • Learn to work with JSON data in relational database
    • 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
    Module 1: Introduction

    Module 2: Oracle Database Exadata Express Cloud Service

    Module 3: Overview of Collections

    Module 4: Using Collections in PL/SQL

    Module 5: Manipulating Large Objects

    Module 6: Working with JSON Data

    Module 7: Using 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 application through PL/SQL

    Module 13: Safeguarding Your Code Against SQL Injection Attacks

    Module 14: Security Features implemented through PL/SQL
    N/A
    • Basic Knowledge of SQL, PL/SQL
    • Knowledge of PL/SQL Program Units
    • Familiarity with programming languages
    • Oracle Database: SQL Workshop I Ed 2
    • Oracle Database: Develop PL/SQL Program Units Ed 2
    Course ID:
    D80343


    Show Schedule for:

    Please provide as much information as possible for us to help you with your enquiry.