The MariaDB team has announced the release of version 5.3.5, the first stable general availability release of the MariaDB 5.3 series relational database.
Work on the new series has concentrated on improving the performance of the database, in particular query speeds.
MariaDB is the community-developed spin-off of MySQL that was started when Oracle took over the original MySQL. MariaDB is developed by Monty Program, which was started by Monty Widenius, the main developer of the original version of MySQL.
The areas where the query optimizer has been improved start with subqueries, which now work well enough to avoid having to rewrite subqueries manually into joins or into separate queries. The Maria Knowledgebase says that all problems with EXPLAIN taking a long time have also been resolved.
The optimizer changes include support for block hash joins for any equi-joins. There’s a new implementation of Multi-Range-Read optimization to improve performance for IO-bound queries that need to scan lots of rows, and all block-based algorithms for joins can make use of index condition pushdown.
A SQL bootcamp that starts from the very beginning is available from Udemy. While it is based around PostgreSQL, the majority of the lectures are agnostic about the dialect of SQL you're using so coul [ ... ]