Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Advanced TSQL

Course Summary

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

Purpose
 Learn about advanced topics regarding TSQL.
Audience
 Developers using TSQL who want to learn advanced topics like performance and troubleshooting.
Role
Software Developer - Web Developer
Skill Level
Advanced
Style
Fast Track - Targeted Topic - Workshops
Duration
2 Days
Related Technologies
.NET | SQL

 

Productivity Objectives
  • Analyze and revise as needed missing/duplicate/unused indexes.
  • Ascertain poorly performing queries/stored procedures and improve their performance.
  • Analyze and research wait types affecting system performance and determine corrective actions.
  • Apply action when confronted with "The system is running slow".

What You'll Learn:

In the Advanced TSQL training course, you'll learn:
  • 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
  • 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)
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.