More Than a Query Language: SQL in the 21st Century

on YouTube ↗46m

" summary

A history and practical overview of how SQL has evolved since 1999 from a strictly relational language to include non-relational operations and data structures. It highlights when major vendors adopted these extensions (noting MySQL 8.0 in 2018 as a final milestone) and demonstrates several newer SQL features mapped to common developer requirements.

AI-written summary · about

" chapters (14)

1. 0:00SQL's diverse roles
2. 3:24Relational model basics
3. 10:32Atomic to flexible types
4. 12:25Hierarchies and recursion
5. 15:33SQL:1999 extensions
6. 17:24Window functions game changer
7. 23:19Modern SQL standards
8. 24:24JSON in SQL databases
9. 29:18Schema transformations
10. 30:20Temporal data versioning
11. 33:35SQL standard evolution
12. 35:43SQL as data processor
13. 36:25Summary
14. 36:48Q&A

" related talks

• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 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 · Dutch PHP Conference 2019
• 39mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Big Data Conference Europe 2019
• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 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