Main benefits

  • Understand Logical Query Processing and its relevance to writing correct and robust T-SQL code.
  • Write queries against a single table applying filtering, grouping and sorting of data.
  • Write queries against multiple tables using joins, subqueries, APPLY and set-operators.

Is it for you?

  • If you are self-taught, and gained your knowledge “by the seat of your pants”, or you have familiarity with basic relational database concepts and SQL, but you do not feel comfortable with T-SQL yet..
  • If you want to learn with Itzik about his methodology using his demo code samples.
  • If you need a strong foundation in this field and you want to learn from wherever you want, whenever you want, watching the lessons as many times as you need.

Course Content

Modules Status
1

M01 Intro and Agenda

2

M02 Single Table Queries

3

M03 Joins

4

M04 Subqueries

5

M05 Table Expressions

6

M06 Set Operators

7

M07 Beyond the fundamentals of Querying