Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Start a free Courses trial
to watch this video
Introducing the SQL commands that allow us to perform relatively complex set operations on a database.
As with the other topics we’ve covered in this series, there is a wealth of information available on the topic of sets, databases, and SQL.
We'll get into the following topics in this stage, but here are a few links that talk a little more about Set Operations in SQL:
- What is the difference between a JOIN and a UNION?
- Learn to use UNION, INTERSECT, and EXCEPT Clauses
Other good reads about Set Operations include:
Union and Union All:
SQL UNION Operator
SQL - UNIONS Clause
Intersect:
SQL - INTERSECT Clause
SQL Server: INTERSECT Operator
Except:
You need to sign up for Treehouse in order to download course files.
Sign up