T-SQL & PERFORMANCE TUNING COURSES

Are you a developer ready to learn how to build effective TSQL Queries? Do you have performance issues? Then these are the right courses for you.

T-SQL Courses

Welcome to the wonderful world of the TSQL language. Where should you begin?

If you are familiar with basic relational database concepts and SQL, and will like to learn the fundamentals of TSQL, then we recommend you take the TSQL Fundamentals course. This is the first step into becoming a TSQL Pro.

If you have at least one year of T-SQL querying and programming experience in SQL Server, and you are ready to take the next step, then the Advanced TSQL Course is the appropriate course for you.

Both of our courses are authored by Itzik Ben Gan, mentor and one of the founders of SolidQ, author of award winning books about T-SQL, a columnist in SQL Server Pro magazine, a Microsoft Data Platform MVP since 1999, and a regular speaker in SQL Server related events.

T-SQL Fundamentals

Learn T-SQL 2016 the right way in this 5-day course. Understand the logic behind the language and know not only the how but also the why. This course is an updated version of the TSQL Fundamentals 2012 course.

Advanced T-SQL Querying, Programming and Tuning For SQL Server

Master your T-SQL Querying, Query Tuning and Programming skills in this 5-day (or 3-day) course. Create highly efficient solutions to your common business tasks.

Performance Tuning Courses

We have put together a seminar that will not only allow you to optimise the overall performance of your Data Server, but also teach you how to anticipate potential problems and mitigate their effects; after all we need to work within the constraints as dictated by the business strategy.

Designed for SQL Server administrators who are responsible for monitoring, troubleshooting and optimizing database servers and installations, and SQL Server developers who are responsible for developing efficient SQL Server queries and stored procedures.

SQL Server Performance Tuning and Troubleshooting

Learn in this 5-day course the internal architecture of SQL Server and the typical environments it operates in. Diagnose problems and optimize the performance of your SQL Server environment. SQL Server 2017 already incuded!