The Mother of All Query Languages: SQL in the 21st Century

on YouTube ↗58m

" summary

Markus Winand reviews how SQL has evolved since 1999 from a strictly relational language to include non-relational operations and data structures. He explains which database vendors adopted these non-relational SQL features and demonstrates several new SQL capabilities by mapping them to common development requirements.

AI-written summary · about

" chapters (11)

1. 0:00Modern SQL introduction
2. 7:06SQL:1999 standard and data model
3. 15:02Hierarchies and recursive queries
4. 19:18LATERAL joins and Top-N queries
5. 22:49SQL:2003 standard and window functions
6. 28:48Median calculation and performance
7. 34:00JSON in SQL 2016
8. 41:02Regex for rows
9. 47:03Time travel in SQL
10. 53:07Summary and outlook
11. 56:18Q&A

" related talks

• 46mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · code.talks 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
• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 2019
• 39mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Big Data Conference Europe 2019
• 48mModern SQL: Evolution of a DinosaurMarkus Winand · DevConf 2018
• 50mModern SQL: Evolution of a dinosaurMarkus Winand · Riga Dev Days 2019
• 01h 00mModern SQL: Evolution of a DinosaurMarkus Winand · JAX 2019