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:
- Open another window to Mode. Sign up for an account if you don't have one.
- For each lesson, start by running
SELECT *on the relevant dataset so you get a sense of what the raw data looks like. Do this in that window you just opened to Mode.
- Run all of the code blocks in the lesson in Mode in the other window. 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.
SQL Data Types