Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.

Prerequisites

• Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
• Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
• Basic understanding of structure and usage of SQL Server indexes
• Basic understanding of relational database concepts