Preview
Video Player
00:00
00:00
Introducing the Practice
2:47An overview of the Simple WHERE Clauses with SQL reports you need to generate.
[MUSIC]
0:00
Hello world Andrew here,
database user, life longer learner and
0:04
teacher here at Treehouse.
0:07
Here's another practice session for you.
0:09
Practice helps you make what
you've learned last longer.
0:13
These practice sessions help you
on your road to SQL mastery,
0:15
you'll be more confident and
a better analyst or developer.
0:19
Let's practice some basic SQL to
make sure your knowledge sticks.
0:22
This practice session covers SQL queries
with simple WHERE clauses, with comparison
0:26
operators, such as equality, and
inequality, and relational operators.
0:31
You'll also be tasked with
writing queries with ranges and
0:36
filters with sets of values.
0:39
This practice session is
intended to be a followup for
0:42
the third section of
this SQL basics course.
0:45
If you haven't taken that course yet or
0:47
if you found this practice session too
difficult, then take SQL basics first and
0:49
then take the other practice
session before this one.
0:54
In the teacher's notes I've
added a link for the course and
0:58
the other practice session.
1:01
Launch the SQL playground with this video,
this SQL playground is for
1:02
an online retailer.
1:06
There are three tables, a customers table
containing all customers of our retailer,
1:07
a products table that contains a list
of all products that are available.
1:13
And a sales table containing
all the sales entries.
1:17
Pause this video and familiarize yourself
with the tables and their contents.
1:21
There are several coding areas
here on the left hand side.
1:27
Each of the coding areas
have a particular challenge.
1:31
Challenge one is to get all
mailing information for
1:34
orders that have taken
place on the 20th of April.
1:37
Challenge two is to retrieve name and
1:40
pricing information on all
Playstation four models.
1:42
Think of three possible
ways you could do this, and
1:46
then think about which way would be best.
1:49
Challenge three is to get
the mailing address for
1:52
customers without email addresses.
1:54
This is so
we can send coupons via snail mail.
1:56
Challenge four is the opposite to
get a list of email addresses for
2:00
customers with an email address present.
2:04
Then we can email them coupons.
2:07
Challenge five is to check what products
that we have in surplus in our warehouse.
2:09
That way we can run promotions on those
products to clear some space to make way
2:13
for newer products.
2:17
Challenge six is to search for all orders
with totals between $225 and $245.
2:18
The final challenge is to find
all products with 4k support.
2:25
I've included a link to the SQL
cheat sheet in the teacher's notes.
2:29
But try to see if you can do it
without refreshing your memory
2:34
It's okay to try a couple of different
queries before you get the right query.
2:37
If you're stuck and need some
reference you can use the cheat sheet.
2:41
But try and do it without it first.
2:45