Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Start a free Courses trial
to watch this video
In this video you'll learn how to write your first SQL query: retrieving all information from one table.
Definitions
Syntax The vocabulary and grammatical rules surrounding the structure of your code.
Keywords The vocabulary words of a programming language used to issue commands to a computer.
SQL Used
SELECT * FROM <table name>;
The asterisk or star symbol (*
) means all columns.
The semi-colon (;
) terminates the statement like a period in sentence or question mark in a question.
Examples:
SELECT * FROM books;
SELECT * FROM products;
SELECT * FROM users;
SELECT * FROM countries;
See all of the SQL used in SQL Basics in the SQL Basics Cheat Sheet.
You need to sign up for Treehouse in order to download course files.
Sign up