this book is a very completed and updated quick look to database world and optimal reference book for sql/mySQL primer.
Stefano Gallozzi

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.

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!

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.

The first twelve chapters of "Learning MySQL" appear to be a textbook written in the mid-1990s for teaching MySQL to college students. Chapter 13 appears to have been added in 1999, about using MySQL with PHP to build websites. The first twelve chapters require using a terminal or command line (shell) interface to MySQL. My hosting service no longer supports command line interfaces, you're required to use PHPmyAdmin, which is faster and easier. Without access to a command line interface I couldn't do the exercises in the first twelve chapters; without understanding the first twelve chapters you can't figure out chapter 13. Chapter 13 teaches the PHP mysql extensions, which were superseded in 2004 by the mysqli ("i" for "improved") extensions. So the book is two generations out of date. Chapter 14 is about using Perl with PHP -- has anyone built a website with Perl in the last five years? There are other annoyances, such as you're taught to read data out of your database before you're taught to insert data into your database. After flipping back and forth between sections trying to find missing information I gave up. It's hard to believe that O'Reilly published this dinosaur in 2006. I recommend instead "Beginning PHP and MySQL 5: From Novice to Professional," by W. Jason Gilmore.

I was really impressed with "Learning MySQL". I actually got into MySQL because I was interested in developing data-driven websites. Instead of just buying a book on PHP & MySQL, I thought I would start by focusing just on MySQL to develop a strong foundation on the database side. With that in mind, I felt like this book did a great job covering all bases (no pun intended...Alright, I put some thought into that one).

If you are completely new to databases, then this book is a good place to start - here's why:

1) Coverage of database concepts and design: This book doesn't just launch into the code stuff. It will teach you about database structure and relationships. It will give you some pretty straight-forward rules on how you should design your database with regards to what goes in what tables and how columns in the tables relate to each other (the actual data relationships).

2) History of SQL: Without going into too much detail, the book explains where SQL has come from and what you can expect from it now.

3) Explanation of SQL Syntax: This book does a great job breaking down the syntax of the SQL language and showing you the standard syntax for the various statements it presents.

4) Examples galore: Okay, so a lot of the examples are pretty useless, but they do what they need to - show you how things work. There are also some big examples that are used consistently throughout the book, so you can see your own development in how you interact with the data. There are SQL scripts that you can download from the O'Reilly website to import the tables and data directly into your database to follow along with the authors' examples.

5) Database Tools: The book points you to some useful graphical tools that can be used to interact with your database server or even to design databases (then import the design structure directly into your MySQL server). To be honest, though, it doesn't really go into too much detail on how to configure or use the software (but it's pretty easy to figure out). I think the most important thing is that the book uses the command-line for all it's examples. There is no padding between you and the database.

6) MySQL installation: If you are installing MySQL for the first time (and PHP or Perl for that matter), this book does a fantastic job showing you detailed instructions on how to get everything installed on the Linux, Mac and Windows platforms (using multiple methods on each platform). I used Linux, so I can't actually vouch for how great the instructions are on the other platforms, but - from what I picked up - they are good (definitely better than some other books that tend to favor one platform over another, and put in instructions for those other platforms as an after-thought).

The bottom line is that this book does a great job of getting you up and running, explaining the concepts behind database management, and using examples to teach you how to use the wealth of SQL statements to achieve your goals.

There is also a few chapters at the end of the book that will whet your appetite for building web applications to interact with your database (PHP and Perl). Be warned: These chapters don't do a very good job teaching you PHP and Perl (which is understandable because it's a MySQL book). However, they do show you what MySQL is capable of when combined with these other languages.

I was really impressed with "Learning MySQL". I actually got into MySQL because I was interested in developing data-driven websites. Instead of just buying a book on PHP & MySQL, I thought I would start by focusing just on MySQL to develop a strong foundation on the database side. With that in mind, I felt like this book did a great job covering all bases (no pun intended...Alright, I put some thought into that one).

If you are completely new to databases, then this book is a good place to start - here's why:

1) Coverage of database concepts and design: This book doesn't just launch into the code stuff. It will teach you about database structure and relationships. It will give you some pretty straight-forward rules on how you should design your database with regards to what goes in what tables and how columns in the tables relate to each other (the actual data relationships).

2) History of SQL: Without going into too much detail, the book explains where SQL has come from and what you can expect from it now.

3) Explanation of SQL Syntax: This book does a great job breaking down the syntax of the SQL language and showing you the standard syntax for the various statements it presents.

4) Examples galore: Okay, so a lot of the examples are pretty useless, but they do what they need to - show you how things work. There are also some big examples that are used consistently throughout the book, so you can see your own development in how you interact with the data. There are SQL scripts that you can download from the O'Reilly website and import directly into your database to follow along with the authors' examples.

5) Database Tools: The book points you to some useful graphical tools that can be used to interact with your database server or even to design databases (then import the design structure directly into your MySQL server). To be honest, though, it doesn't really go into too much detail on how to configure or use the software (but it's pretty easy to figure out). I think the most important thing is that the book uses the command-line for all it's examples. There is no padding between you and the database.

6) MySQL installation: If you are installing MySQL for the first time (and PHP or Perl for that matter), this book does a fantastic job showing you detailed instructions on how to get everything installed on the Linux, Mac and Windows platforms (using multiple methods on each platform). I used Linux, so I can't actually vouch for how great the instructions are on the other platforms, but - from what I picked up - they are good (definitely better than some other books that tend to favor one platform over another, and put in instructions for those other platforms as an after-thought).

The bottom line is that this book does a great job of getting you up and running, explaining the concepts behind database management, and using examples to teach you how to use the wealth of SQL statements to achieve your goals.

There is also a few chapters at the end of the book that will whet your appetite for building web applications to interact with your database (PHP and Perl). Be warned: These chapters don't do a very good job teaching you PHP and Perl (which is understandable because it's a MySQL book). However, they do show you what MySQL is capable of when combined with these other languages.

I've read several books on MySQL but believe me this is the best of them. The author has done a fantastic job to bring this subject to such a level that anyone with little or no knowledge of RDBMS can understands it properly. The book covers all vital parts of MySQL.

While the content of this book is a basic coverage of MySQL, the editing is absolutely atrocious. The page layout puts graphics for the examples being talked about perpetually two pages ahead of where the example is used in text. Additionally, every time they cover examples of what not to do, or incomplete layout it is corrected to show what you ought to do, then the discussion continues assuming you will use the previously deemed bad example. I also found that every example of a command being issued on the command-line was in it's needlessly long format, neglecting good practice in an attempt to be clear to the absolute beginner at anything.

Overall, I was hoping for a lot more out of this book, especially as it was one of the more recently written books and published by the generally decent O'Reilly company.

I am disappointed.

That said, there's still some good information nested in the excessively wordy paragraphs.

As a new user of MySQL with no previous SQL experience I found this book extremely helpful. This book helped me get my project up and running in very little time. I was especially impressed that even though the examples in the book did not directly correlate to what I was trying to accomplish it gave me enough general knowledge of MySQL to easily put together my project.

The 'Learning' series of books by O'Reilly is one of my favorites by far. The thing the separates 'Learning' books from other ones is the fact that these books (for the most part) assume that the reader has a very limited knowledge of said subject matter and ramps them up in logical succession until the point where they are comfortable and developing/designing like a seasoned pro. A 'Learning' book won't make you into an uber pro overnight, but if you are the type that better learns away from the classroom and would rather spend said time (and a lot less money) sitting in front of a computer at home with a book on your lap, you could do a lot less than this O'Reilly line of books.

With 'Learning MySQL' the tradition most definitely continues. ~600 pages await the reader who picks up this gem and you don't need to have any extensive database experience in order to be able to pick this up and start cracking! From the basics of installation on Linux, Windows and the Mac to basic SQL like writing queries and stored procedures, the foundation is all there. Continuing on to discussing security, performing backups and tuning, this is an exceptional book broken up logically and smoothly into 6 parts and 18 chapters:

01. Intro
02. Installing MySQL
03. Using MySQL Monitor
04. Designing Databases
05. Basic SQL
06. Datbase Structures
07. Advanced Querying
08. More MySQL Goodies
09. Managing Users & Privileges
10. Backups & Recovery
11. Using An Options File
12. Configuring & Tuning The Server
13. Web Database Applications
14. PHP
15. PHP Application Case Study
16. Perl
17. Perl With MySQL
18. Serving Perl Pages To The Web

The chapters on PHP and Perl will show you how you can write web apps to interact with your MySQL database and move far beyond the basics or returning tables and rows to the fun you can really have with MySQL!!!

If you are using MySQL for fun or work, this is a great guide for all new/amateur programmers that want to get working efficiently in no time at all!!

***** HIGHLY RECOMMENDED

A range of users are possible for Seyed M.N. Tahaghoghi & Hugh E. Williams's handbook Learning MySQL, from those running a business or keeping membership records to others who are involved in software design. LEARNING MYSQL covers all the basics in introductory chapters - then moves ahead to more advanced uses of SQL, from configuring MySQL for better security to advanced querying. The open source database offers plenty of advanced capabilities but without a book like LEARNING MYSQL, much of these would be lost: all levels need the tutorials herein which guarantee nothing is lost in the cracks.