M3: Storing Data using Relational Databases

This third module provides an introduction to working with relational databases and SQL.

Pre-recorded Lectures

There are no pre-recorded lectures for module #3.

Supplementary Resources

• Lecture notes fom class (The data used in the lecture notes is available in the m3 directory in the upstream repository.)

• W3C SQL tutorial

• Very detailed slides on SQL written by Prof. Singer from Vrije University in Belgium

• Codd paper on relational databases [for historical interest]

• And finally, here’s a cool tool for playing with relational algebra, the underlying mathematical model for relational databases.

Lab

Labs provide additional practice problems for topics covered in a module. You may work on them individually or with your peers.

• SQL Lab (You find distribution code in the upstream repository in the /labs/sql directory)

Programming Assignment

No assignment for this module week. Please work on your group projects.