Forums:

Murach's MySQL, 4th edition, by Joel Murach

posted 2 months ago

Number of slices to send:

Optional 'thank-you' note:

Send

Image from Amazon
Title: Murach's MySQL (4th Edition)
Author(s): Joel Murach
Publisher: Mike Murach & Associates

Summary

Mike Murach & Associates wrote:Ihe latest edition of Murach’s classic MySQL book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips.To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the most important SQL statements because developers use them every day. Then, it shows how to design a database, how to implement that design, and how to work with views, transactions, stored procedures, functions, triggers, and events. Finally, it presents a starting set of skills for a database administrator (DBA) including how to manage security, how to backup and restore a database, and how to host a MySQL database with Amazon Web Services (AWS).The result? You’ll be able to use SQL to work with a MySQL database in a way that’s thoroughly professional.Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive “paired-pages” format is ideal for learning and reference./quote]

Book Preview (when available)

From the publisher

Table of Contents (PDF)
Chapter 3 - How to retrieve data from a single table ()
Book Applications and Exercises (ZIP)
Corrections (Where to get it?

[url=https://www.amazon.com/Murachs-MySQL-Reference-Joel-Murach/dp/B0CHMPQ3FC" target="_blank" rel="nofollow">Amazon.com
Mike Murach & Associates

Related Websites

MySQL

COMMENTS:

Jeanne Boyarsky

author & internet detective

Posts: 41905

909

I like...

posted 2 months ago

Number of slices to send:

Optional 'thank-you' note:

Send

I reviewed the third edition of “Murach's MySQL” four years ago.

The fourth edition is your typical Murach book. It's great for learning something new because of the paired page format. We have syntax/queries/tables on one side and text on another. I was recently able to find information faster in a Murach book than online (on Python) because of this format!

Each chapter ends with exercises to reinforce the knowledge. I was happy to see the section on design covered levels of normalizations. I liked the sections on stored procs and transactions. The tables were easy to understand and provided good examples. The stored program/procedure sections were good as well.

The new content on AWS was great. And the appendices for Windows and Mac were helpful. This is a great book for someone new to databases.

I give this book 8 out of 10 horseshoes.

Disclosure: I received a copy of this book from the publisher in exchange for writing this review on behalf of CodeRanch.

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Consider Paul's rocket mass heater.