RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



Oracle SQL Tuning for Developers Workshop (D73549GC10)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D73549GC10

Dla kogo

  • Data Warehouse Developer
  • Database Designers
  • Developer
  • PL/SQL Developer

Czas trwania

3 dni

Cena bazowa

PLN 4470

Cel

  • Choose an appropriate SQL tuning approach
  • Gather and interpret session statistics using the SQL trace facility
  • Identify the SQL statements that perform poorly
  • Use tuning techniques to tune inefficient SQL statements
  • Interpret Execution Plans
  • Describe the Oracle optimizer fundamentals
  • Manage SQL performance through changes

Opis

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.Learn To:Interpret execution plans and the different ways in which data can be accessed.Decipher, decide and then apply tuning to SQL code. Use various tuning techniques.Take advantage of bind variables, trace files and use the different types of indexes.Use different access paths for better optimization.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.Understand Basic Tuning TechniquesExpert instructors will also teach you how to rewrite queries for better performance. Furthermore, you'll learn how to utilize SQL Tuning Advisor using SQL Developer 3.0.

Tematy

  1. Introduction
  2. Introduction to SQL Tuning
    • Find a workaround to enhance performance
    • Analyze a poorly written SQL statement
    • Create a function based index
    • Redesign a simple table
    • Rewrite the SQL statement
  3. Using SQL Trace Facility and TKPROF
    • Explore a trace file to understand the optimizer’s decisions
  4. Understand Basic Tuning Techniques
    • Rewrite queries for better performance
    • Rewrite applications for better performance
    • Utilize SQL Tuning Advisor using SQL Developer 3.0
  5. Optomizer Fundamentals
    • Explore a trace file to understand the optimizer’s decisions
  6. Understanding Serial Execution Plans
    • Use different techniques to extract execution plans
    • Use SQL monitoring
  7. Optimizer: Table and Index Access Paths
    • Learn about using different access paths for better optimization
  8. Optimizer: Join Operations
    • Use different access paths for better optimization
    • Examine and use the result cache
  9. Other Optimizer Methods
    • Use different access paths for better optimization
    • Examine and use the result cache
  10. Optimizer Statistics
    • Analyze and use system statistics
    • Use automatic statistics gathering
  11. Using Bind Variables
    • Use adaptive cursor sharing and bind peeking
    • Use the CURSOR_SHARING initialization parameter
  12. SQL Plan Management
    • Use SQL Plan Management

Wymagania

    D73549GC10 Poland Oracle SQL Tuning for Developers Workshop 3 Days PLN 4470
  1. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.Learn To:Interpret execution plans and the different ways in which data can be accessed.Decipher, decide and then apply tuning to SQL code. Use various tuning techniques.Take advantage of bind variables, trace files and use the different types of indexes.Use different access paths for better optimization.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.Understand Basic Tuning TechniquesExpert instructors will also teach you how to rewrite queries for better performance. Furthermore, you'll learn how to utilize SQL Tuning Advisor using SQL Developer 3.0.
  2. Data Warehouse Developer Database Designers Developer PL/SQL Developer Choose an appropriate SQL tuning approach Gather and interpret session statistics using the SQL trace facility Identify the SQL statements that perform poorly Use tuning techniques to tune inefficient SQL statements Interpret Execution Plans Describe the Oracle optimizer fundamentals Manage SQL performance through changes Introduction Introduction to SQL Tuning Find a workaround to enhance performance Analyze a poorly written SQL statement Create a function based index Redesign a simple table Rewrite the SQL statement Using SQL Trace Facility and TKPROF Explore a trace file to understand the optimizer’s decisions Understand Basic Tuning Techniques Rewrite queries for better performance Rewrite applications for better performance Utilize SQL Tuning Advisor using SQL Developer 3.0 Optomizer Fundamentals Explore a trace file to understand the optimizer’s decisions Understanding Serial Execution Plans Use different techniques to extract execution plans Use SQL monitoring Optimizer: Table and Index Access Paths Learn about using different access paths for better optimization Optimizer: Join Operations Use different access paths for better optimization Examine and use the result cache Other Optimizer Methods Use different access paths for better optimization Examine and use the result cache Optimizer Statistics Analyze and use system statistics Use automatic statistics gathering Using Bind Variables Use adaptive cursor sharing and bind peeking Use the CURSOR_SHARING initialization parameter SQL Plan Management Use SQL Plan Management Oracle Database: SQL Tuning for Developers D79995GC10 Oracle SQL Tuning for Developers Workshop D73551GC10 Live Virtual Course

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.