Track My Order
Help Centre
1300 187 187
Likes
My Wish ListsLogin / Join
Booktopia
Australia's local bookstore
Beginning MySQL Database Design and Optimization : From Novice to Professional - Jon Stephens

Beginning MySQL Database Design and Optimization

From Novice to Professional

By: Jon Stephens, Chad Russell

Paperback | 1 October 2004

At a Glance

Paperback

RRP $64.99

$57.50

12%OFF

or 4 interest-free payments of $14.38 with

 or 

Aims to ship in 7 to 10 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.

You Can Find This Book In

Non-FictionComputing & I.T.DatabasesDatabase Design & TheoryComputer Programming & Software DevelopmentDatabase ProgrammingSoftware Engineering

More in Databases

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

Python All-in-One For Dummies

3rd Edition

Paperback

RRP $74.95

$50.35

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

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $60.95

$41.75

32%
OFF
Data Analytics for Accounting ISE : 3rd Edition - Vernon Richardson

Data Analytics for Accounting ISE

3rd Edition

Paperback

RRP $159.95

$133.90

16%
OFF
Learning Spark : Lightning-Fast Data Analytics - Jules S. Damji

Learning Spark

Lightning-Fast Data Analytics

Paperback

RRP $152.00

$69.80

54%
OFF
SQL Tuning : O'Reilly Ser. - Dan Tow

SQL Tuning

O'Reilly Ser.

Paperback

RRP $60.80

$29.25

52%
OFF
Information Modeling and Relational Databases : 2nd Edition - Terry Halpin

Information Modeling and Relational Databases

2nd Edition

Hardcover

RRP $108.95

$74.95

31%
OFF
Python in a Nutshell : A Desktop Quick Reference - Alex Martelli

Python in a Nutshell

A Desktop Quick Reference

Paperback

RRP $136.80

$59.90

56%
OFF

This product is categorised by

Popular Searches