Introduction
SQL Zoo is one of the few resources online that actually lets you build and run queries against existing tables. Each tutorial will show you a table and then have you run queries against it to answer specific questions. Some of the queries, particularly at first, are quite simple. They definitely get more challenging towards the end and can be real head scratchers.
Assignment
- Go to SQL Zoo and do Tutorials 0-9 listed under the “Tutorial Section” and the quizzes listed at the end of each. The first is the “Select” tutorial.
- Make sure the dropdown on the upper right of the main page for “Engine” says “MySQL” (the default). Large results will be cut off and not all rows or columns shown, so the “answers” may not look 100% correct.
- Before you move on, we would like your feedback - please fill this form. Getting user (you) feedback is important so we can continue to improve the curriculum and get an idea of your experience.
Additional resources
This section contains helpful links to related content. It isn’t required, so consider it supplemental.
- Explanation of SELF JOIN by Caleb Curry. He covers many other topics on his Database Design series.
- Khan Academy’s SQL Course
- OverAPI’s SQL Cheat Sheet
- GalaXQL, an interactive space-themed SQL tutorial.