Learning MySQL and MariaDB

Learning MySQL and MariaDB: Heading in the Right Direction with MySQL and MariaDB

If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.

Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.

• Create and alter MySQL tables and specify fields and columns within them
• Learn how to insert, select, update, delete, join, and subquery data, using practical examples
• Use built-in string functions to find, extract, format, and convert text from columns
• Learn functions for mathematical or statistical calculations, and for formatting date and time values
• Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data
• Use APIs to connect and query MySQL and MariaDB with PHP and other languages

Table of Contents

Part I. The Software
Chapter 1. Introduction
Chapter 2. Installing MySQL and MariaDB
Chapter 3. The Basics and the mysql Client

Part II. Database Structures
Chapter 4. Creating Databases and Tables
Chapter 5. Altering Tables

Part III. Basics of Handling Data
Chapter 6. Inserting Data
Chapter 7. Selecting Data
Chapter 8. Updating and Deleting Data
Chapter 9. Joining and Subquerying Data

Part IV. Built-In Functions
Chapter 10. String Functions
Chapter 11. Date and Time Functions
Chapter 12. Aggregate and Numeric Functions

Part V. Administration and Beyond
Chapter 13. User Accounts and Privileges
Chapter 14. Backing Up and Restoring Databases
Chapter 15. Bulk Importing Data
Chapter 16. Application Programming Interfaces