Advanced SQL: Conquer Relational Division/ with Ami Levin.

Format:

Video

Author/Creator:

Levin, Ami, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Video recordings.

Physical Description:

1 online resource

polychrome

Place of Publication:

Carpenteria, CA: linkedinchescom, 2021.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Pluginches JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

This course teaches the theory of relational division and how to conquer the challenges of relational division in SQL.

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.

Participant:

Presenter: Ami Levin

Notes:

5/24/2021

Access Restriction:

Restricted for use by site license.