Purely relational SQL has been abandoned in 1999. Since then, SQL has got many non-relational features for 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 presentation demonstrates what modern SQL can do for you. It compares two different approaches to common problems: a purely relational one and the modern SQL approach. You will see that modern SQL databases are the Swiss Army Knives of persistence which allow up to react quickly when requirements change.
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!
Markus Winand is an independent author, trainer and consultant on all things SQL. His book SQL Performance Explained has just been translated into a fifth language. It can be purchased as a print edition, and it’s also available for free on his website. Markus is currently working on his second book centered on the idea that things have changed a lot since SQL-92. It is likewise available free of charge online.