A Hands-on Experience with Complex SQL
summary
Live SQL builds a daily run‑rate query that projects each day with billing totals and computes week‑over‑week and month‑over‑month growth using Postgres features: a timestamp range type, generate_series for dates, CTEs to structure steps, and window functions (lag) to compare previous periods. The workflow shows psql tips (psqlrc, backslash timing, \e for edits), handling integer casting, and producing a readable, reproducible query suitable for dashboards.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 2:19Why Postgres is more
- 3:01Live SQL demo Mandelbrot
- 3:48Setting up psql RC
- 5:17Daily run rate SQL
- 14:14Window functions growth
- 19:32Better SQL tips
related talks
47mLearning advanced SQL the weird (and hard) way
34mSimple and Awesome Database Tricks
44mPostgreSQL for Developers
46mSQL for Nerds
49mPostgreSQL, The Time-Series Database You Actually Want
31mFuturistic SQL: Making the impossible possible
31mMaking Data Dance
45mSELECT 'amazing_features' FROM "postgresql"