Product Details
Learning MySQL

Learning MySQL
By Seyed M.M. (Saied) Tahaghoghi, Hugh Williams

List Price: $44.99
Price: $29.69 & eligible for FREE Super Saver Shipping on orders over $25. Details

Availability: Usually ships in 24 hours
Ships from and sold by Amazon.com

46 new or used available from $9.93

Average customer review:

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.

Product Details

  • Amazon Sales Rank: #233180 in Books
  • Published on: 2006-11-01
  • Released on: 2006-11-14
  • Original language: English
  • Number of items: 1
  • Binding: Paperback
  • 618 pages

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

About the Author

Williams is a senior lecturer, specializing in database and web technology, in the School of Computer Science ant IT at RMIT University in Melbourne, Australia.

Customer Reviews

MySQL Class In A Book5
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

Excellent starting point for a new user5
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.

All levels need the tutorials herein which guarantee nothing is lost in the cracks.5
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.