|
It's concise, apparently complete, and easy to understand, even if the subject is a bit mind-bending at times. I need to learn about MySQL for my small business. This book is highly recommended by a guy who has read a lot of instructional material in a 40-year career that included service as a part-time college instructor.and by his adult son whose computer library cost his dad thousands of dollars. Without a book like this, I wouldn't enjoy the learning experience; it would be less pleasant than another knee surgery. My son the computer tech said this was the book I needed to get me up to speed quickly. He was right.
It concentrates solely on the how to do specific things, so you won't get weighed down by too much theory and so on. If you're doing web development in Ruby, PHP, Perl, Python or Java, you should consider this book. It's very quick and painless to lookup how to do something, and not have to wade through tons of information that's not relevant to you.The target audience for this book is really developers not DBAs, so keep that in mind.
This MySQL book exactly fits that description. The languages that they cover include Perl, Ruby, PHP, Java, Python. I really enjoy cookbooks because of their no nonsense organization.
If you're using any of those languages for your web application, it is more than likely you want a copy of this book. With that in mind, it's not per se a book on performance, testing, benchmarking and profiling applications in those languages, so if that is what you need, you'll require additional material. Chances are just scanning the table of contents you'll find the question you are asking with the answer and explanation at your fingertips.Nuggets of information I found quickly include: paging producing HTML output with the mysql client, checking and changing a tables storage engine, working with fulltext searches, summary and grouping query examples, importing data from CSV, exporting in various formats, dealing with auto_increment columns, sequences, deletes, gaps, and so on.
Also handling duplicates, detecting, eliminating, working with transactions, and a whole lot more.The book is mainly geared towards web applications and MySQL.
I thought the chapter on JOINS was especially well written. Not only does it present the SQL queries in the MySQL dialect, it also covers how to pump those queries through Pearl, Ruby, PHP, Python, and Java APIs.As an added bonus you can actually use this book to learn SQL. At 900+ pages this book addresses a lot of common SQL tasks. And that's what a good cookbook should do.
I recommend that you use another book to learn basic mysql (or just an online tutorial), and another to learn database design (Navathe). This book is-a great resource for those looking to implement various mysql functions-a great resource for database programmers-a trove of information on powerful query and sort techniquesFinding information about the topic you're looking for is a breeze in this book - the chapters are well-organized, and this book has anwered all questions I've posed to it.The cookbook is a powerful tool to those who know some mysql, and some dB design.
Stored procedures, triggers, and other new additions to MySQL are among the least-well understood but most powerful features of the database engine, yet astonishingly little space is spent on them. For example, only passing mention is made of the (possible) dependence of FULLTEXT indexes on choice of storage engine. 12.14, Performing a Join Between Tables in Different Databases). (I could understand not discussing them in depth as there are other books available, but length did not seem to be a concern anywhere else in this book).In summary, the book is an excellent resource for novices and experts alike - but only as a starting point. DuBois nicely avoids a pitfall many authors (the competence of whom I have to question) in this genre encounter: failure to weave security considerations into the text. As indicated, this book is true to its title.
3.1, Specifying Which Columns to Select) to fairly sophisticated (e.g. There is an entire chapter on handling duplicate rows, but the oft-needed (and non-obvious) process for removing pseudo-duplicate rows differing only by a primary key field is not directly addressed. It is a cookbook, by which I mean it contains a great number of (generally useful) recipes of varying complexity, but lacks detail and analysis that a more focused text would have.Mr. While other books often mention security as an afterthought, or worse include code examples featuring disasters like non-escaped strings (hello, SQL injection)., DuBois explicitly points out the need to sanitize input and writes code examples that demonstrate the use of prepared statements in best-practices.Unfortunately, in other areas he is less thorough. To return to the cooking analogy, the book at times feels like it is loaded down with recipes on how to add sugar to flour, but omits recipes on how to ice the cake. DuBois and O'Reilly publishing are clearly targeting a wide audience: the recipes range from frighteningly simple (e.g.
The recipes are typically clearly written, with ample supporting code examples and few typographical errors.I must also note that Mr.
|
