Advanced T-SQL

What Will You Learn?

  • Execution plan basics
  • Writing optimal queries
  • How to work with nulls, sets, advanced joins and window functions (including aggregate and analytical functions)
  • Understand and use pivot and unpivot, CTEs, temp and derived tables, XML and error handling and much more!


Advanced Querying with T-SQL is an intensive course designed specifically for SQL developers. This course has been designed using examples from real-world scenarios. In many cases, the course will demonstrate the different methods to solve a particular scenario, and then explain why one may be better than another due to performance reasons. The course has a heavy emphasis on writing optimal queries.



BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.


What to Know Before the Class

A basic understanding of T-SQL is required prior to taking this course.

Curriculum For This Course

System Requirements

  • SQL Server 2005 or greater

You may also like…