SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more. This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not. Teaser: MySQL and MariaDB have got huge updated lately. In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!

Comments

Please login to leave a comment

A really good talk. I have realized that I do not know many SQL areas :(

I just realize after that talk that I have to learn modern SQL. Thanks

Rated 5

Miro Svrtan at 10:16 on 30 Oct 2018

Wow, I really didn't know how much SQL I don't know ..

TBH, it did feel overwhelmed at times, I would love if the speaker went thru less features but explained them bit more in-depth but it was a brilliant overview that will motivate me to check those things out