This is a good choice as the first book about MySQL. Joel has been writing and editing books about computer programming for over 20 years. He has written extensively on a wide range of Java, .NET, web, and database technologies.
An introduction to MySQL (how to use MySQL Workbench, how to retrieve data from a single table, how to retrieve data from two or more tables, How to insert, update, and delete data);
More SQL skills (how to code summary queries, how to code subqueries, how to work with data types, how to use functions);
Database design and implementation (how to create databases, tables, and indexes and views);
Stored program development (how to use transactions and locking, how to create stored procedures and functions, triggers and events);
Database administration (an introduction to database administration, how to secure a database, how to backup and restore a database).
One more example of a good book for beginners. The author is a software consultant and programmer. Since the 1990s, He has been designing database solutions both independently and for various companies.
What are relational databases;
How to install MySQL;
What is MySQL Database Design;
What is MySQL Database Normalization;
What is MySQL Servers and Databases;
What is MySQL Tables and Indexes;
Design Overview: Human Resources and Training Database;
This book is good for beginners and professional database and web developers. It contains a lot of answers on how to solve specific problems – small pieces of code for each problem, hundreds of worked-out examples, and clear explanations for programmers who don’t have the time to solve MySQL problems from scratch.
Paul DuBois is one of the primary contributors to the MySQL Reference Manual. He is a member of the MySQL documentation team at Oracle Corp. He is also the author o a few books MySQL.
Using the MySQL client program;
Writing MySQL-Based Programs;
Selecting Data from Tables;
Working with Strings;
Working with Dates and Times;
Sorting Query Results;
Using Stored Routines, Triggers, and Scheduled Events;
It’s a comprehensive guide of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You’ll learn how data structures and convenience functions operate, how to add new storage engines and configuration options.
Sasha Pachev was a part of the MySQL Development Team in 2000. He wrote and maintained the MySQL replication module up until 2002.
MySQL History and Architecture;
Nuts and Bolts of Working with the MySQL Source Code;
Book describes different high availability options, including clustering and replication solutions within MySQL. Give you advice on how to improve the uptime of your MySQL databases, tune the database for optimal performance.
Book is good for database developers. It’s about how to recover from performance problems, crashes, data corruption, and puzzling output.
Sveta Smirnova is a Principal Support Engineer for MySQL. Before she worked as Senior Principal Technical Support Engineer in the Bugs Verification Group of the MySQL Support Group at Oracle for more than 8 years. She works with MySQL for more than 15 years.
This practical book is about: replication, clusters, and monitoring features written by engineers who designed many of the tools covered, reveals undocumented or hard-to-find aspects of MySQL reliability and high availability.
Dr. Charles A Bell is a Senior Software Engineer at Oracle. Dr. Mats Kindahl is a senior principal software developer working on the MySQL server, main architect and implementor of MySQL’s row-based replication. Dr. Lars Thalmann is the development director for MySQL Replication, Backup, Connectors, Utilities, and Fabric.
This book is about storing, retrieving, and manipulating data using the latest MySQL 8 features. Practical recipes on effective administration with a focus on security, performance tuning, troubleshooting. It contains tips, tricks, and best practices for designing, developing, and administering MySQL 8 database.
This resource contains information for everyone: from beginner to experienced MySQL administrators. You can find essential coverage of the fundamentals of MySQL database management: basic database features and functions, coverage of SQL queries, data and index types, store procedures and functions, triggers and views, transactions.