Training Class:- MASTERING T-SQL QUERYING FUNDAMENTALS
Does your work involve interacting with Microsoft SQL Server or Azure SQL Database? If so, writing T-SQL code is probably an integral part of your work. As a developer, DBA, analyst, BI pro, data scientist, or power user, a strong mastery of T-SQL querying and its foundations makes you better at what you do. This full-day seminar provides you with such strong foundations.
You will learn about interesting, nonobvious, aspects of T-SQL querying tools like joins, subqueries, table expressions, recursive queries, APPLY, set operators and many others. You will learn about logical query processing, which defines the conceptual interpretation of queries, unveiling many surprising things about T-SQL. You will also learn about common bugs, pitfalls, and best practices. As time permits, the seminar will also cover some of the more sophisticated querying tools like pivoting and unpivoting, window functions and grouping sets.
This seminar will help you write correct and robust T-SQL code, avoid bugs, follow best practices, think in set-based/relational terms, and get a better mastery of T-SQL querying.