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 SQL Basics!
You have completed SQL Basics!
Preview
In this video, we'll review some of the concepts that we've covered in this stage and cover what you'll need to do to succeed in your practice session.
See all of the SQL used in SQL Basics in the SQL Basics Cheat Sheet.
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
limit the columns of
information we want back.
0:00
We've also used the AS keyword
to alias column names.
0:02
These are all important tools
that you can use to retrieve
0:06
results from a database to show
to users and generate reports.
0:09
Here's something you might not know.
0:14
You see all these keywords select,
as, and from?
0:15
They can be all used in lowercase.
0:19
Running this query has the same results,
but people use
0:22
uppercase keywords to help you distinguish
the different parts of the query.
0:26
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