Oracle Database: SQL Tuning for Developers - D99667

  • Treuepunkte: 3000
  • Hersteller-ID: D108646
  • ETC-Seminar-ID: D99667
  • Sprache: Deutsch

Beschreibung

In this course, students learn about Oracle SQL tuning and how to apply tuning techniques to their SQL code. This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL. It covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, and how to determine if those are the most efficient ways is a particular database

expand_more chevron_right Zielgruppe

Dieses Seminar richtet sich an:
  • Application Developers
  • Developer
  • Support Engineer
  • Data Warehouse Developer
  • PL/SQL Developer

    expand_more chevron_right Vorkenntnisse

    Required Prerequisite:
    Oracle Database: Introduction to SQL Ed 2
    Oracle Database: SQL Workshop I Ed 2

    Suggested Prerequisite:
    Knowledge of SQL and PL/SQL
    Familiarity with database architecture
     

    expand_more chevron_right Detail-Inhalte

    Introduction
    • Workshops, Demo Scripts, and Code Example Scripts
    • SQL Environments Available in the Course
    • Course Objectives, Course Agenda and Appendixes Used in this Course
    • Sample Schemas Used in the Course
    • Class Account Information
    • Appendices in the Course
    • Audience and Prerequisites
    Introduction to SQL Tuning
    • SQLTXPLAIN (SQLT) Diagnostic Tool
    • Development Environments: Overview
    • SQL Tuning Session
    • SQL Tuning Strategies
    Using Application Tracing Tools
    • Using the SQL Trace Facility: Overview
    • The trcsess Utility
    • Formatting SQL Trace Files: Overview
    • Available Tracing Tools: Overview
    • Steps Needed Before Tracing
    Understanding Basic Tuning Techniques
    • Developing Efficient SQL statement
    • Index Usage
    • Data Type Mismatch
    • Table Design
    • Scripts Used in This Lesson
    • Transformed Index
    • Tune the ORDER BY Clause
    • NULL usage
    Optimizer Fundamentals
    • Why Do You Need an Optimizer?
    • Query Transformer
    • SQL Statement Processing
    • Optimizer Features and Oracle Database Releases
    • Cost-Based Optimizer
    • SQL Statement Representation
    • Components of the Optimizer
    • Adaptive Query Optimization
    Generating and Displaying Execution Plans
    • DBML_SQL_MONITOR
    • V$SQL_PLAN View
    • AUTOTRACE
    • The EXPLAIN PLAN Command
    • Plan Table
    • Execution Plan?
    • SQL Monitoring
    • Automatic Workload Repository
    Interpreting Execution Plans and Enhancements
    • Optimizer: Table and Index Access Paths
    • Full Table Scan
    • Common Observations
    • Row Source Operations
    • Indexes
    • Adaptive Optimizations
    • Main Structures and Access Paths
    • Interpreting a Serial Execution Plan
    Optimizer Join Operations
    • Join Methods
    • Join Types
    Other Optimizer Operators
    • SQL operators
    • Result Cache operators
    • Other N-Array Operations
    Introduction to Optimizer Statistics Concepts
    • Gather and Manage Optimizer Statistics: Overview
    • Optimizer Statistics
    • Types of Optimizer Statistics
    Using Bind Variables
    • Cursor Sharing and Bind Variables
    • Cursor Sharing and Different Literal Values
    SQL Plan Management
    • Maintaining SQL Performance
    • SQL Plan Management
    • expand_more chevron_right event_available 10.05.-12.05.2021 10.05.2021 Seminarzeitentimer3 Tage3 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom 2.200,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum 2.200,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 27.09.-29.09.2021 27.09.2021 Seminarzeitentimer3 Tage3 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom 2.200,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum 2.200,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services