Skip to content

Beginning MySQL Database Design and Optimization

Spend $50 to get a free DVD!

ISBN-10: 1590593324

ISBN-13: 9781590593325

Edition: 2004

Authors: Chad Russell, Jon Stephens

List price: $44.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
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.
Customers also bought

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