Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

$299.00

Use 50% Discount Code: DPS50 (Now: US$ 339. After Discount: US$ 169.5)

Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

Abstract: 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.

Discount Code:
Get your 50% Discount Code – Click Here

Out of stock

Description

Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

Abstract: 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.

Modules:
Logical Query Processing
Joins
Subqueries
Table Expressions
Set Operators
Recent T-SQL Additions
Beyond the Fundamentals (window functions, pivoting, unpivoting, grouping sets, as time permits)