Modern SQL in Open Source Databases
SQL has evolved beyond the relational model over the past decades and can now solve many problems more easily as compared to good old SQL-92. However, due to the limited support in open source databases, this revolution has been largely unnoticed in the open source scene. Until now. At the moment, many open source databases are adding these new features to their portfolio. This session highlights some of the most important new SQL features and compares their availability in commercial and open source databases (MariaDB, MySQL, PostgreSQL, SQLite). This session provides a brief introduction to some of these features and thus helps you in both: using your current database more effectively and choosing the right database for your next project.
Tuning developers for SQL performance, winand.at
As an author, trainer, and coach Markus Winand specializes in helping developers cope with SQL performance issues. He also published the book "SQL Performance Explained" and runs the popular blog "Use The Index, Luke!"