Print Book $44.99
Safari Books Online
Print Book £31.99
Looking to Reprint this content?
By Seyed M.M. "Saied" Tahaghoghi, Hugh E. Williams
November 2006
Pages: 618
ISBN 10: 0-596-00864-3 |
ISBN 13: 9780596008642
(Average of 4 Customer Reviews)
Learning MySQL provides all the tools you need to set up and design an effective database. This richly detailed tutorial will help you design scalable and flexible databases, create powerful queries using SQL, and configure MySQL for improved security. After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.
Full Description
- Which are my top ten fastest-selling products?
- How frequently does this person come to our facility?
- What was the highest, lowest, and average score of the team last season?
MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and Learning MySQL provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.
After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.
Topic include:
- Installation on Linux, Windows, and Mac OS X
- Basic and advanced querying using SQL
- User management and security
- Backups and recovery
- Tuning for improved efficiency
- Developing command-line and web database applications using the PHP and Perl programming languages
The authors, Saied Tahaghoghi and Hugh E. Williams, have careers in academia and business, and share a keen interest in research into search technologies.
Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in Learning MySQL that will last a career.
Cover | Table of Contents | Colophon
Featured customer reviews
Very Good, April 01 2008
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!
A book to avoid?, March 04 2008
If you are a web developer looking to get started working with MySQL as your back-end database, you’re probably better off getting a book which is focused on your language of choice.
If you are an experienced database developer or DBA, you’re probably better off Google-ing around or just lurking on the MySQL DEV website (http://dev.mysql.com/). This book won’t teach you anything you don’t know (or can’t find elsewhere).
If you are a novice web/DB developer, and you purchase this book, proceed with caution. I found the book to be incomplete; there is no mentioning of stored procedures, minimal discussion around transactions (what about SAVEPOINTs?), and when in Chapter 8 “Doing More with MySQL” the authors mention the use of functions “to meet more complex information needs” they mention only the RAND() function?! What about IFNULL()/NULLIF() , CASE… just to name a few.
I also found a few “accidents waiting to happen”: when teaching about creating indexes, why would one want to DROP the table you’re working with and recreate it with a “KEY” (pages 204-5) and only introduce the ALTER TABLE/ADD INDEX on page 217. Read (to the end) before you execute!
If you bought this book, you should probably buy MySQL Stored Procedure Programming By Guy Harrison, Steven Feuerstein (O'Reilly) to get a better picture of MySQL.
Defeated by a bad index, June 01 2007
The text of the book is clear and informative, however I keep getting bamboozled by the index. I look for things in the index that I know are in the book, and I can't find them. This means that the book is a decent tutorial, but falls down as a reference book.
Not bad, but not best out there, February 27 2007
This is a good book, maybe as a reference. The first 3 or 4 chapters are vital reading. A bit dry though, who only works on a database without any other software? This isn't 1980.
None the less, if you're learning PHP, Rails or what have you, this needs to be on your bookshelf.
It does answer some questions about MySQL that never get answered elsewhere.
Media reviews
"If you only get one book on mySQL then get this one because it has everything you need...It is not often that you find a technical book that has the depth of coverage and logical structure that can be found in this one."
-- Stephen Chapman, Felgall.com
"...a useful guide for getting started with the elementary uses of MySQL as a database...The book covers all aspects that would be of use to the beginner user of MySQL as well as giving the useful tips to the already experienced users of this popular database."
-- Ganadeva Bandyopadhyay, Desicritics.org
"If you are wanting to learn how to work with databases and feel intimidated, Learning MySQL may be just the ticket. It is well written, easy to understand and develops in a logical, easy to follow manner. By the time you get through the book, you will have a good overview of SQL databases in general."
-- T. Michael Testi, Blogcritics.org
Read all reviews
Got a Question?
"If you only get one book on mySQL then get this one because it has everything you need."
--
 © 2008, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly Privacy Policy Contacts Authors Press Room Jobs User Groups Academic Solutions Newsletters Writing for O'Reilly RSS Feeds |
Other O'Reilly Sites O'Reilly Radar Ignite Tools of Change for Publishing Digital Media makezine.com craftzine.com hackzine.com perl.com xml.com |
Sponsored Sites Inside Aperture Inside iPhone Inside Lightroom Inside Port 25 InsideRIA |