Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic 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:
-
0:00
[MUSIC]
-
0:04
In our last stage,
-
0:05
we learned how to merge dates together from two different tables with SQL Joins.
-
0:10
In this stage, we're going to learn about set operations.
-
0:15
Set operations allow you to perform different tasks on separate tables or
-
0:19
datasets.
-
0:20
You can use these operations to combine two or
-
0:23
more datasets into one in various ways or to limit the results of one with another.
-
0:29
There are four set operations, Union, Union All, Intersect and Except.
-
0:36
Union and Union All combine data from multiple tables into one result set.
-
0:41
Intersect produces a result set from values of rows that's are in common
-
0:46
between both tables.
-
0:47
And except produces a result set of values of rows that exist in the first table,
-
0:53
but not the second.
-
0:55
Will be taking a look at these set operations in more detail in this stage.
You need to sign up for Treehouse in order to download course files.
Sign up