Book description
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
Publisher resources
Table of contents
- Dedication
- Foreword
- Preface
- I. The Software
- II. Database Structures
- III. Basics of Handling Data
- IV. Built-In Functions
-
V. Administration and Beyond
- 13. User Accounts and Privileges
- 14. Backing Up and Restoring Databases
- 15. Bulk Importing Data
- 16. Application Programming Interfaces
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Learning MySQL and MariaDB
- Author(s):
- Release date: March 2015
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449362904
You might also like
book
Mastering MariaDB
Debug, secure, and back up your data for optimum server performance with MariaDB In Detail MariaDB …
book
Learning MySQL, 2nd Edition
Get a comprehensive overview on how to set up and design an effective database with MySQL. …
book
Learn PostgreSQL
A comprehensive guide to building, managing, and securing scalable and reliable database and data warehousing applications …
book
MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers
Move data back and forth between database and application. The must-have knowledge in this book helps …