Oracle Datenbank 11g: SQL Tuning Workshop
Kurs
In Köln, Dortmund und Essen
Beschreibung
-
Kursart
Workshop
-
Ort
-
Dauer
3 Tage
The SQL Tuning Workshop class 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, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking.. Gerichtet an: Besuch des Trainings: Professioneller Einstieg in Oracle Database 11g SQL. Zusätzlich wird der Besuch des Trainings Oracle Database 11g: SQL Fundamentals I empfohlen.
Standorte und Zeitplan
Lage
Beginn
Beginn
Beginn
Beginn
Beginn
Meinungen
Themen
- Datenbank
- SQL
Inhalte
The SQL Tuning Workshop class 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, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.
Learn to:
-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
VORRAUSSETZUNG
Besuch des Trainings: Professioneller Einstieg in Oracle Database 11g SQL.
Zusätzlich wird der Besuch des Trainings Oracle Database 11g: SQL Fundamentals I empfohlen.
KURSINHALT
Exploring the Oracle Database Architecture
Introduction to SQL Tuning
Introduction to the Optimizer
Optimizer Operators
Interpreting Execution Plans
Case Study: Star Transformation
Optimizer Statistics
Using Bind Variables
Using Optimizer Hints
Application Tracing
Automating SQL Tuning
Oracle Datenbank 11g: SQL Tuning Workshop