SQL Query Performance Testing and Tuning

In this one day webinar we will explore ways to monitor and test the performance of your SQL Server queries and ways to improve query performance. We will start with how SQL Server stores and processes data. We will then look at SQL monitoring tools and exploring SQL’s Execution Plans. We will then look at ways to improve query performance by restructuring queries, the use of indexes and by managing locks. We will wrap up by exploring in-memory table options.

• Completion of a MAX coding bootcamp or equivalent knowledge is required:
  • SQL Syntax
  • Tables, Columns, Data Types, Nullability
  • Boolean Login & Expressions
• Software Requirements (must have installed prior to class):
  • Windows
  • SQL Server Management Studio (preferred)
  • or Visual Studio
  • Visual Studio Code (with an extension)