Master SQL Server Performance: Optimize Queries, Tune Code, and Unlock Faster Results
Preference will be given to techfrederick members. Interested in joining? Visit our membership page here.
A hands-on, in-depth course for SQL developers looking to dramatically improve query efficiency, understand execution plans, and fine-tune performance at every level.

Date: May 19th – 21st | 10am – 5pm
Location: Your Remote Workspace
Instructor(s): ProTech Training
Cost: $1800 $100, through grant funding techfrederick is able to offer this course at a reduced rate

Intermediate Level Course

Unlock the full potential of your SQL queries with this hands-on, performance-focused training. Designed for SQL developers and data professionals, this course dives deep into the strategies and techniques needed to write high-performing, efficient SQL code.

Participants will learn how to optimize queries through index management, execution plan analysis, coding best practices, and accurate statistical data. The course covers key performance-related topics such as joins, subqueries, table expressions, database design, and tuning strategies that can drastically improve the speed and efficiency of SQL Server operations.

Through a mix of instruction and interactive workshops, attendees will gain practical experience analyzing and rewriting poorly performing queries, interpreting execution plans, and applying tuning techniques in real time. By the end of the course, participants will have the tools and confidence to troubleshoot and optimize SQL queries for improved application performance and scalability.

Whether you’re looking to sharpen your SQL skills, improve your system’s performance, or better collaborate with DBAs, this course will leave you empowered and ready to take your SQL expertise to the next level.

What you’ll learn:

    • SQL Server Optimization
    • SQL Server Access Path Review/Plan Executions
    • SQL Server Tuning Strategies
    • Tuning Joins
    • Aggregate Functions, SQL Subqueries & Performance
    • Tables Expressions and Performance
    • Statistics Analysis
    • Working with the DBA

Who should take this course:

  • This course is intended for SQL developers or anyone who is interested in tuning their queries to produce the best performance possible.

Prerequisites:

  • Attendees should have knowledge of the Structured Query Language and some experience developing SQL queries.
  • Attendees should be familiar with Microsoft SQL Server and SQL Management Studio
  •  

Questions? Contact Brooke Faulkner, bfaulkner@techfrederick.org

About the Trainer

Coming soon!