Last week at Percona Live, I was asked what book I recommend for novices seeking to learn MySQL. For a long time, there has not been a good choice for modern versions of MySQL. Luckily I had just stumbled upon such a book. Now I am happy to recommend The MySQL Workshop – A practical guide to working with data and managing databases with MySQL by Petit and Cosentino.
The first chapter introduces database architectures, data types, storage engines (including MyRocks), and data normalization. The following chapter cover in great detail how to create a database, using MySQL Workbench, backups & restoring data, and creating indexes. Chapter four has a very good section on working with SQL, functions, and case statements. Then JOINs and stored procedures are covered.
In another book, that would probably be enough content, but later chapters plunge into using Node.JS, Access, and Excel with …[Read more]