> > > D73549

Oracle SQL Tuning for Developers Workshop (D73549)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

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 You

Ensure 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 Techniques

Expert 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.

Zielgruppe

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

Kursziele

  • 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

Kursinhalt

  • Introduction to SQL Tuning
  • Using SQL Trace Facility and TKPROF
  • Understand Basic Tuning Techniques
  • Optomizer Fundamentals
  • Understanding Serial Execution Plans
  • Optimizer: Table and Index Access Paths
  • Optimizer: Join Operations
  • Other Optimizer Methods
  • Optimizer Statistics
  • Using Bind Variables
  • SQL Plan Management
Classroom Training
Modality: G

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.010,- €
  • Schweiz: Fr. 2.484,-
Termine und Buchen
Online Training
Modality: U

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.893,- €
Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klicken Kurstermine
Deutschland
17.06. - 19.06.2019 München
 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.