CS Degree Day 83

Overview

Databases. Of all the subjects in this curriculum, databases are the one most directly applicable to my work. I use SQL regularly. I have set up Postgres instances. I have written migrations. I have caused slow queries. Now I intend to understand what I have been doing.

What I did today?

6.5831 Database Systems:

• Lecture 1: Relational model - tables, rows, schemas
• Lecture 2: SQL - SELECT, WHERE, JOINs, aggregates
• Lecture 3: Relational algebra - σ, π, ⨝

SQL I know. Relational algebra I did not.