Module 0 · Orientation

Episode 0 Visual Dictionary

7 min · SQL · Postgres

Title card of Episode 0: Visual Dictionary

▶ This video is coming to YouTube soon.

Every picture in Visualized Advanced Databases means one thing, in every episode. This one is the legend: pages, rows, index keys, transactions and locks, the log, plan operators, statistics, buffer frames and the four tones, plus the psql terminal where a real Postgres proves each claim.

Chapters

  1. 0:00Intro
  2. 0:14One picture language
  3. 0:35Pages, rows, frames, RAM and disk
  4. 1:23Anything pink is an index
  5. 1:55Transactions, locks and waiting
  6. 2:43The log, plans and statistics
  7. 3:28Four tones and the note bar
  8. 4:08The proof terminal
  9. 4:49Two sessions, side by side
  10. 5:30How every episode runs
  11. 6:13The whole dictionary
  12. 6:25Recap
  13. 6:48Next: The Life of a Query