Become a SELECT star!

SQL isn’t like most programming languages. It doesn’t run in the same order you write it! NULL acts in counterintuitive ways! What’s the difference between WHERE and HAVING again?

This zine explains SELECT queries step by step with tons of examples that will show you exactly what’s happening when you run a query. You’ll be able to easily translate your questions about your data into queries and get answers fast.

The zine is 28 pages and you’ll get a PDF that you can either read online or print out.

What's in the zine:

  • Anatomy of a query: SELECT, FROM, WHERE, GROUP BY, HAVING, JOINs, ORDER BY, LIMIT
  • how window functions work
  • how to handle NULLs
  • CASE, counting, and subqueries
  • how indexes work

★★a SQL playground★★

When learning any new computer thing, it’s really important to be able to try things out and experiment! So this zine also comes with an interactive SQL playground with all the examples tables in the zine! You can answer all of your “hey, what would happen if I did X instead of Y in that example?” questions right away.

Here are a couple of sample pages:


© Julia Evans 2018 | All rights reserved