Oracle Database 11g: Advanced PL/SQL
Course code
Orl11g Adv
Duration
3 Days, 24 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
Course overview
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.
Benefits to You
Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.
Objectives
Course 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
Prerequisites
Required Prerequisite
- Knowledge of SQL
- PL/SQL Programming experience
Audience
- Database Administrator
- Developer
Course Outline
Course Topics
- Introduction
- PL/SQL Programming Concepts Review
- Designing PL/SQL Code
- Using Collections
- Manipulating Large Objects
- Using Advanced Interface Methods
- Performance and Tuning
- Improving Performance with Caching
- Analyzing PL/SQL Code
- Profiling and Tracing PL/SQL Code
- Implementing VPD with Fine-Grained Access Control
- Safeguarding Your Code Against SQL Injection Attacks
