Seminar Details

Oracle Database: SQL Tuning for Developers (D99667)

ETC
D99667
Hersteller-ID:
Prüfungs ID:
Dauer: 3 Tage
Preis: € 2.133.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details
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
Alle Details einblenden

Zielgruppe

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

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
 

Schwerpunkte

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
Alle Details ausblenden

1 Termin wählen

Was ist:
ILT

Ihr Klassenraumtraining - mehr Infos zu Instructor Led Trainings bei ETC erhalten Sie HIER

vILT

Mehr Infos zu vILT erhalten Sie hier

Live

Ihr virtuelles Training - mehr Infos zu ETC>Live erhalten Sie HIER

Hybrid VBT

Mehr Infos zu VBTs erhalten Sie HIER

Hybrid MOOC

Mehr Infos zu MOOCs erhalten Sie HIER

Coached Learning

Mehr Infos zu Coached Learning erhalten Sie HIER

Hotseat

Mehr Infos zum ETC Hotseat erhalten Sie HIER

Info

zusätzliche Infos zum Seminartermin

Alle Preise exkl. Mwst.

2 Paket wählen

Oracle Database: SQL Tuning for Developers

Preis

  • Ihr ILT Seminar (Instructor Led Training)
  • Seminarunterlagen, Teamwork, Labs
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.133.-
(€ 2.133.- p.P.)

Könnte sie auch interessieren

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

Bisher keine Bewertungen