Advanced TSQL

The Advanced TSQL training course will concentrate what is needed to be able to improve query and stored procedure performance. It will cover the spectrum of being able to identify and fix poorly performing queries, missing indexes, unused indexes, poor query design and implementation, and a basic understanding of wait types and their impact on query performance.

Course Summary

Purpose: 
Learn Advanced Topics around TSQL.
Audience: 
Developers using TSQL who want to learn advanced topics like performance and troubleshooting.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
Duration: 
2 Days
Productivity Objectives: 
  • Be able to analyze and revise as needed missing/duplicate/unused indexes
  • Ascertain poorly performing queries/stored procedures and improve their performance
  • Be able to analyze and research wait types affecting system performance and determine corrective actions
  • Be able to take action when confronted with “The system is running slow”

What You'll Learn

In the Advanced TSQL training course you’ll learn:
Day 1:

  • Basic review of TSQL to include table JOINs, subqueries, windows functions, views, temporary tables, stored procedures, functions
  • Complete review of indexes including identification and implementation of covering indexes and index implementation
  • Table JOINs and subqueries and their effect on performance
    Day 2:
  • In-memory tables (when and how to implement and their effect on performance)
  • Wait Types: How to analyze and improve performance
  • Strategies for writing effective performing stored procedures and queries
  • Techniques for performance enhancing TSQL
  • Performance tools, sample performance tuning (demos)

Contact us to learn more

Not all training courses are created equal. Let the customization process begin! We'll work with you to design a custom Advanced TSQL training course that meets your specific needs.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients
Need help finding the right learning solution?   Call us: 877-629-5631