Modern SQL: Evolution of a dinosaur
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. What can modern SQL do for you? It has come a long way. This session from the International PHP Conference will teach you about the SQL of today. Find out more with Markus Winand.
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. In this session, developers and software architects of all levels gain a better understanding of 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 to read for free on his use-the-index-luke.com 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 (modern-sql.com).