Duration: Full Day
If you work with SQL Server in any capacity, as a developer, DBA, BI specialist, data scientist, 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, many people get to learn T-SQL without a good understanding the fundamentals, and this often leads 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 logical query processing—probably the most critical aspect of T-SQL that any T-SQL practitioner should master. It explains how queries are interpreted, and how to write T-SQL code with the correct mindset. The seminar also covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators. With each of the topics there’s also a section covering several trickier aspects that are beyond the fundamentals.
The seminar also covers some of the newest additions to T-SQL in SQL Server 2016 and 2017 like DROP IF EXISTS, CREATE OR ALTER, CMINE, TRIM, STRING_SPLIT, STRING_AGG, DATEDIFF_BIG, AT TIME ZONE, temporal tables and SQL Graph. 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 challenges will be so much easier.