Deep-dive into querying data with TSQL

This full day training session deep dives into querying data with TSQL from scratch. It starts off with a brief explanation of what an RDBMS is and why normalisation is required to address common data anomalies vis-a-vis DML operations. Then it looks into basic components of an SQL statement, logical order of processing, aliases, sorting data, filtering using predicates, and quickly goes into covering more advanced topics such as views, offset fetch, case expression, set operations, nested subqueries, correlated sub queries, windowing functions, common table expressions, pivots, and grouping sets.