Learning MySQL (Paperback)

~ Seyed M.M. (Saied) Tahaghoghi (Author), Hugh Williams (Author)
Key Phrases: configuring access, user security policy, red right hand, New Order, Miranda Sawyer, Bobby Gillespie (more...)

Editorial Reviews

Review

"I recommend Tahaghoghi and Williams' Learning MySQL as an introduction to database solutions, especially as applied to web development. Buy this book and you won't be disappointed." - James Pyles, Linux Magazine, March 2007

Product Description

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as: 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.

See all Editorial Reviews

Product Details

• Paperback: 618 pages
• Publisher: O'Reilly Media (November 14, 2006)
• Language: English
• ISBN-10: 0596008643
• ISBN-13: 978-0596008642
• Product Dimensions: 9.1 x 7 x 1.3 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (12 customer reviews)
• Amazon.com Sales Rank: #84,737 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #18 in	Books > Computers & Internet > Databases > Relational Databases
  #22 in	Books > Computers & Internet > Databases > Data Warehousing
  #23 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL

• This item is part of The O'Reilly Learning Series.

Customer Reviews

Most Helpful Customer Reviews

27 of 29 people found the following review helpful:

5.0 out of 5 stars MySQL Class In A Book, April 18, 2007

By	Daniel McKinnon (Tewksbury, MA USA) - See all my reviews (TOP 500 REVIEWER)

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

12 of 13 people found the following review helpful:

5.0 out of 5 stars Excellent starting point for a new user, July 28, 2007

By	Joe Johnson - See all my reviews (REAL NAME)

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.

10 of 12 people found the following review helpful:

5.0 out of 5 stars All levels need the tutorials herein which guarantee nothing is lost in the cracks., February 2, 2007

By	Midwest Book Review (Oregon, WI USA) - See all my reviews

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.