With an easy, step-by-step approach, this practical guide shows programmers new to databases how to install, effectively use, and maintain MySQL and MariaDB. You’ll learn these database systems through real-world examples and many practical tips.
Popular and easy-to-use database engines such as MySQL and MariaDB—a community-driven variant of MySQL—help organizations large and small handle data by providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. Experienced web developers and programmers interested in adding MySQL to their skill sets will also find this book useful.
Topics include:
* An introduction to database systems and the SQL database language
* Installation and basic administration of MySQL and MariaDB
* Functions, subqueries, and other query enhancements
* Methods for accessing MySQL and MariaDB from popular programming languages