This 32 hours course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Audience(s): | IT Professionals |
Technology: | SQL Server |
Duration: | 32 hours |
Module 1: SQL Server Architecture, Scheduling, and Waiting
Module 2: SQL Server I / O
Module 3: Database Structures
Module 4: SQL Server Memory
Module 5: SQL Server Concurrency
Module 6: Statistics and Internal Indexes
Module 7: Executing Queries and Analyzing the Query Plan
Module 8: Planning for Caching and Recompilation
Module 9: Extended Events
Module 10: Monitoring, Tracing and Establishing Bases
Session 1 | Session 2 | |||
Start Date: | Start Date: | |||
End Date: | End Date: | |||
Day(s): | Day(s): | |||
Hours: | Hours: |