JOIN "My Session" ON Modern = 'SQL'
summary
Shows concrete SQL patterns and tools: uses recursive CTEs to walk unlimited category depths and join back to orders, uses a lateral join to run one correlated subquery and return multiple columns instead of three scans, demonstrates window functions with partition, order and frames for running and sliding totals, explains grouping sets/rollup/cube, JSONB access/indexing and JSON_TABLE in Postgres, recommends the pgvector extension plus OpenAI or Hugging Face embeddings for cosine similarity, and points to system versioning in Microsoft SQL Server and graph queries arriving in Postgres 19.
AI-written summary · about
chapters (14)
- 0:00Introduction to modern SQL
- 1:52Common table expressions basics
- 3:17Recursive CTEs for hierarchies
- 5:20Lateral joins explained
- 9:58Window functions overview
- 13:14Window function ordering and ranking
- 17:51Lag lead and window frames
- 23:32Advanced aggregation with grouping sets
- 29:23Working with JSON in databases
- 36:23JSON indexing and gotchas
- 37:06Time travel with temporal queries
- 41:43Vector similarity search in SQL
- 45:43Graph queries in PostgreSQL 19
- 47:29Summary and Q&A
related talks
01h 00mComplex Queries with Modern SQL
45mSELECT 'amazing_features' FROM "postgresql"
49mSELECT 'amazing features' FROM "postgresql"
41mModern SQL: Evolution of a dinosaur
44mBeyond WHERE and GROUP BY
29mSELECT 'amazing_features' FROM "postgresql"
39mMore Than a Query Language: SQL in the 21st Century
46mAwesome SQL – tips and tricks for application developers