Oracle Corporation Oracle Database 11g SQL Tuning E-Learning Kurs
Oracle Database 11g SQL Tuning E-Learning Kurs
€165,85
Oracle Corporation

Oracle Database 11g SQL Tuning E-Learning Kurs

EUR 165,85 exkl. MwSt.

Training Oracle Database 11g SQL Tuning - Online E-Learning training. Bestellen en direct starten voor de beste prijs.

  • E-Learning - Online-Zugang: 365 Tage
  • Englische Sprache
  • Teilnahmeurkunde
Auf Lager
Menge
- +
Produktbeschreibung

Oracle Database 11g SQL Tuning E-Learning Ausbildung

Bestel deze geweldige E-Learning Ausbildung Oracle Database 11g SQL Tuning online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, praktijkopdrachten, voortgangsbewaking door rapportages en testen per onderwerp om de kennis direct te toetsen. Na de cursus ontvangt u een certificaat van deelname.

Kursinhalt

Oracle Database 11g: Architecture, SQL Tuning, and Optimization

recognize Oracle database structures
recognize how to manage memory and database structures
identify SQL statements that cause poor performance
identify tools and tasks in SQL tuning
recognize how SQL statement execution works
recognize the basic features of the optimizer
avoid common SQL mistakes
recognize optimizer decisions in a given scenario

Oracle Database 11g: Indexes, Access Paths, and Join Operations

identify the functions of table scans in the optimizer
recognize types of indexes and how index scans work
recognize the features of index-organized tables and bitmap and composite indexes
use different acces paths
recognize how clusters and sorting operators work
recognize how joins and N-array operations work
recognize how to cache query results in the SGA

Oracle Database 11g: Execution Plans and Star Transformations

recognize how to gather execution plans
recognize how to display execution plans
recognize the views containing execution plan information
recognize how to use the AWR
recognize how to perform SQL monitoring
interpret execution plans
extract an execution plan used by the optimizer to execute a query
recognize how to use star transformation
use star transformation and access the benefits of using this optimizer technique

Oracle Database 11g: Optimizer Statistics, Hints, and Cursor Sharing

recognize how to gather optimizer statistics
recognize how to gather system statistics
use dynamic sampling
use system statistics
identify the features of bind variables
use cursor sharing
use optimizer hints
use hints and views
recognize how adaptive cursor sharing, the CURSOR_SHARING initialization parameter, and hints are used

Oracle Database 11g: Application Tracing and Automatic SQL Tuning

recognize how to configure the SQL trace facility
recognize how to use the trcsess utility
recognize how to use the tkprof utility
perform application tracing
recognize how statement profiling works
recognize how to use the SQL Tuning Advisor
recognize the features of the SQL Access Advisor
recognize the features of Automatic SQL Tuning
perform SQL tuning and use the SQL Access Advisor

Eigenschaften
Unterrichtsdauer 18 Stunde
Sprache Englisch
Online-Zugang 365 Tage
Teilnahmeurkunde Ja
Preisgekröntes Online-Training Ja
Was unsere Kunden sagen

Durchschnitt von 0 Bewertungen

Kein Bewertungen
Lesen oder schreiben Sie einen Kommentar
* Wir werden Ihre E-Mail-Adresse niemals an Dritte weitergeben.
Fragen?
Wir helfen Ihnen gerne weiter. Bieten Sie unseren Kundenservice an
Mein Konto
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Ihr Warenkorb
Ihr Warenkorb ist leer
Menu
Suchen
Search suggestions
Keine Produkte gefunden...
Wir benutzen Cookies nur für interne Zwecke um den Webshop zu verbessern. Ist das in Ordnung? Ja Nein Für weitere Informationen beachten Sie bitte unsere Datenschutzerklärung. »