- Duration: 4 Days
Course details
Introduction
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
Course Content
- Module 1: SQL Server Architecture, Scheduling, and waits
- Module 2: SQL Server I/O
- Module 3: Database Structures
- Module 4: SQL Server Memory
- Module 5: Concurrency and Transactions
- Module 6: Statistics and Index Internals
- Module 7: Query Execution and Query Plan Analysis
- Module 8: Plan Caching and Recompilation
- Module 9: Extended Events
- Module 10: Monitoring, Tracing, and Baselining
- Module 11: Troubleshooting Common Performance Issues
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Access & Database Skill-UpUSD 409Duration: Upto 185 Hours
- Mobility and Device Fundamentals Practice Exam Testprep TrainingUSD 16Duration: 1 To 2 Months