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