Murach Joel. Murach's MySQL

Mike Murach and Associates, Inc. (Fresno, CA), 2019. — 646 p. — ISBN 978-1-943872-36-7.An introduction to relational databases.
How to use MySQL Workbench and other development tools.
How to retrieve data from a single table.
How to retrieve data from two or more tables.
How to insert, update, and delete data.
How to code summary queries.
How to code subqueries.
How to work with data types.
How to use functions.
How to design a database.
How to create databases, tables, and indexes.
How to create views.
Language skills for writing stored programs.
How to use transactions and locking.
How to create stored procedures and functions.
How to create triggers and events.
An introduction to database administration.
How to secure a database.
How to backup and restore a database.
Appendix A - How to install the software for this book on Windows.
Appendix B - How to install the software for this book on macOS.