Scroll up or hover over the breadcrumbs to view the navigation bar

SQL

Don't forget to use Git to save your projects!

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.

Your Task

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

Student Solutions

If you've been keeping track of the SQL Zoo solutions, put them here! Some that we found online are provided in the "Additional Resources" section below but are incomplete. Submit a link to your solutions below by using a pull request. See the section on Contributing for how.

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

From the creators of The Odin Project...

The Viking Code School
Viking ad 180x150