Oracle Database 11g: SQL Tuning

Ventara AG
In Erlangen, Berlin, Bremen und an 7 weiteren Standorten

1.770 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0 52 ... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

Beschreibung

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 hin..
Gerichtet an: Entwickler, Technische Berater

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Berlin
Berlin, Deutschland
auf Anfrage
Bremen
Bremen, Deutschland
auf Anfrage
Dortmund
Nordrhein-Westfalen, NRW, Deutschland
auf Anfrage
Dresden
Sachsen, Deutschland
auf Anfrage
Düsseldorf
Nordrhein-Westfalen, NRW, Deutschland
Alle ansehen (10)

Häufig gestellte Fragen

· Voraussetzungen

- "Professioneller Einstieg in Oracle Database 11g SQL" Empfohlene Vorkenntnisse: - "Oracle Database 11g: SQL Fundamentals I"

Themenkreis

Seminarziel

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.This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Learn to: - Identify Poorly Performing SQL - Understand the Query Optimizer - Trace applications - Monitor SQL execution in real time - Interpret execution plans

Zielgruppe

Entwickler, Technische Berater

Seminarinhalte

o Identify problem SQL statements o Modify a SQL statement to perform at its best o Trace an application o Understand how the Query Optimizer makes decisions about how to access data o Interpret execution plans o Use optimizer hints effectively o Generate a load test
Sachgebiete:

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

Voraussetzungen

- "Professioneller Einstieg in Oracle Database 11g SQL"
Empfohlene Vorkenntnisse:
- "Oracle Database 11g: SQL Fundamentals I"

Hinweis

Empfohlene weitere Ausbildung:-"Oracle Database 11g: Performance Tuning"

Oracle University provides a downloadable eKit containing the training materials for this course.


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen