Week 12: Databases, SQL/MySQL, and interacting with databases from R



How to setup a MySQL account at Purdue

We give instructions for setting up a MySQL account:
instructions for setting up MySQL

First example session for MySQL

A first set of queries to try in MySQL:
first example set of queries in MySQL

Second example session for MySQL

A second set of queries to try in MySQL:
second example set of queries in MySQL

MySQL examples from the book

A set of examples from the Learning SQL book:
book examples

How to call MySQL from R

A set of examples about how to make MySQL queries and import the results into R directly:
RMySQLnotes