Julia Evans
gumroad
Become a SELECT Star!
🕑 Added 2020-01-31 18:17:42 +0000 UTCSQL 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 and share with your friends.
What’s in the zine:
- Anatomy of a SELECT query: FROM, WHERE, SELECT, 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 (at https://sql-playground.wizardzines.com/) with all the example tables from 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.
Print directions:The "print version" is formatted so that when you print it on your printer, it will fold correctly. You'll need to:
* make sure it's set to "landscape"
* print double sided
* choose "long edge" (not "short edge").
❤ satisfaction guaranteed ❤
If you don't learn what you hoped to from this zine, just email me at wizardzines@jvns.ca within a month and I'll give you a refund.
Some people have told me that the emails from Gumroad after buying the zine end up in their spam folder, so check there if you don't see it!
You can find me on Twitter at https://twitter.com/b0rk and my email address is wizardzines@jvns.ca.
