Mariadb Crash Course

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.

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches.

MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. 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 users who simply want to interact with data.

Learn how to:

• Retrieve and sort data
• Filter data using comparisons, regular expressions, and full text search
• Join relational data
• Create and alter tables
• Insert, update, and delete data
• Leverage the power of stored procedures and triggers
• Use views and cursors
• Manage transactional processing
• Create user accounts and manage security via access control

Introduction

Chapter 1: Understanding SQL

Chapter 2: Introducing MariaDB

Chapter 3: Working with MariaDB

Chapter 4: Retrieving Data

Chapter 5: Sorting Retrieved Data

Chapter 6: Filtering Data

Chapter 7: Advanced Data Filtering

Chapter 8: Using Wildcard Filtering

Chapter 9: Searching Using Regular Expressions

Chapter 10: Creating Calculated Fields

Chapter 11: Using Data Manipulation Functions

Chapter 12: Summarizing Data

Chapter 13: Grouping Data

Chapter 14: Working with Subqueries

Chapter 15: Joining Tables

Chapter 16: Creating Advanced Joins

Chapter 17: Combining Queries

Chapter 18: Full-Text Searching

Chapter 19: Inserting Data

Chapter 20: Updating and Deleting Data

Chapter 21: Creating and Manipulating Tables

Chapter 22: Using Views

Chapter 23: Working with Stored Procedures

Chapter 24: Using Cursors

Chapter 25: Using Triggers

Chapter 26: Managing Transaction Processing

Chapter 27: Globalization and Localization

Chapter 28: Managing Security

Chapter 29: Database Maintenance

Chapter 30: Improving Performance

Appendix A: Getting Started with MariaDB

Appendix B: The Example Tables

Appendix C: MariaDB Datatypes

Appendix D: MariaDB Reserved Words

Index