Det finns inga varor i din kundvagn. Fortsätt handla på vår Kurskatalog sida.
Betala Nu -ELLER- betala Senare
Betala med kreditkort nu
-ELLER - betala mot faktura som vanligt.
This official Microsoft four-day instructor-led SQL Database Performance Tuning & Optimisation training course provides students who manage and maintain SQL Server databases with the knowledge and skills to know how to optimise and tune SQL database performance.
LIVE, LÄRARLEDD
FÖRETAGSINTERN UTBILDNING
Anpassa kurs och innehåll efter teamets behov
Kontakta ossLearning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .
21 - 24 dec
9:00 - 4:30 GMT
Online (AnyWare)
2 - 5 feb
9:00 - 4:30 EST
Online (AnyWare)
9 - 12 mar
9:00 - 4:30 EST
Online (AnyWare)
25 - 28 maj
9:00 - 4:30 EDT
New York / Online (AnyWare)
7 - 10 sep
9:00 - 4:30 EDT
Herndon, VA / Online (AnyWare)
16 - 19 nov
9:00 - 4:30 EST
New York / Online (AnyWare)
Kurs med startgaranti
När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.This module covers high level architectural overview of SQL Server and its various components. It dives deep into SQL Server execution model, waits and queues.
Lessons
Lab: SQL Server Architecture, Scheduling, and Waits
After completing this module, you will be able to:
This module covers core I/O concepts, Storage Area Networks and performance testing. It focuses on SQL Server I/O operations and how to test storage performance.
Lessons
Lab: Testing Storage Performance
After completing this module, you will be able to:
This module covers Database Structures, Data File and TempDB Internals. It focuses on architectural concepts and best practises related to data files for user databases and TempDB.
Lessons
Lab: Database Structures
After completing this module, you will be able to:
This module covers Windows and SQL Server Memory internals. It focuses on architectural concepts and best practises related to SQL Server Memory Configuration.
Lessons
Lab: SQL Server Memory
After completing this module, you will be able to:
This module covers Transactions and Locking Internals. It focuses on architectural concepts and best practises related to Concurrency, Transactions, Isolation Levels and Locking.
Lessons
Lab: Concurrency and Transactions
After completing this module, you will be able to:
This module covers Statistics and Index Internals. It focuses on architectural concepts and best practises related to Statistics and Indexes.
Lessons
Lab: Statistics and index Internals
After completing this module, you will be able to:
This module covers Query Execution and Query Plan Analysis. It focuses on architectural concepts of the Optimiser and how to identify and fix query plan issues.
Lessons
Lab: Query execution and query plan analysis
After completing this module, you will be able to:
This module covers Plan Caching and Recompilation. It focuses on architectural concepts, troubleshooting scenarios and best practises related to Plan Cache.
Lessons
Lab: Plan caching and recompilation
After completing this module, you will be able to:
This module covers Extended Events. It focuses on architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
Lessons
Lab: Extended events
After completing this module, you will be able to:
This module covers tools and techniques to monitor, trace and baseline SQL Server performance data. It focuses on data collection strategy and techniques to analyse collected data.
Lessons
Lab: Monitoring, Tracing and Baselining
After completing this module, you will be able to:
Database optimisation in SQL Server allows for performance tune so you can fix query plan issues.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.