From the course: Advanced SQL: High Performance Relational Divisions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Exact relational division

Solution: Exact relational division - SQL Tutorial

From the course: Advanced SQL: High Performance Relational Divisions

Start my 1-month free trial

Solution: Exact relational division

“

- [Instructor] Let's break up the solution and begin by figuring out whether Praveena has any redundant skills, regardless of their relational division for now. I'm going to copy the two queries we used earlier, Praveena's skills on one hand, and those required for the DB Architects on the other. The relational division looked for the skills required for the role, except for the candidate skills. This time we need the opposite. We need Praveena's skills, except for the skills that are required by the role. And if this query returns anything other than an empty set, it means that Praveena has extra skills. And again, we must be careful. The fact that Praveena has extra skills doesn't mean she has the required ones. I told you earlier that an exact relational division is an ordinary relational division with an additional constraint sprinkled on top. The relational division validates that the candidate is a fit, regardless of…

Contents