November 20, 2013

Databases (Introduction to Statistical Computing)

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

Introduction to Statistical Computing

Posted at November 20, 2013 10:30 | permanent link

Three-Toed Sloth