Presented by Elizabeth Smith (@auroraeosrose)

April 20, 2017

Everyone knows that SQL is an outdated tool with a standard written in 1992 that isn’t webscale. Who needs consistency or isolation or even atomicity with your data. Just shove it in a document store! And then that transaction is suddenly missing for your user… SQL is not a dirty word, and if you’re processing data you should know how to use the right tool for the job. Learn about modern SQL dialect features including CTEs, aggregate filters, with clauses and more. We’ll look at database support for these features, and use PostgreSQL for examples. We’ll also look at features that many traditionally relational databases are adding and play with PostgreSQL’s jsonb features.

Tags: SQL,PostgreSQ