Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

Mastering T-SQL Querying Fundamentals by Itzik Ben-Gan

$339.00

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.

PS: This class will not be recorded. Therefore, no recordings will be available.

Date & Time:
View in your own time zone
Go to Training Class Page

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

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)

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.