Modern SQL: A lot has changed since SQL-92 by Markus Winand
Devoxx2 HN recommenders · recommended in 2 months, 2019-2023
6K views · 8 years ago · talk · evergreen
Markus Winand shows how SQL has evolved since SQL-92, comparing old-style solutions to modern features such as window functions and system versioning, and notes that many developers never learn them.
Recommended as the best introduction to modern SQL standard features that textbooks skip.
50:31How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder
Devoxx
55K views • 9 years ago
54:52Introduction to NoSQL • Martin Fowler • GOTO 2012
GOTO Conferences
1M views • 13 years ago
39:00SQLite: Protégé of PostgreSQL
Andrea Ross
8K views • 12 years ago
51:02An Introduction to SQLite
Google TechTalks
80K views • 19 years ago
1:01:45Four Languages from Forty Years Ago - Scott Wlaschin
NDC Conferences
33K views • 8 years ago
1:06:24Rich Hickey: Deconstructing the Database
InfoQ
106K views • 14 years ago
54:25Event Sourcing • Greg Young • GOTO 2014
GOTO Conferences
102K views • 11 years ago
42:31"Datafun: a functional query language" by Michael Arntzenius
Strange Loop Conference
9K views • 9 years ago
10:48PHP doesn't suck (anymore)
Aaron Francis
223K views • 3 years ago
52:54Rust at speed — building a fast concurrent database
Jon Gjengset
225K views • 7 years ago
59:56AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)
Amazon Web Services
468K views • 7 years ago
50:23Old Is the New New • Kevlin Henney • GOTO 2018
GOTO Conferences
125K views • 8 years ago
59:21A Crash Course in Modern Hardware by Cliff Click
Devoxx
21K views • 9 years ago
![AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)](https://i.ytimg.com/vi/6yqfmXiZTlM/hq2.jpg)
59:13AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)
AWS Events
115K views • 6 years ago
48:04Greg Young — A Decade of DDD, CQRS, Event Sourcing
Domain-Driven Design Europe
190K views • 10 years ago
40:42Lucas Cavalcanti & Edward Wible - Exploring four hidden superpowers of Datomic
ClojureTV
29K views • 11 years ago
59:58SQLite: The Database at the Edge of the Network with Dr. Richard Hipp
Method
82K views • 11 years ago
34:10Anders Hejlsberg on Modern Compiler Construction
Kasper
25K views • 9 years ago
47:43"Turning the database inside out with Apache Samza" by Martin Kleppmann
Strange Loop Conference
205K views • 12 years ago
46:37Zebras All the Way Down - Bryan Cantrill, Uptime 2017
Code & Supply
49K views • 9 years ago
3 comments from Hacker News
I happened to fall down this rabbit hole a few days ago because of another HN thread. In it, a commenter mentioned [1] a talk by Markus Winand where he goes over some of the more interesting additions to the SQL standard since 92, including versioned tables [2] (I've linked to the timestamp, but the whole talk is good). I got real excited about that feature because I could think of a few tables at work that could use it. Sadly, PostgreSQL doesn't implement it [3] (I can't permalink to the feature but you can search for "T180", "System-versioned tables", "T181", or "Application-time period tables"). [1] link [2] ▶ this video [3] link
That feature's "coming" - part of SQL 2011 called System Versioning, currently supported in DB2 and SQL Server, but available in MariaDB 10.3 Beta according to this talk: ▶ this video
I recommend you look at one of Markus Winand's presentations, such as this one : ▶ this video I felt it summarized well the modern foundation of SQL databases.