- Configure MySQL Workbench
- Discussion: why (or why not) SQL?
- Configure local MAMP database - your own data server!
- Import the Bee Lab database to your local MySQL
- SQL queries revisited
- Exercise 1: join & aggregate
- Datatypes and table structure in MySQL
- Views, Constraints, and Indexes
- Creating a table from CSV
- Transactions & MySQL Dump files
- Full circle: query local db from R
