Programming the SQL Way with Common Table Expressions
summary
Shows exactly what Common Table Expressions do and how far they go: demos of with recursive loops that print 1–10, compute factorial and prime factors, tree walking for part explosions and dependency graphs, and using arrays to sort hierarchical paths. Explains why union all is required, what the termination condition looks like, and introduces writable CTEs that chain reads and writes (for example delete ... returning) so multi-step ops run as one command. Watch if you need concrete queries and working examples.
AI-written summary · about
chapters (30)
- 0:00Introduction
- 3:18Imperative Programming Languages
- 6:52Syntax
- 9:47Naming a Column
- 10:48Union
- 11:45Multiple Table Expressions
- 14:36Imperative
- 15:20Recursive
- 20:17Union All
- 26:59One to Ten
- 28:18Factorial
- 29:02Perl
- 30:27ASCII
- 31:17Circles
- 31:47Prime Factors
- 35:19Optimization
- 35:52Part Explosion
- 36:22Part Walking
- 39:38Sorting
- 40:20ASCII Art
- 40:36Full Output
- 44:10Dependent Object
- 46:09Im a Beginning
- 49:24How do they work
- 50:59Template Table
- 51:50Writable
- 52:15ReadOnly
- 52:40Average
- 54:23Chaining
- 54:59Break
related talks
01h 00mComplex Queries with Modern SQL
39mMore Than a Query Language: SQL in the 21st Century
18mHow to write powerful SQL that's easy to maintain
31mFuturistic SQL: Making the impossible possible
50mCommon table expressions (CTE) and window functions in MySQL 8.0
34mCommon Table Expressions and Window Functions simple, maintainable, fast queries
54mBecoming a SQL Guru
44mBeyond WHERE and GROUP BY