Customer Reviews

Learning MySQL

5 star:		(10)
4 star:		(4)
3 star:		(0)
2 star:		(1)
1 star:		(1)

 

 

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

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.

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.

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.

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.

The book is terrific. It starts from the basics, establishes a foundation, then begins to build up from there. It is well written with lots of examples that show the input and the expected output.

A separate word of thanks to the publisher. Unlike so many other publishers that make books available for Kindle, this publisher included "Page Numbers" on the pages. Lessor publishers just have the "Location" number which has no practical purpose.

Having pages numbers makes it possible to assist people that are using the physical books.

This book is divided into two principal parts. The first covers installing MySQL, some principles of database schema design, and the syntax of all the SQL statements that most users are likely to encounter (or need). If you follow the examples in the book, you will also become well-acquainted with the MySQL CLI. This is an indispenable skill if you will be managing a production server or debugging an application problem (and need to peek at the data through the eyes of an unbiased, third party).

The second part shifts gears and discusses writing web applications in PHP and Perl that interface with MySQL databases. If I could choose, I would trade this part for more discussion on database performance analysis and optimization. The subject is approached in the first part, but not in any depth. I have purchased a copy of _High Performance MySQL_ (2nd Edition; O'Reilly) and after a brief skim, that book may be the one to address those issues.

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.

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).

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!