[fsckboy]

i've often marvelled that hardly anybody on the MIT CS faculty has ever considered RDBMS / SQL / Codd-Date / relational model worthy of pedagogical consideration. you might cover some crud when surveying semaphores and mutexes, but actually learn SQL? nope.

[ternus]

Are you sure? I took 6.814 Database Systems back when Stonebraker taught it, and it's still being taught as 6.5830. The first problem set was a nontrivial crash course in SQL, using SQLite. Current/modern version: http://db.lcs.mit.edu/6.5830/assignments/pset1/pset1.pdf

Example problem:

> Find every Orange Line station in Fall 2018 that, during time period 01 and the direction of 0, had a total ons passenger count greater than average for all Orange Line stations during that same time period, same season, and in the same direction. Report the station name and the total ons value. Sort the results by total ons in descending order and then station name in ascending order. Display the output like ‘Malden Center|21400’.