August 2023 MBR The Computer Shelf

The Computer Shelf

MySQL Crash Course
Rick Silva
No Starch Press
www.nostarch.com
9781718503007, $49.99, PB, 352pp

https://www.amazon.com/MySQL-Crash-Course-Hands-Introduction/dp/1718503008

Synopsis: With the publication of "MySQL Crash Course: A Hands-on Introduction to Database Development", Rick Silva provides a fast-paced, no-nonsense introduction to relational database development. A combination instructional reference and DIY 'how-to' manual, "MySQL Crash Course" packed from cover to cover with practical examples and expert advice that will have you up and running quickly.

With "MySQL Crash Course", you will learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. You will also see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You can even explore how to call MySQL from PHP, Python, and Java.

Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.

"MySQL Crash Course" is especially relevant for anyone with an interest in: Query database tables for specific information, order the results, comment SQL code, and deal with null values; Defining table columns to hold strings, integers, and dates, and determine what data types to use; Joining multiple database tables as well as use temporary tables, common table expressions, derived tables, and subqueries; Adding, changing, and removing data from tables, creating views based on specific queries, writing reusable stored routines, and the automating and scheduling of events.

Critique: An ideal and unreservedly recommended quick-start resource for database developers of MySQL-based data storage systems, and also available in a digital book format (Kindle, $29.99), "MySQL Crash Course: A Hands-on Introduction to Database Development" a core addition to personal, professional, community, college, and university library MySQL computer science collections and supplemental curriculum studies lists.

Editorial Note: Rick Silva is a software developer with decades of database experience. Silva has worked at Harvard Business School, Zipcar, and various financial services companies.

EDITOR'S NOTE:

The Midwest Book Review is an organization of volunteers committed to promoting literacy, library usage, and small press publishing. We accept no funds from authors or publishers. Full permission is given to post any of these reviews on thematically appropriate websites, newsgroups, listserves, internet discussion groups, organizational newsletters, or to interested individuals. Please give the Midwest Book Review a credit line when doing so.

The Midwest Book Review publishes the monthly book review magazines "California Bookwatch", "Internet Bookwatch", "Children's Bookwatch", "MBR Bookwatch", "Reviewer's Bookwatch", and "Small Press Bookwatch". All are available for free on the Midwest Book Review website at www (dot) midwestbookreview (dot) com

Anyone wanting to submit books for review consideration can send them to:

James A. Cox, Editor-in-Chief
Midwest Book Review
278 Orchard Drive
Oregon, WI 53575-1129

To submit reviews of any fiction or non-fiction books, email them to Frugalmuse (at) aol (dot) com (Be sure to include the book title, author, publisher, publisher address, publisher website/phone number, 13-digit ISBN number, and list price).

James A. Cox, Editor-in-Chief
Midwest Book Review