TypeClassroom Training
Oracle 11 g PL SQL Developer Advance

Oracle 11 g PLSQL Developer Advance Training Course & Certification


Audience & Prerequisites

Course Outline

Schedule & Fees


Oracle 11 g PLSQL Developer Advance Training Course

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 of Oracle 11 g PLSQL Developer Advance Training

  • 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

Innovative Technology Solutions offers PL/SQL Developer Advance Training in 9 different locations in India – Bangalore, Chennai, Delhi, Gurgaon, Hyderabad, Kolkata, Mumbai, Noida & Pune.

Intended Audience for Oracle 11 g PLSQL Developer Advance Course

  • Database Administrators
  • Application Developers
  • PL/SQL Developer

Prerequisites for Oracle 11 g PLSQL Developer Advance Certification

    • Knowledge of SQL
    • PL/SQL Programming experience
    • Exam Prerequisites

Candidate should have “oracle PL/SQL Developer Associate” Certification

Course Outline                                                                                                                             Duration: 3 Days

  1. Introduction
    • Course objectives
    • Course agenda
    • Tables and data used for this course
    • Overview of the development environments: SQL Developer, SQL Plus
  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
  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
  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
  5. Manipulating Large Objects
    • Describe a LOB object
    • 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
  6. Using Advanced Interface Methods
    • Calling External Procedures from PL/SQL
    • Benefits of External Procedures
    • C advanced interface methods
    • Java advanced interface methods
  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
  8. Improving Performance with Caching
    • Describe result caching
    • Use SQL query result cache
    • PL/SQL function cache
    • Review PL/SQL function cache considerations
  9. Analyzing PL/SQL Code
    • Finding Coding Information
    • Collecting PL/Scope Data
    • DBMS_METADATA Package
  10. Profiling and Tracing PL/SQL Code
    • Tracing PL/SQL Execution
    • Tracing PL/SQL: Steps
  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
  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

Please write to us at info@itstechschool.com or contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query


After completing this course Candidates have to give “Oracle 11g Advanced PL/SQL 1Z0-146“ Exam to get certification. For more info kindly contact us.