MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you're building or maintaining any significant application and are using MySQL, this book is for you.
I liked the book! It was on my taste like almost all of the apress books that i own. :D I would recommend it!
0Report
The first three chapters of this book deal with the basics of MySQL including basic concepts, column and table types, keys, indexes, and normalization. The authors have written an excellent introduction to MySQL that provides all the core information you need to start using it right away. The chapter on finding the bottlenecks is one of the best sections in the book and details some of the finer points to be considered when...
0Report
If you already know the basics of MySQL, then this book can be a nifty boost to your productivity. The authors plow straight into giving good tips for better table design. For example, the first chapter covers MySQL basics. But it furnishes very understandable advice. Like never using spaces in identifier names. While MySQL permits this, it greatly increases chances of logic errors. Later in the book are far more complicated...
0Report
I was hoping that there would be more about designing databases. Though I was pleasantly surprised at the solid introduction to MySQL that the book gives. In fact it spends the first two thirds of the book on the basics, before getting into optimization and finally programming. The design aspect of the book is in the third chapter, which is one of the books best. There is some good high level material on the fundamentals...
0Report
I had the pleasure of doing the technical review for this book, and I found it to be a great resource for those who have already had their first taste of MySQL and are looking to improve the design and performance of their databases. There is good coverage of normalization and advanced MySQL features, and the information contained within is great for those looking to advance their existing knowledge. The book may have the...
0Report