Edit product

    Is this your street address?

    Card

    ···· ···· ···· 4242
    Test card

    05/18

    Card

    Use a different card?

    Card

    pp paypal

    or pay with

    We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

    or pay with

    Please confirm your location:
    Your card will be charged .

    Thank you!

      Gumroad Library

      Download from the App Store or text yourself a link to the app

      $12

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

      Sorry, this item is not available in your location.
      Sold out, please go back and pick another option.

      You've purchased this product

      Give it a rating

      See it in your library

      - Quantity 1 +

      0 ratings

      Purchasing Become a SELECT Star!...

      Card

      ···· ···· ···· 4242
      Test card

      05/18

      Card

      Use a different card?

      Card

      pp paypal

      or pay with

      We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

      or pay with

      Please confirm your location:
      Your card will be charged US$12.

      Your rental will be available for 30 days. Once started, you’ll have 72 hours to watch it as much as you’d like!

      Thank you!

        Gumroad Library

        Download from the App Store or text yourself a link to the app

        Good news! Since you already have a Gumroad account, it's also been added to your library.