Beginning MySQL Database Design and Optimization

From Novice to Professional

Authors: Russell, Chad, Stephens, Jon

Download source code

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-0729-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $44.99
price for USA
  • ISBN 978-1-59059-332-5
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

Chad Russell is a programmer and network administrator who owns his own Internet hosting company. He previously has written on MySQL, PHP, and other topics.

Table of contents (8 chapters)

  • Review of MySQL Basics

    Stephens, Jon (et al.)

    Pages 1-44

  • MySQL Column and Table Types

    Stephens, Jon (et al.)

    Pages 45-112

  • Keys, Indexes, and Normalization

    Stephens, Jon (et al.)

    Pages 113-170

  • Optimizing Queries with Operators, Branching, and Functions

    Stephens, Jon (et al.)

    Pages 171-238

  • Joins, Temporary Tables, and Transactions

    Stephens, Jon (et al.)

    Pages 239-271

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-0729-0
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $44.99
price for USA
  • ISBN 978-1-59059-332-5
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Beginning MySQL Database Design and Optimization
Book Subtitle
From Novice to Professional
Authors
Copyright
2004
Publisher
Apress
Copyright Holder
Jon Stephens and Chad Russell
eBook ISBN
978-1-4302-0729-0
DOI
10.1007/978-1-4302-0729-0
Softcover ISBN
978-1-59059-332-5
Edition Number
1
Number of Pages
XX, 520
Number of Illustrations and Tables
281 b/w illustrations
Topics