MySQL: Essential Skills [Paperback]

John Horn (Author), Michael Grey (Author), LLC Interstate Software (Author)

Book Description

Publication Date: June 10, 2004 | ISBN-10: 0072255137 | ISBN-13: 978-0072255133 | Edition: 1

An introductory look into the most popular open source database. Get step-by-step instruction from installing MySQL, manipulating it, and basic reporting, to advanced reporting, interfacing programs, and backups. An accessible introduction to a powerful database, featuring progress checks, exercises, and Ask the Experts sections in each chapter.

Editorial Reviews

From the Back Cover

Fundamentals Made Easy. Get Your MySQL Database Up and Running with Ease

Set up a MySQL database on Windows or Linux with help from this step-by-step beginner’s guide. Learn to design and create a database with tables, load data into your tables, and generate basic and advanced reports. You’ll also get details on how to administer, secure, and back up your database, and import data from other programs. Plus, learn to use PHP for dynamic web pages and MySQL web interfaces. Get started in no time with today’s most popular open source database and take advantage of all the features MySQL database server has to offer.

Designed for Easy Learning:

• Modules--Each concept is divided into logically organized modules (chapters), ideal for self-paced learning
• Critical Skills--Each module opens with the specific skills covered in the module
• Mastery Checks--End-of-module reviews test knowledge using short-answer, multiple-choice, and fill-in-the-blank questions
• Ask the Experts--Q&A sections throughout are filled with bonus information and helpful tips
• Progress Checks--Quick self-assessment sections check your progress
• Projects--Practical exercises show how to apply the critical skills learned in each module

Dr. John W. Horn is a recognized MySQL lecturer and trainer with Interstate Software LLC. Michael Grey is an IT professional, trainer, and writer who provides courseware development for Interstate Software, LLC. Interstate Software is the only gold-level partner with MySQL AB, the commercial MySQL company founded by the creators of the MySQL database server. Interstate Software provides authorized MySQL training and consulting.

About the Author

Dr. John W. Horn is a MySQL trainer at Interstate Software where he trains people like you everyday. Michael Grey is an IT professional and writer who provides courseware development for Interstate Software, Inc.

Product Details

• Paperback: 496 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (June 10, 2004)
• Language: English
• ISBN-10: 0072255137
• ISBN-13: 978-0072255133
• Product Dimensions: 9.4 x 7.4 x 0.8 inches
• Shipping Weight: 1.2 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #998,829 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

11 of 13 people found the following review helpful:

5.0 out of 5 stars Like Having a Personal Tutor, July 9, 2004

By 

Lady Mol (England) - See all my reviews

This review is from: MySQL: Essential Skills (Paperback)

One of the first questions you have to ask is: why a book on MySQL when the MySQL site provides such a comprehensive training instruction? The authors answer this very succinctly: the training manual is almost incomprehensible to anyone coming to MySQL new. I downloaded it and looked at it--they're right, it is!
So, I came to this new book with no knowledge of MySQL but with experience of teaching myself other software from books. This is the clearest and most interesting training manual I've seen for a long time. It started by explaining some of the fundamentals: the difference between open source and proprietary software and how to download the software you've chosen. Every step is accompanied by crisp screen captures and a clear explanation. What I particularly like is that the author gives the impression that she is carrying out the actions at the same time you are, so when faults and problems occur, she's found the same thing and talks you through. It's so refreshing after the number of times I've tried something from other books and not found the result I'm supposed to.
The layout of the pages is particularly pleasing, with a tips section, projects to work though and self-tests to ensure you've grasped the knowledge in each chapter. As a training specialist, I found this book a lesson in the correct use of the principles of training design.
What really made this book stand out for me as something new and different was the example that is used throughout to explain the principles of the database design: a company making clothes for pet ducks. It's so whimsical and amusing; you can't help but romp though the exercises. Who says learning coding can't be fun?
If you want to take your web site to the next level with interactive databases; if you want to learn how to design these powerful databases, then I highly recommend this crisp, clear and well-written book.

8 of 11 people found the following review helpful:

5.0 out of 5 stars Rosetta Stone for MySQL, July 11, 2004

By 

B. McCullough - See all my reviews
(REAL NAME)   

This review is from: MySQL: Essential Skills (Paperback)

The other day I was asked to recommend a book on MySQL, which is one of the many things I am asked to do as a degreed/certified IT professional, but I digress. Knowing that most people have not yet learned the art of tech divination, I set out to find a book that would give a good basic understanding and result in the fewest phone calls for continued help from the database novice in question. While searching for this Rosetta Stone for MySQL, I came across this little gem. I skim all books I think about buying to see if the book is worth it's weight in paper, but this time I ended up reading the first two chapters at the bookshelf. The layout and content of this book is exactly what I would teach someone wanting to start using MySQL, and the computer jargon is kept to a minimum or clearly explained. This book delivers just what it promises: essential skills and a working understanding of MySQL with a bonus of PHP basics.