Beginning MySQL Database Design and Optimization: From Novice to Professional

Beginning MySQL Database Design and Optimization: From Novice to Professional
by Chad Russell, Jon Stephens

Beginning MySQL Database Design and Optimization: From Novice to Professional
List Price: $44.99
Our Price: $9.65
You Save: $35.34 (79%)
Availability: Usually ships in 1-2 business days
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Chad Russell, Jon Stephens
Edition: Paperback
Audio: English (Original Language); English (Unknown); English (Published)
Published: 2004-10-18
ISBN: 1590593324
Number of pages: 520
Publisher: Apress
Accessories:

Book Reviews of Beginning MySQL Database Design and Optimization: From Novice to Professional

Book Review: Good for basics, not up-to-date for recent releases
Summary: 4 Stars

As a working professional database developer/DBA, I should have noticed that every other review about this book is at least three years old, most almost four. This book was written to be used with MySQL V4.0, with look-aheads to 4.1 and 5.0. Version 5.0 has been released for almost two years now, and V6 is on the near horizon. A lot has changed in terms of optimization and feature sets. I sincerely hope that the authors will consider updating this work so that it is more current in terms of tuning and features. If you are new to MySQL, use the book as a basis for solid SQL and design principles; if you are more experienced, perhaps just reading and studying the 5.1 and 6.0 docs from MySQL AB would serve you better.

Lee Parmenter, CMA

Summary of Beginning MySQL Database Design and Optimization: From Novice to Professional

Apress has done what many other publishers have failed to do by providing an excellent series of "Novice to Professional" books. This book is pretty much a "must have" for a MySQL programmer looking to bridge the gap between novice and professional.

- Mary Norbury-Glaser, Slashdot Contributor

Beginning MySQL Database Design and Optimization is a great book for MySQL users who already know the basics and want to improve their use of MySQL.

- Mike Hillyer, Mike Hillyer's Personal Web Space

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you're building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it's free; fast, robust, and scalable; and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it's easy to disregard MySQL's speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes.

Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You'll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.

General Books

Book Subjects
Most talked about in PHP
Hardening Apache ImageHardening Apache
by Tony Mobily
Apress; Published: 2004-05-17; Paperback; Book
Best price: $11.54
Price in other shops: $29.99
Pro Apache, Third Edition (Expert's Voice) ImagePro Apache, Third Edition (Expert's Voice)
by Peter Wainwright
Apress; Published: 2004-01-19; Paperback; Book
Best price: $27.99
Price in other shops: $49.99
Apache: The Definitive Guide (3rd Edition) ImageApache: The Definitive Guide (3rd Edition)
by Ben Laurie, Peter Laurie
O'Reilly Media, Inc.; Published: 2002-12; Paperback; Book
Best price: $16.04
Price in other shops: $39.95
Expert MySQL (Expert) ImageExpert MySQL (Expert)
by Dr. Charles A. Bell
Apress; Published: 2007-01-22; Paperback; Book
Best price: $4.97
Price in other shops: $49.99
High Performance MySQL: Optimization, Backups, Replication, and More ImageHigh Performance MySQL: Optimization, Backups, Replication, and More
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling
O'Reilly Media, Inc.; Published: 2008-06-26; Paperback; Book
Best price: $28.45
Price in other shops: $49.99
Pro MySQL (Expert's Voice in Open Source) ImagePro MySQL (Expert's Voice in Open Source)
by Michael Kruckenberg, Jay Pipes
Apress; Published: 2005-07-25; Paperback; Book
Best price: $32.94
Price in other shops: $49.99
Beginning MySQL Database Design and Optimization: From Novice to Professional ImageBeginning MySQL Database Design and Optimization: From Novice to Professional
by Chad Russell, Jon Stephens
Apress; Published: 2004-10-18; Paperback; Book
Best price: $12.90
Price in other shops: $44.99
The Definitive Guide to MySQL 5, Third Edition (Definitive Guide) ImageThe Definitive Guide to MySQL 5, Third Edition (Definitive Guide)
by Michael Kofler
Apress; Published: 2005-09-23; Paperback; Book
Best price: $26.49
Price in other shops: $49.99
Essential PHP Tools: Modules, Extensions, and Accelerators ImageEssential PHP Tools: Modules, Extensions, and Accelerators
by David Sklar
Apress; Published: 2004-03-15; Paperback; Book
Best price: $15.64
Price in other shops: $34.99
PHP Objects, Patterns, and Practice, Second Edition ImagePHP Objects, Patterns, and Practice, Second Edition
by Matt Zandstra
Apress; Published: 2007-12-20; Paperback; Book
Best price: $23.92
Price in other shops: $44.99
Similar Books and other products
PHP 5 Recipes: A Problem-Solution Approach ImagePHP 5 Recipes: A Problem-Solution Approach
by Lee Babin, Nathan A. Good, Frank M. Kromann, Jon Stephens
Apress; Published: 2005-09-23; Paperback; Book
Best price: $31.38
Price in other shops: $44.99
MySQL Crash Course (Sams Teach Yourself in 10 Minutes) ImageMySQL Crash Course (Sams Teach Yourself in 10 Minutes)
by Ben Forta
Sams; Published: 2005-12-22; Paperback; Book
Best price: $14.83
Price in other shops: $24.99
MySQL Database Design and Tuning (Developer's Library) ImageMySQL Database Design and Tuning (Developer's Library)
by Robert D Schneider
MySQL Press; Published: 2005-06-23; Paperback; Book
Best price: $26.94
Price in other shops: $49.99
MySQL Stored Procedure Programming ImageMySQL Stored Procedure Programming
by Guy Harrison, Steven Feuerstein
O'Reilly Media, Inc.; Published: 2006-03-28; Paperback; Book
Best price: $24.98
Price in other shops: $44.99
High Performance MySQL ImageHigh Performance MySQL
by Jeremy D. Zawodny, Derek J. Balling
O'Reilly Media, Inc.; Published: 2004-04-08; Paperback; Book
Best price: $18.97
Price in other shops: $39.95
MySQL Cookbook ImageMySQL Cookbook
by Paul DuBois
O'Reilly Media, Inc.; Published: 2007-01-27; Paperback; Book
Best price: $29.35
Price in other shops: $49.99
Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional) ImageBeginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional)
by W. Jason Gilmore
Apress; Published: 2008-03-24; Paperback; Book
Best price: $26.50
Price in other shops: $46.99
The Definitive Guide to MySQL 5, Third Edition (Definitive Guide) ImageThe Definitive Guide to MySQL 5, Third Edition (Definitive Guide)
by Michael Kofler
Apress; Published: 2005-09-23; Paperback; Book
Best price: $28.99
Price in other shops: $49.99
Beginning Database Design: From Novice to Professional ImageBeginning Database Design: From Novice to Professional
by Clare Churcher
Apress; Published: 2007-01-15; Paperback; Book
Best price: $21.91
Price in other shops: $34.99
Pro MySQL (Expert's Voice in Open Source) ImagePro MySQL (Expert's Voice in Open Source)
by Michael Kruckenberg, Jay Pipes
Apress; Published: 2005-07-25; Paperback; Book
Best price: $30.00
Price in other shops: $49.99
Book store. Illustrated catalog of books on different categories