D52601 - Oracle Database 11g: Advanced PL/SQL

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.

Code: d52601

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

Content

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

Audience

  • Application Developers
  • Database Administrators
  • PL/SQL Developer

Prerequisites

  • Knowledge of SQL
  • PL/SQL Programming experience
  • Oracle Database: Introduction to SQL

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
FLOkIG
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy