Oracle Database 11g: SQL Tuning Workshop (Self-Study Course)

 

Zielgruppe

  • Support Engineer
  • Application Developers
  • Data Warehouse Developer
  • Developer
  • PL/SQL Developer
  • Database Administrators
  • Data Warehouse Administrator

Voraussetzungen

  • Oracle Database 11g: Professioneller Einstieg in SQL Release 2

Kursziele

  • Identify problem SQL statements
  • Modify a SQL statement to perform at its best
  • Trace an application
  • Understand how the Query Optimizer makes decisions about how to access data
  • Interpret execution plans
  • Use optimizer hints effectively
  • Generate a load test

Produktbeschreibung

  • Architecture, SQL Tuning, and Optimization
    • Database Architecture and SQL Tuning
    • SQL Processing and the Optimizer
  • Indexes, Access Paths, and Join Operations
    • Table Scans, Indexes, Access Paths, and Joins
  • Execution Plans and Star Transformations
    • Interpreting Execution Plans
    • Understanding Star Transformation
  • Optimizer Statistics, Hints, and Cursor Sharing
    • Optimizer Statistics
    • Bind Variables, Cursor Sharing, and Optimizer Hints
  • Application Tracing and Automatic SQL Tuning
    • Application Tracing, Trace Files, and the tkprof Utility
    • Automatic SQL Tuning
E-Learning Oracle Training on Demand
Preis (exkl. MwSt.)
  • CHF 1'079.–
Bestellen