Practice Your SQL Queries
Welcome to Hands-On SQL, where you can play around with the tables in Head First SQL.
This site is divided into two sections: SELECT-only queries and Read/Write queries. Check out this page for an explanation of how they work.
Try it!
You can run SELECT-only queries against the tables from Head First SQL here. Just enter your queries in the box and hit the button; your results will display below!
Tables include:
boys
car_table
clown_info
cookie_sales
doughnut_ratings
drink_info
easy_drinks
fish_info
fish_records
girls
hooptie
movie_table
my_contacts
one
projekts
store_info
store_inventory
toy_ids
toy_info
toy_other
toys
your_table
Get Started
Start at the beginning with Page 1, or jump to a particular lesson:
- Page 1: DESC and INSERT
- Page 2: SELECT
- Page 3: Escaping Quotes
- Page 4: SELECT specific data
- Page 5: More practice with SELECT
- Page 6: Operators
- Page 7: AND and OR
- Page 8: IS NULL
- Page 9: LIKE
- Page 10: BETWEEN
- Page 11: IN or NOT
- Page 12: Comparison Operator Practice
- Page 13: DELETE
- Page 14: BE the DELETE
- Page 15: UPDATE
- Page 16: More UPDATE
- Page 17: Smart Table Design
- Page 18: ALTER
- Page 19: More ALTER
- Page 20: More ALTER
- Page 21: More ALTER
- Page 22: String Functions
- Page 23: UPDATE/SET
- Page 24: UPDATE/SET/CASE
- Page 25: ORDER BY
- Page 26: More ORDER BY, with SUM and GROUP BY
- Page 27: MIN/MAX, COUNT, and DISTINCT
- Page 28: LIMIT
- Page 29: Database Design
- Page 30: More Database Design
- Page 31: Normalize your table
- Page 32: Inner Joins
- Page 33: Outer Joins
Have questions about this site? Send them to the webmaster.
This interface was written by Andrew Cumming, author of SQL Hacks. For more SQL practice, check out his SQLzoo.net site.