Oracle Database 11g SQL Tuning Training





Oracle Database 11g SQL Tuning Training
Training Oracle Database 11g SQL Tuning - Online E-Learning training. Bestellen en direct starten voor de beste prijs.
Lees meer- Merk:
- Oracle Corporation
- Kortingen:
-
- Koop 2 voor €155,82 per stuk en bespaar 2%
- Koop 3 voor €154,23 per stuk en bespaar 3%
- Koop 4 voor €152,64 per stuk en bespaar 4%
- Koop 5 voor €151,05 per stuk en bespaar 5%
- Koop 10 voor €143,10 per stuk en bespaar 10%
- Koop 25 voor €135,15 per stuk en bespaar 15%
- Koop 50 voor €127,20 per stuk en bespaar 20%
- Beschikbaarheid:
- Op voorraad
- Levertijd:
- Bestel voor 16:00 uur en start vandaag.
- Award Winning E-learning
- De laagste prijs garantie
- Persoonlijke service van ons deskundige team
- Betaal veilig online of op factuur
- Bestel en start binnen 24 uur
Oracle Database 11g SQL Tuning E-Learning Training
Bestel deze geweldige E-Learning Training 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.
Cursusinhoud
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
Duur | 18 uur |
---|---|
Taal | Engels |
Certificaat van deelname | Ja |
Online toegang | 365 dagen |
Voortgangsbewaking | Ja |
Award Winning E-learning | Ja |
Geschikt voor mobiel | Ja |
Er zijn nog geen reviews geschreven over dit product.
Beoordelingen
Er zijn nog geen reviews geschreven over dit product.
Microsoft Office SCORM e-Learning
Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.