DPS 2020 Training Class – Mastering T-SQL Querying – by Itzik Ben-Gan

Pre-Con Title

Mastering T-SQL Querying Fundamentals

Track(s)

Database Development

Tags

#TSQL #Querying #QueryProcessing #QueryTuning #T-SQL

Level

Advanced

Trainer/Speaker

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/Topics

• 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)

Attendee Pre-requisite (if any)

Basic experience writing T-SQL queries

Is this class being recorded?

No, this class will not be recorded. Therefore, no recordings will be available.

Additional Comments from Instructor/Speaker

No special instructions/comments from the Speaker

Additional Comments from the Organizers

DPS 2020 Pre-Con price increases on the 1st of every month. This month’s pricing is the lowest. Book Now and save.

Pre-Con Trainings are instructor-led, demo-based, 8 hours (4 hrs each day).

Due virtual mode delivery, Pre-Cons are not hands-on. The 8-hour delivery is designed for maximum coverage and demos by the instructor. However, delegates will get the pre-con material (PDFs, demos, scripts, etc, as shared by instructor) to practice at their convenience.

More Questions?

Visit FAQ page.

BooK Now

Book Now