Six weeks as a Data PM

One-minute lessons. Real labs. Meridian's data has problems planted in it.

Chapter 1 of 8 · Level 0 · The basics

SQL & Python 101

The formulas every lab uses. Start here if SELECT or a DataFrame is new to you.

Basics
  1. 1

    SELECT, FROM, WHERE

  2. 2

    Filters: AND, OR, IN, NULL

  3. 3

    Sort, limit, count, sum

  4. 4

    GROUP BY and HAVING

  5. 5

    JOINs

  6. 6

    Python: variables, lists, dicts

  7. 7

    pandas: columns and rows

  8. 8

    pandas: groupby, sort, merge

  9. Lab

1 / 8