The Advanced Programming and Query Tuning in SQL Server course takes programming and query tuning in SQL Server from the basic level to the advanced, providing students with tools and techniques that will allow them to write code for a broad range of requirements while optimizing performance, and on the other hand, optimize performance of existing SQL Server queries and processes. Throughout the course, the students will analyze different case studies while comparing several approaches for each one and choosing the best solutions.
The course is based on SQL Server 2014, but it is relevant also for previous versions of SQL Server (2005/2008/2008R2/2012/2016).
The course is intended for SQL Server DBA’s and developers who are responsible for either writing Transact-SQL queries or tuning already written Transact-SQL queries. Students should be familiar with basic programming and with the syntax of Transact-SQL.
Download here – Advanced Programming and Query Tuning in SQL Server Course Syllabus