Murach's MySQL

by Joel Murach

The current edition of this book is Murach's MySQL, 2nd Edition . This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling "Java Servlets and JSP" and "PHP and MySQL" books, this is exactly the database book that web developers should have on their desks. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of the MySQL enhancements that aren't covered in older books, such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a whole section on database administrator (DBA) skills, including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

Genres: Programming, Nonfiction, Technology

587 pages, Paperback

First published May 1, 2012

Reviews

[Jeanne Boyarsky · Rating 4 out of 5]

“Murach's MySQL” is your typical Murach book. It's great for learning something new because of the paired page format. I'm used to seeing that format for coding books. Turns out the same benefits apply to SQL. We have syntax/queries/tables on one side and text on another. Each chapter ends with exercises to reinforce the knowledge.

I was happy to see the section on design covered levels of normalizations. I was also happy to see basic database administration covered. The tables were easy to understand and provided good examples. The stored program/procedure sections were good as well.

This is a great book for someone new to databases.

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

[Shanni · Rating 3 out of 5]

An incredibly detailed book for beginners with some great additional resources available for free from the publisher. While there are many examples, most are not put in a larger context, so I've had to search elsewhere for explanations or usage.

[Hooman · Rating 5 out of 5]

I should say thank you to my friend Brian, who sent me this great book as a gift. It is a perfect reference if you want to refresh your knowledge about MySQL as well as learning it from zero to master, if you are a beginner

[Jose Giron · Rating 4 out of 5]

Not bad, has a lot of concepts and is structured to actually be a reference book, you can get. you can get your database up and running with it and probably will be in and out of your shelf for as long as you work with databases.

[Sara · Rating 5 out of 5]

Super thorough and clearly written with a lot of great examples and exercises.

[Kimee · Rating 2 out of 5]

This book taught me a pet peeve I have. I prefer to see text describing an example immediately next to or before said example, not bunched up with texts describing other examples.

[Jordan]

fuck

[Ethan Gilworth · Rating 5 out of 5]

Hands down the best programming textbook I’ve ever read. Gives a comprehensive guide on MySQL complete with exercises. The perfect handbook as well.

[Sam L · Rating 4 out of 5]

I always dislike textbooks with too much fluff, so I like the way this author puts the fluff on the left hand page and the code examples / bullet points on the right so I can just use that.

[Ray Johnson · Rating 4 out of 5]

Good start, definitely needed to supplement with texts that included more recipes/examples. I suppose if I had the time to follow along piece by piece with the book by creating and manipulating his example databases I could have gotten more out of it. I would assume those who seek this kind of material aren't always in a place which allows that much dedication, either. In any case, it was a well written book and the format was extremely accessible.

[Jin Shusong]

Very good to new mysql users.

[Brian Salehi · Rating 5 out of 5]

The book is complete! I read the whole book in almost 10 days two years ago and I started to write heavy MySQL scripts confidently. Strongly suggest this book for database programmers.