Note
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.