In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of database administration and maintenance.
- Working knowledge of Transact-SQL.
After completing this course, students will be able to:
- Describe the high level architectural overview of SQL Server and its various components.
- Describe the SQL Server execution model, waits and queues.
- Describe core I/O concepts, Storage Area Networks and performance testing.
- Describe architectural concepts and best practices related to data files for user databases and TempDB.
- Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
- Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
- Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
- Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
- Explain data collection strategy and techniques to analyze collected data.
- Understand techniques to identify and diagnose bottlenecks to improve overall performance.
Read complete course description:
There is no certification related to this course.
Bli medlem i NITO
Gjør som over 86.000 andre ingeniører og teknologer. Med gode medlemsfordeler får du mer å rutte med i hverdagen.
Ordinær fagforeningskontingent er fradragsberettiget. For 2018 kan du trekke fra inntil kr. 3850,- i din skattepliktige inntekt!