Intro to SQL for Data Science

Selecting Columns

1. Selecting Single Columns
2. Selecting Multiple Columns
3. Select DISTINCT
4. Learning to COUNT

Filtering Rows

1. Filtering results
2. Simple filtering of numeric values
3. Simple filtering of text
4. WHERE AND
5. WHERE OR
6. WHERE AND OR
7. BETWEEN
8. WHERE IN
9. NULL and IS NULL
10. Like and NOT LIKE

Aggregate Functions

1. Aggregate function
2. Combining aggregate functions with WHERE
3. A note on arithmetic
4. It's AS simple AS aliasing
5. Even more aliasing

Sorting, Grouping and Joins

1. ORDER BY
2. Sorting single columns
3. Sorting single columns (DESC)
4. Sorting multiple columns
5. GROUP BY
6. HAVING