Databases (Introduction to Statistical Computing)
Three-Toed Sloth 2014-01-06
Summary:
Lecture 25: The idea of a relational database. Tables, fields, keys, normalization. Server-client model. Example of working with a database server. Intro to SQL, especially SELECT. Aggregation in databases is like split/apply/combine. Joining tables: what it is and how to do it. Examples of joinery. Accessing databases from R with the DBI package.
Example database file (30MB): baseball.db
Readings: Spector, chapter 3