Project: SQL

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.

Assignment

  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.

Ruby on Rails

Project: SQL

Got questions?

Chat with our friendly Odin community in our Gitter chatrooms!

Open Gitter

Are you interested in accelerating your web development learning experience?

Get started

Thinkful

  • 5-6 months

    5-6 months

  • Job Guarantee

    Job Guarantee

  • 1-on-1 Mentorship

    1-on-1 Mentorship