Oracle Database 11g: Advanced PL/SQL/1Z0-146

Oracle Database 11g: Advanced PL/SQL Certification Training Course Overview

The Oracle Database 11g: Advanced PL/SQL training and certification course will give you a detailed overview of the advanced features of PL/SQL to design and tune PL/SQL. During the training, you will learn how it interfaces with the database and other applications in the most efficient manner.

Who should do Oracle Database 11g: Advanced PL/SQL training?

  • Database Administrator
  • Developer
This course prepares you for Exam 1Z0-146.

Oracle Database 11g: Advanced PL/SQL (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1050
08 - 10 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1200
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1:Introduction
  • Course objectives
  • Course agenda
  • Tables and data used for this course
  • Overview of the development environments: SQL Developer, SQL Plus
Module 2:PL/SQL Programming Concepts Review
  • Identify PL/SQL block structure
  • Create procedures
  • Create functions
  • List restrictions and guidelines on calling functions from SQL expressions
  • Create packages
  • Review of implicit and explicit cursors
  • List exception syntax
  • Identify the Oracle supplied packages
Module 3:Designing PL/SQL Code
  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • List the different guidelines for cursor design
  • Cursor variables
Module 4:Using Collections
  • Overview of collections
  • Use Associative arrays
  • Use Nested tables
  • Use VARRAYs
  • Compare nested tables and VARRAYs
  • Write PL/SQL programs that use collections
  • Use Collections effectively
Module 5: Manipulating Large Objects
  • Describe a LOB objec
  • Use BFILEs
  • Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
  • Create a temporary LOB programmatically with the DBMS_LOB package
  • Introduction to SecureFile LOBs
  • Use SecureFile LOBs to store documents
  • Convert BasicFile LOBs to SecureFile LOB format
  • Enable reduplication and compression
Module 6:Using Advanced Interface Methods
  • Calling External Procedures from PL/SQL
  • Benefits of External Procedures
  • C advanced interface methods
  • Java advanced interface methods
Module 7:Performance and Tuning
  • Understand and influence the compiler
  • Tune PL/SQL code
  • Enable intra unit inlining
  • Identify and tune memory issues
  • Recognize network issues
Module 8:Improving Performance with Caching
  • Describe result caching
  • Use SQL query result cache
  • PL/SQL function cache
  • Review PL/SQL function cache considerations
Module 9:Analyzing PL/SQL Code
  • Finding Coding Information
  • Using DBMS_DESCRIBE
  • Using ALL_ARGUMENTS
  • Using DBMS_UTILITY.FORMAT_CALL_STACK
  • Collecting PL/Scope Data
  • The USER/ALL/DBA_IDENTIFIERS Catalog View
  • DBMS_METADATA Package
Module 10:Profiling and Tracing PL/SQL Code
  • Tracing PL/SQL Execution
  • Tracing PL/SQL: Steps
Module 11:Implementing VPD with Fine-Grained Access Control
  • Understand how fine-grained access control works overall
  • Describe the features of fine-grained access control
  • Describe an application context
  • Create an application context
  • Set an application context
  • List the DBMS_RLS procedures
  • Implement a policy
  • Query the dictionary views holding information on fine-grained access
Module 12:Safeguarding Your Code Against SQL Injection Attacks
  • SQL Injection Overview
  • Reducing the Attack Surface
  • Avoiding Dynamic SQL
  • Using Bind Arguments
  • Filtering Input with DBMS_ASSERT
  • Designing Code Immune to SQL Injections
  • Testing Code for SQL Injection Flaws
Download Course Contents

Request More Information

Course Prerequisites
  • Fundamental Knowledge of SQL
  • PL/SQL Programming experience

On completion of this training, you will know:

  • 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