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
Posted at November 20, 2013 10:30 | permanent link