Live Chat Support

Oracle Database 11g: Advanced PL/SQL (D52601)

Oracle Database 11g: Advanced PL/SQL (D52601)

Overview

Duration: 3 Days 

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner.

Learn To:

  • 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.

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
  • 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: PL/SQL Programming Concepts Review

Module 3: Designing PL/SQL Code

Module 4: Using Collections

Module 5: Manipulating Large Objects

Module 6: Using Advanced Interface Methods

Module 7: Performance and Tuning

Module 8: Improving Performance with Caching

Module 9: Analyzing PL/SQL Code

Module 10: Profiling and Tracing PL/SQL Code

Module 11: Implementing VPD with Fine-Grained Access Control

Module 12: Safeguarding Your Code Against SQL Injection Attacks
N/A
  • Knowledge of SQL
  • PL/SQL Programming experience
  • Oracle Database: Introduction to SQL
Course ID:
D52601


Show Schedule for:

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