Assignment Introduction: Creating a schema

Wrapping up SQL

• Transactions & MySQL Dump files
• Full circle: query local db from R

Data manipulation in R

• dplyr
  • filter
  • select
  • arrange
  • mutate
  • summarise
  • pipes & syntax
• data.table