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

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

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