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.