Advance PL/SQL Developer Training Certification Course Advance PL/SQL Developer Training Certification Course

Oracle 11 g PLSQL Developer Advance

PL/SQL Developer Advance Training

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

  • 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

  • Database Administrators
  • Application Developers
  • PL/SQL Developer

Prerequisites

  • Knowledge of SQL
  • PL/SQL Programming experience
  • Exam Prerequisites
  • Candidate should have "oracle PL/SQL Developer Associate" Certification

Course Outline

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

Certification

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