Course details
Introduction
This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.
Course Content
- Module 1: Course Overview
- Module 2: SQL 2014 Architecture
- Module 3: The Database Engine
- Module 4: SQL Performance Tools
- Module 5: Query Optimizing and Operators
- Module 6: Understanding Indexes
- Module 7: Understanding Statistics
- Module 8: In-Memory Databases
Course Location
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 coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- AED 180Duration: 1 To 2 Months
- Developing Microsoft SQL Server 2012 Databases Global EdulinkAED 375
AED 2,596Duration: Upto 19 Hours
