Beginning MySQL Database Design and Optimization

Name: Beginning MySQL Database Design and Optimization
Price: 8.73 USD
Availability: InStock
ISBN: 9781590593325

ISBN-10: 1590593324

ISBN-13: 9781590593325

Edition: 2004

Authors: Chad Russell, Jon Stephens

List price: $44.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $8.73

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

This work shows readers how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in.

Book details

List price: $44.99
Copyright year: 2004
Publisher: Apress L. P.
Publication date: 10/27/2004
Binding: Paperback
Pages: 520
Size: 7.00" wide x 9.00" long x 1.25" tall
Weight: 1.804
Language: English



About the Authors


About the Technical Reviewer


Acknowledgments


Introduction



Review of MySQL Basics


How to Connect to MySQL


Identifiers and Naming Conventions


Queries Review


Summary


What's Next



MySQL Column and Table Types


Why Datatypes Matter


MySQL Column Types


MySQL Table Types


Summary


What's Next



Keys, Indexes, and Normalization


Beyond the Spreadsheet Syndrome


Rules for Relational Databases


Normalization and Data Modeling


Keys, Indexes, and Constraints


Common Problems and Errors


Summary


What's Next



Optimizing Queries with Operators, Branching, and Functions


Replacing Program Logic with SQL Logic: A Demonstration


MySQL Operators


MySQL Functions


Branching: Making Choices in Queries


Our Demonstration Revisited


Summary


What's Next



Joins, Temporary Tables, and Transactions


Joins


Temporary Tables


Transactions


Summary


What's Next



Finding the Bottlenecks


Configuration Issues


Application Logic


Summary


What's Next



MySQL Programming


Overview of MySQL APIs


PHP and the mysql Extension


PHP 5 and mysqli


Perl-DBI


Python and MySQLdb


Summary


What's Next



Looking Ahead


MySQL 4.1


MySQL 5.0


MySQL 5.1


Other Expected Improvements


Summary


Index