Author/s : Joel Murach
Publisher : Mike Murach & Associates
Category :
Data modeling, SQL and JDBC
Review by : Mohamed Sanaulla
Rating : 10 horseshoes
If you ever wanted to learn to use MySQL, write SQL queries, create database elements then this is the book to pick up.
Some of the salient features of the book:
- The usual Murach's style of code mixed with concepts. Its really useful because you are not only reading but also trying out the code. Its Learning by Doing.
- It starts with the importance of the formatting and structure of the SQL queries and follows them right through out the book. By the end of it you would be naturally using the convention.
- Clear division of the book into sections and the right ordering of these sections, this helps to plan the reading of the book accordingly.
- Good coverage of procedural programming, Normalisation concepts as well as basic db Administration concepts.
- The importance of the use of tools (MySQL WOrkbench) is also explained, but you dont find it overstressed anywhere in the book. They have introduced the tools as and when necessary.
- Exercise questions at the end of each chapter to
test your understanding.
I know lot of you would say that with the ORM frameworks and frameworks which provide DSLs to create database structures (like migrations in Rails) such a book exclusively on a particular database might be redundant. But to really understand how these frameworks work, one has to be aware of SQL language and also be familiar with using the db. I think these frameworks may not be of much help in cases where we would have to write complex queries or a stored procedure to perform complex calculations.
The intended audience:
-Any one new to SQL/new to MySQL.
-For someone familiar to SQL but not MySQL might find initial few chapters easy to read.
-Any one who wants to do some advanced procedural programming in MySQL.
I couldn't find anything which I didnt like. Though I might be tempted to say the size of the book, but considering the content it is packed with, the code examples, the exercises, the size shouldn't be of much concern.
---
Disclosure: I received a copy of this book from the publisher in
exchange for writing this review on behalf of CodeRanch.
More info at Amazon.com