Click here to go to the post-conference workshow information

Pre-Conference Workshops, Monday July 4th, 2016

Mastering T-SQL Querying Fundamentals



If you work with SQL Server in any capacity, as a developer, DBA, BI specialist, analyst, power user , you need to know your T-SQL. The thing is, this language is deceptive. When you start learning it you quickly get to write queries with filters, sorting, grouping, joining, and so on. You might get a false sense of confidence and the wrong impression that the language is easy to master. In reality, most get to learn T-SQL without understanding the fundamentals correctly, and this incorrect understanding can lead to using the language incorrectly. Often people assume things about the language that are not guaranteed, and end up with bugs in their code.

This seminar is dedicated to correct understanding of T-SQL querying fundamentals. You will learn about the principal elements in the foundations of the language. You will learn about logical query processing—what I find to be the most critical aspect of T-SQL that any T-SQL practitioner should master. Then the seminar covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators. If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions.

Know your T-SQL querying fundamentals well, and then tackling advanced problems will be so much easier.


Monday July 4th, 2016, 09:00 - 17:00
Location: Hotel Omni
Room: T/D
Cost: $299.00 CDN
Register Now

Note: Registration for the main conference is not required to attend Pre-Confernce.


Itzik Ben-Gan

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written articles for SQL Server Magazine, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.