If you’re a programmer new to databases—or just new toMySQL and its community-driven variant, MariaDB—you’ve found the perfectintroduction. This hands-on guide provides an easy, step-by-step approach toinstalling, using, and maintaining these popular relational database engines.
Author Russell Dyer, Curriculum Manager at MariaDB andformer editor of the MySQL Knowledge Base, takes you through database designand the basics of data management and manipulation, using real-world examplesand many practical tips. Exercises and review questions help you practice whatyou’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
