Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Practice Column Selection and Aliasing with SQL!
You have completed Practice Column Selection and Aliasing with SQL!
Preview
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