Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
An overview of the Column Selection and Aliasing with SQL reports you need to generate.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
Hello world Andrew here,
database user, lifelong learner and
0:04
teacher here at Treehouse.
0:07
Here's more practice for you.
0:09
Practice helps you make what
you've learned last longer.
0:11
These practice sessions are to help
you on your road to SQL mastery.
0:14
You'll be more confident and
a better analyst or developer.
0:18
So let's practice some more basic SQL
to make sure your knowledge sticks.
0:22
This practice session
covers simple SQL queries.
0:27
From selecting all
information from a table, and
0:30
selecting and aliasing specific columns.
0:33
This practice session is
intended to follow up
0:36
after the second section
of the SQL basics course.
0:38
If you haven't taken
that course already or
0:42
find this practice session too difficult
then take the SQL Basics course first.
0:44
Check the teachers note for
a link to the course.
0:50
Launch the SQL Playground with this video.
0:53
This SQL Playground is for
an online retailer.
0:55
There are three tables, a customers table
containing all customers for our retailer.
0:58
A products table that lists
all the products available and
1:05
a sales table listing
all the sales entries.
1:09
Pause the video and
familiarize yourself with the tables.
1:13
There are several coding areas on the left
here, each with a particular challenge.
1:17
The first challenge is to
retrieve all product information.
1:23
The second challenge is to create
a mailing list for email marketing.
1:28
You'll be tasked to retrieve the first and
last names and the email address.
1:32
Third, you're going to create a list of
information containing customer names and
1:37
addresses to send to
the marketing department.
1:41
The marketing department can then
send out a physical coupon for
1:45
each of our customers.
1:48
Fourth you need to create a list of
names and addresses associated with
1:50
the orders to create mailing labels for
packages to be sent out.
1:55
Finally, imagine you're creating
a report for a colleague.
1:59
Present all relevant
information from the sales for
2:03
someone who wants to know what was sold
and how much revenue was generated.
2:06
Instead of using column names at the top
of each column, include aliases for
2:11
the sales table.
2:16
I've included a link to the SQL Basics
cheat sheet in the teacher's notes but
2:17
try to see if you can do it
without refreshing your memory.
2:21
It's okay to try a couple of different
queries before you get the right query.
2:24
If you're stuck and need reference,
use the cheat sheet.
2:28
But try to do it without
the cheat sheet first.
2:32
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up