Your First SQL Statement4:01 with Andrew Chalkley
In this video you'll learn how to write your first SQL query: retrieving all information from one table.
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.
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.
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