This official Microsoft MOC On-Demand learning course enables you to learn whenever, and wherever, is convenient for you. All learning is available 24/7, accessed securely via a single user sign-on through a Microsoft hosted web portal. The content is recorded and delivered by engaging Microsoft experts.
This official Microsoft On-Demand course provides you with:
- Access to the official Microsoft MOC On-Demand Course for 90 days, allowing you to start and stop when you need to.
- Access to Microsoft Labs-on-line for 90 days allowing you to gain hands-on experience with the environment.
- Knowledge checks: immediate feedback tells learners if they've mastered the content.
- Digital edition of the Microsoft Official Curriculum (MOC) manual for reference both during and after your course.
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.
The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Please note: Although this course is within the Microsoft SQL Server 2016 curriculum it is applicable to version 2012 and 2014 as well. Some features are from the later version but the tools and techniques for performance tuning and optimising a SQL Server database and queries are the same for all the versions