Online Oracle Advanced SQL Optimization Techniques Training Classes And Courses  BISP 

60% Complete Courses » Oracle Advanced SQL Optimization Techniques
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


INTRODUCTION TO ORACLE PERFORMANCE TUNING
  • Tuning Overview
  • Oracle Tuning Process
  • Setting Suitable Goals
  • Tips for Avoiding Problematic Queries
  • Syntax Considerations
  • Programming Standards
  • Isolate a Performance Problem
  • Analyze a Problem SQL Statement to Determine the Nature of the Problem
TOOLS FOR EVALUATING SQL STATEMENTS
  • Overview of SQL Statement Tuning
  • Tools to Assist in SQL Tuning
  • Use Explain Plan, Autotrace and SQL Trace to Examine the Execution of a SQL Statement
  • Interpreting a SQL Trace
OPTIMIZER STATISTICS
  • Cost Based Optimizer
  • Analyze and Use System Statistics
  • Managing Statistics with DBMS_STATS
  • Automatic Statistics Gathering
SORTS
  • How Oracle Processes Sorts
  • Temporary Disk Space Assignment
  • SQL Operations that Use Sorts
INDEXES
  • Index Overview
  • B*Tree Indexes
  • Access Paths with Indexes
  • Index Scans
  • Conditions That Stop Indexes Being Used
ADVANCED INDEXES
  • Bitmap Indexes
  • Key Compressed Indexes
  • Index Organized Tables
  • Function Based Indexes
  • Descending Indexes
  • Invisible Indexes
JOIN OPERATIONS
  • Understand Access Paths
  • Joining Tables
  • Nested Loops Join
  • Merge Join
  • Cluster Join
  • Hash Join
  • Anti Join and Semi Join
  • Outer Joins
  • Star Join
  • Improve Optimization with Different Access Paths
SQL TUNING ADVISOR
  • The DBMS_SQL_TUNE Package
  • Using the SQL Tuning Advisor with SQL Developer
SQL PLAN MANAGEMENT
  • Use SQL Plan Management
  • Adaptive SQL Plan Management
  • Adaptive Query Optimization
SEQUENCES AND VIEWS
  • Sequence Caching
  • Views
  • View Merging
  • Inline Views
USING HINTS
  • Using Hints to Influence Execution Plan
  • Optimization Mode and Goals
  • Access Methods
  • Query Transformations
  • Join Orders
  • Join Operations
  • Hint Examples
MISCELLANEOUS
  • Array Size
  • Bind Variable Usage
  • Adaptive Cursor Sharing
  • Result Caching
Course Id:
ODT006 
Course Fees:
241 USD