Beginning MySQL Database Design and Optimization

From Novice to Professional

By: Jon Stephens, Chad Russell

Write A Review

Paperback | 1 October 2004

At a Glance

Paperback
524 Pages

Dimensions(cm)
22.86 x 17.78 x 3.18

Paperback

$64.99

or 4 interest-free payments of $16.25 with

or

Ships in 5 to 7 business days

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

More in Databases

Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman

$55.75

26%
OFF

SPSS Survival Manual : 7th Edition - A step by step guide to data analysis using IBM SPSS - Julie Pallant

$202.75

12%
OFF

Unleashing User Innovation

Multidisciplinary Perspectives on End-User Development and Generative AI

Hardcover

RRP $292.00

$252.75

13%
OFF

Tokenizing the Future : A Guide to Web3 and the Metaverse - Daniel Trauth

$92.99

Designing Semantic Knowledge Graphs : A Guide to Utilizing Semantic Web Technologies for Agile Data Management - Michael Debellis

$65.75

28%
OFF

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $60.95

$45.75

25%
OFF

The Data Warehouse Toolkit 3ed

The Definitive Guide to Dimensional Modeling

Paperback

RRP $104.95

$67.75

35%
OFF

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Paperback

RRP $34.99

$13.00

63%
OFF

Hands-On Programming with R

Write Your Own Functions and Simulations

Paperback

RRP $76.00

$39.75

48%
OFF

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Paperback

RRP $114.00

$55.75

51%
OFF

Social Research Methods

4th Edition

Paperback

RRP $101.95

$87.75

14%
OFF

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

Paperback

RRP $24.99

$21.75

13%
OFF

About the Authors	p. ix
About the Technical Reviewer	p. xi
Acknowledgments	p. xiii
Introduction	p. xv
Review of MySQL Basics	p. 1
How to Connect to MySQL	p. 2
Identifiers and Naming Conventions	p. 5
Queries Review	p. 14
Summary	p. 43
What's Next	p. 44
MySQL Column and Table Types	p. 45
Why Datatypes Matter	p. 46
MySQL Column Types	p. 48
MySQL Table Types	p. 103
Summary	p. 110
What's Next	p. 112
Keys, Indexes, and Normalization	p. 113
Beyond the Spreadsheet Syndrome	p. 114
Rules for Relational Databases	p. 117
Normalization and Data Modeling	p. 121
Keys, Indexes, and Constraints	p. 134
Common Problems and Errors	p. 164
Summary	p. 169
What's Next	p. 170
Optimizing Queries with Operators, Branching, and Functions	p. 171
Replacing Program Logic with SQL Logic: A Demonstration	p. 172
MySQL Operators	p. 178
MySQL Functions	p. 193
Branching: Making Choices in Queries	p. 231
Our Demonstration Revisited	p. 236
Summary	p. 237
What's Next	p. 237
Joins, Temporary Tables, and Transactions	p. 239
Joins	p. 240
Temporary Tables	p. 263
Transactions	p. 267
Summary	p. 270
What's Next	p. 271
Finding the Bottlenecks	p. 273
Configuration Issues	p. 274
Application Logic	p. 305
Summary	p. 312
What's Next	p. 314
MySQL Programming	p. 315
Overview of MySQL APIs	p. 316
PHP and the mysql Extension	p. 336
PHP 5 and mysqli	p. 351
Perl-DBI	p. 401
Python and MySQLdb	p. 407
Summary	p. 413
What's Next	p. 415
Looking Ahead	p. 417
MySQL 4.1	p. 417
MySQL 5.0	p. 429
MySQL 5.1	p. 481
Other Expected Improvements	p. 484
Summary	p. 486
Index	p. 489
Table of Contents provided by Ingram. All Rights Reserved.

Beginning MySQL Database Design and Optimization

From Novice to Professional

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Python All-in-One For Dummies

3rd Edition

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Handbook of Smart Manufacturing Technologies

Industrial Engineering in the Digital Age

Bioengineering and IoT

Shaping the Future of Healthcare

Unleashing User Innovation

Multidisciplinary Perspectives on End-User Development and Generative AI

Tokenizing the Future

A Guide to Web3 and the Metaverse

Emerging Trends in Information Systems and Technologies

WorldCIST 2025 Volume 2

Neural Information Processing

32nd International Conference, ICONIP 2025, Okinawa, Japan, November 20-24, 2025, Proceedings, Part V

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Designing Semantic Knowledge Graphs

A Guide to Utilizing Semantic Web Technologies for Agile Data Management

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

Microsoft Excel 365 Bible

Bible

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

The Data Warehouse Toolkit 3ed

The Definitive Guide to Dimensional Modeling

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Hands-On Programming with R

Write Your Own Functions and Simulations

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Social Research Methods

4th Edition

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

This product is categorised by