Modern SQL: Evolution of a Dinosaur

on YouTube ↗48m

" summary

A walkthrough of SQL standards from 1999 to 2016 that highlights how SQL has gained capabilities like Turing-completeness, graph processing, XML/JSON semantics, automatic temporal versioning, and time-series analysis with regex. The talk compares traditional SQL-92 solutions to modern SQL features using common problems and notes which database systems and versions support each feature.

AI-written summary · about

" chapters (10)

1. 0:00Introduction to modern SQL
2. 5:00Key SQL features explained
3. 10:00Performance and optimization
4. 15:00Advanced SQL techniques
5. 20:00Window functions and rankings
6. 25:00Offset and pagination in SQL
7. 30:00Running totals and balances
8. 35:00Temporal data and history tracking
9. 40:00Regular expressions in SQL
10. 45:00Q&A and closing remarks

" related talks

• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 2019
• 01h 00mModern SQL: Evolution of a DinosaurMarkus Winand · JAX 2019
• 50mModern SQL: Evolution of a dinosaurMarkus Winand · Riga Dev Days 2019
• 41mModern SQL: Evolution of a dinosaurMarkus Winand · WebCamp Zagreb 2018
• 46mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · code.talks 2019
• 58mThe Mother of All Query Languages: SQL in the 21st CenturyMarkus Winand · Dev Day Dresden 2019
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 2019
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Dutch PHP Conference 2019