M3: Relational Databases and SQL

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

Pre-recorded Lectures

The pre-recorded lectures are available here. You can also find the videos under the “Panopto” tab on the CAPP 30122 canvas site.

• 3.1 - SQL in Python (You can find the code in your repositories in the modules/m3/sql_python directory)

Resources

• Lecture notes fom class (The data used in the lecture notes is available in the modules/m3 directory in your repositories.)

• 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

• SQL lab (You find distribution code in your repositories in the lab-sql directory)

Zoom Sessions

You will find the links to the Zoom sessions on Canvas.

• Week 3

  • Wednesday, January 27th: SQL

  • Friday, January 29th: SQL (Lab example and Q&A)

Programming Assignment

Programming Assignment #3, due Saturday, February 6th at 9pm CDT