S. Noedel said
The book is pretty good, and offers lots of examples. MySQL is not very simple, and took me a lot of studying to learn. I found that I had to use several books at once to get the hang of things. One thing that this book does not cover very well are table keys (primary, foreign, etc).
Gallozzi Stefano said
this book is a very completed and updated quick look to database world and optimal reference book for sql/mySQL primer.
Stefano Gallozzi
Scandinavian Bits said
Learning MySQL (Learning)
Get this book! This O'Reilly book "Learning MySQL" first appeared in the book stores at the beginning of the year 2007. The book is written by two PhD authors who seem to have thoroughly tried its contents on their students, at RMIT University in Melbourne, Australia. You can buy this book and then create a splendid software career for yourself, programming Relational Databases. And live happily ever after.
If you are a total SQL beginner, please also buy a more simple-minded introductory SQL text as well; make you favorite pick among the 20-odd SQL texts available in your local bookstore, or read Amazon's reviews associated with all the other SQL books.
Now back to "Learning MySQL". I'm enjoying this book wherever I go, inserting my USB flash drive on any Windows machine I can lay my hands on. I have installed my free copy of MySQL on this low-cost device ($20 for a 4 GigB flash drive), together with Java, Apache Tomcat, FireFox, and other opensource goodies. My point is that this MySQL book covers Windows as well as it deals with Linux and Mac OS X, almost always in the same breath.
I typically try out the book's examples at the mysql> command prompt, but my own final application right now happens to consist of Java servlets, talking to MySQL databases, and running in Tomcat under the Java Virtual Machine (JVM), all on the puny USB flash drive without disturbing the particular Windows machine I'm visiting.
By following the book's examples I have built up a mental toolbox containing all the standard SQL techniques and all the helpful but proprietary MySQL extensions to SQL. Extensions which you might, or might not, want to assimilate, depending on your purity point of view.
As you go through the book's examples on your own mysql> command line, you realize that each example probably in an explanation triggered by questions from the authors' bright MySQL students. It is like sitting in their classroom lapping up the authours' knowledge. And, these authors know their stuff, something that cannot always be said of other SQL books.
One feature, among others in the book, is the authors' short but wonderful Chapter 4, where the reader is led by the hand through The Entity Relationship Model, and through the authors' database examples illustrating the super-important topic of How to map Entities and Relationships to Database Tables. There, the authors also point out existing tools to draw ER diagrams, such as the good free tool "Dia", or MySQL's own free "MySQL Workbench program" which is a very powerful visual database design tool, although still in the beta testing phase.
One last, but not least, comment. It appears that the book is extremely well suited to those Perl or PHP lovers, who want to get their MySQL teeth sharpened. But this reviewer is not into Perl nor PHP, yet, so don't take my word for it.
Arleston Lueders said
That's a good book, not for advanced SQL programmers though.
Easy to understand with great examples. I would recommend this book if you are starting to learn MySQL or are a intermediate programmer and needs a good database like MySQL. This book can be a reference for your studies. If I had this book before I could spent less time learning MySQL. But I probably would not recommend for heavy advanced SQL users, since the book have an overall idea of the SQL commands and some linux/php/database coding. Digg in!
Robert C. Gonzales said
This book is great. The text doesn't assume you have any advanced knowledge of anything. This is actually my second MySQL book. The first book didn't explain how to install and setup MySQL and then it didn't explain how to use the keyline MySQL monitor. So I was stuck after the first chapter.
"Learning MySQL" was a real life saver. You're given actual examples to follow along with and they actually explain what's going on.
Thank you sooooo much... I'm already using my new found MySQL knowledge at my job and now the book serves as a great resource for my new projects.
Comments