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 Introduct= ion to Database Development", Rick Silva provides a fast-paced, no-nonsense=
introduction to relational database development. A combination instruction=
al reference and DIY 'how-to' manual, "MySQL Crash Course" packed from cove=
r 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,procedu= res, and functions. You will also see how to add constraints to tables to e= nforce rules about permitted data and useindexes to accelerate data retriev= al. 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 scr= atch, 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 string=
s, integers, and dates, and determine what data types to use; Joining multi= ple database tables as well as use temporary tables, common table expressio= ns, derived tables, and subqueries; Adding, changing, and removing data fro=
m 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 da= tabase developers of MySQL-based data storage systems, and also available i=
n a digital book format (Kindle, $29.99), "MySQL Crash Course: A Hands-on I= ntroduction to Database Development" a core addition to personal, professio= nal, community, college, and university library MySQL computer science coll= ections 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 vario=
us financial services companies.

EDITOR'S NOTE:

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

The Midwest Book Review publishes the monthly book review magazines "Califo= rnia Bookwatch", "Internet Bookwatch", "Children's Bookwatch", "MBR Bookwat= ch", "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 Frugal= muse (at) aol (dot) com (Be sure to include the book title, author, publish= er, publisher address, publisher website/phone number, 13-digit ISBN number=
, and list price).

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

--- MBSE BBS v1.0.8.4 (Linux-x86_64)
* Origin: ---:- FTN<->UseNet Gate -:--- (3:633/280.2@fidonet)