Read more
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
List of contents
Foreword
Preface
The Software
Chapter 1: Introduction
Chapter 2: Installing MySQL and MariaDB
Chapter 3: The Basics and the mysql Client
Database Structures
Chapter 4: Creating Databases and Tables
Chapter 5: Altering Tables
Basics of Handling Data
Chapter 6: Inserting Data
Chapter 7: Selecting Data
Chapter 8: Updating and Deleting Data
Chapter 9: Joining and Subquerying Data
Built-In Functions
Chapter 10: String Functions
Chapter 11: Date and Time Functions
Chapter 12: Aggregate and Numeric Functions
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
Colophon
About the author
Russell Dyer has worked full-time for several years as a free-lance writer of computer articles, primarily on MySQL. He has been working with MySQL ABas the editor of their new Knowledge Base since December 2004. He has published over ninety articles for several magazines.
Summary
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.
