Leveling up

Welcome to the Advanced SQL Tutorial! If you skipped the beginning tutorials, you should take a quick peek at this page to get an idea of how to get the most out of this tutorial. For convenience, here's the gist:

  • For each lesson, start by running SELECT * on the relevant dataset so you get a sense of what the raw data looks like.

  • You'll learn more if you really examine the results and understand what the code is doing.

For this lesson, we'll use the same Crunchbase data from a previous lesson. It was collected on Feb 15, 2014, and large portions of the data were dropped for the sake of this tutorial. In this example, we'll also use a modified version of this data with date formats cleaned up to work better with SQL.