This first-to-market tutorial covers everything beginners need to succeed with MariaDB, the open, community-based branch of MySQL. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of SQL users who simply want to interact with data. Forta covers all this, and more:

• Using the MariaDB toolset * Retrieving and sorting data
• Filtering data using comparisons, wildcards, and full text searching
• Analyzing data with aggregate functions
• Performing insert, update, and delete operations
• Joining relational tables using inner, outer, and self joins
• Combining queries using unions * Using views
• Creating and modifying tables, and accessing table schemas
• Working with stored procedures, cursors, and other advanced database features
• Managing databases, users, and security privileges

This book was reviewed and is supported by MariaDB's developers, Monty Program AB. It contains a foreword by project founder Monty Widenius, primary developer of the original version of MySQL.