The standard itself

  • The SQL standard is a purchasable document that costs a lot of money. Companies building databases buy it for their engineers; there are also (offline-discussed) free routes (1:15:30).

The closing argument

  • Claim stated flatly: SQL is the most important programming language right now — "it was here before you were born, it will be here after you die" (1:15:30).
  • Evidence cited: an IEEE survey (2023) asking programmers which language matters most — SQL is always at the top (1:16:00).
  • Contrast with the CMU CS department's own talent-day poll, where SQL never ranks; the lecturer's opinion is that SQL is "way more important than Standard ML or OCaml" (1:16:00).

The unifying purpose of everything shown

All the "modern SQL" tricks share one goal: do as much computation as possible inside a single SQL query, instead of round-tripping between application code / terminal and the database server (1:16:27).

Homework 1

  • Released the day of the lecture (0:40, 1:16:27).
  • Implement roughly five SQL queries in both SQLite and DuckDB (1:16:27).
  • The syntax will be mostly but not exactly the same between the two — you are expected to adapt, not copy verbatim (1:17:25).
  • Recommendation: start with DuckDB, then port to SQLite (1:17:25).
  • Set up as a teaser: one of the two will be markedly faster. DuckDB will be much faster than SQLite for these queries, and why is what the rest of the semester explains (1:16:55).

What comes next

  • The following class begins the internals of a database system — and "we're not talking about SQL ever again" (1:16:55, 1:17:25).