Advanced SQL: Logical Query Processing, Part 2

Advanced SQL: Logical Query Processing, Part 2
Advanced SQL: Logical Query Processing, Part 2
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 02m | 412 MB

Without an understanding of the underlying concepts behind SQL, developers will encounter a number of challenges that slow down their workflow. This course—the second installment in a series—was designed to help you avoid these common pitfalls and understand SQL’s processing limitations. Join instructor Ami Levin as he continues to delve into logical query processing. Learn how expression, table, and row subqueries are processed. Discover self joins, their unique requirements, and when you might use them. Plus, learn how to use lateral joins, recursive WITH clauses, and more.

Table of Contents

1 Course introduction
2 Agenda
3 Setting expectations
4 Subqueries
5 Set operators
6 Challenge
7 Solution
8 Self and inequality joins
9 Lateral joins
10 Challenge
11 Solution
12 Ordered set functions
13 Grouping sets
14 Challenge
15 Solution
16 Recursions
17 The cursors curse
18 Conclusion