Learning path

Tables, records and keys

1 small task · predict, try, explain

Choose columns

1 small task · predict, try, explain

Choose rows

1 small task · predict, try, explain

Match text and missing values

1 small task · predict, try, explain

Order and limit a result

1 small task · predict, try, explain

Defend a single-table query

3 small tasks · predict, try, explain

Whole-table aggregates

2 small tasks · predict, try, explain

Expressions and a defensible denominator

2 small tasks · predict, try, explain

Clean and reshape text

2 small tasks · predict, try, explain

Numbers and missing values

2 small tasks · predict, try, explain

Read dates and elapsed time

3 small tasks · predict, try, explain

One output row per group

1 small task · predict, try, explain

Filter rows, then filter groups

1 small task · predict, try, explain

Cardinality, optionality and bridge tables

1 small task · predict, try, explain

Turn the ERD into CREATE TABLE

2 small tasks · predict, try, explain

Review the first-midterm skills

2 small tasks · predict, try, explain

Connect matching records

2 small tasks · predict, try, explain

CASE and UNION reporting

8 small tasks · predict, try, explain

Build and change data

9 small tasks · predict, try, explain

Develop an analysis

3 small tasks · predict, try, explain