Asking the data: tables and queries with a copilot

- Welcome
Block 1: The workbench and the table
- Where what your copilot writes runs
- Tables, keys and grain
- Block 1 exam
Block 2: Asking: select, filter and aggregate
- The anatomy of a query
- Summing, counting and averaging without tripping up
- Block 2 exam
Block 3: Joining tables without duplicating rows
- The join and its varieties
- The join that inflated the promotions
- Block 3 exam
Block 4: The copilot that writes the query
- Commissioning a query and reading it
- Definitions, permissions and dangerous queries
- Block 4 exam