Project: SQL Zoo

SQL Zoo will show you a table and have you run queries against it to answer specific questions. The queries start off simple and then gradually get harder as you go.

Overview

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.

Additional resources

This section contains helpful links to other content. It isn't required, so consider it supplemental for if you need to dive deeper into something.

• 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.