English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 36m | 291 MB
In this course, Ami Levin continues his Advanced SQL series with a new installment focused on conquering relational division challenges. As Ami points out, you’ve probably encountered relational division before, even if you’re unfamiliar with the term. Ami therefore starts with a background of relational division, including how relational algebra and the Cartesian product fit in to the picture. He then dives into SQL and shows the challenging aspects of relational division and three different techniques to solve them, highlighting the pros and cons of each approach. Along the way, Amin challenges you to write your own queries before walking through the methodology he uses. By the end of this course, you will gain valuable insight into how SQL works, be able to identify relational division challenges, and know how to implement the best solutions.
Table of Contents
Introduction
1 Course introduction
2 Agenda
3 Setting expectations
1. What Is Relational Division
4 Relational algebra
5 Cartesian product
6 Relational division
7 The HR demo database
2. The Aggregation Technique
8 Relational division using aggregations
9 Challenge Exact relational division
10 Solution Exact relational division
3. The Set Operator Technique
11 Relational division using set operators
12 Challenge Exact relational division
13 Solution Exact relational division
4. The Nested Subqueries Technique
14 Relational division using nested subqueries
15 Challenge Exact relational division
16 Solution Exact relational division
5. Multiple Divisors and Zero Divisions
17 Multiple divisors
18 Zero divisions
19 Challenge Exact division
20 Solution Exact division
Conclusion
21 The pros and cons of these techniques
22 Next steps, feedback solicitation, and goodbye
Resolve the captcha to access the links!