Advanced SQL: High Performance Relational Divisions

Focused View

Ami Levin

1:36:05

0 View

01.01-course introduction.mp4

02:21

01.02-agenda.mp4

00:56

01.03-setting expectations.mp4

02:10

02.01-relational algebra.mp4

03:24

02.02-cartesian product.mp4

03:01

02.03-relational division.mp4

05:55

02.04-the hr demo database.mp4

04:39

03.01-relational division using aggregations.mp4

05:53

03.02-challenge exact relational division.mp4

00:34

03.03-solution exact relational division.mp4

04:28

04.01-relational division using set operators.mp4

04:15

04.02-challenge exact relational division.mp4

00:36

04.03-solution exact relational division.mp4

02:54

05.01-relational division using nested subqueries.mp4

08:15

05.02-challenge exact relational division.mp4

00:47

05.03-solution exact relational division.mp4

02:00

06.01-multiple divisors.mp4

10:23

06.02-zero divisions.mp4

17:18

06.03-challenge exact division.mp4

00:38

06.04-solution exact division.mp4

03:33

07.01-the pros and cons of these techniques.mp4

09:43

07.02-next steps feedback solicitation and goodbye.mp4

02:22

Ex Files Adv SQL Relational Div.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Ami Levin

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.