Project: SQL Zoo
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.
- 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.
If you’ve been keeping track of the SQL Zoo solutions, put them here! submit a link to your solutions below by using a pull request. See the section on Contributing for how.
Show Student Solutions
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.