Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 10, 2014

    Peter Turchi: IMG Writing as Puzzle



    I loved books, loved stories, loved being read to at an early age and then reading for myself — that's true for most writers. But looking... Continue »
    1. $20.97 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$44.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Beginning MySQL Database Design and Optimization: From Novice to Professional (Beginning: From Novice to Professional)

by

Beginning MySQL Database Design and Optimization: From Novice to Professional (Beginning: From Novice to Professional) Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

"MySQL Database Design and Optimization" 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.

Synopsis:

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically realized using a database. For open source and many other projects, the MySQL database is a very popular choice: it's free; it's fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, it's easy to throw away 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 efficient, single query are some of the common mistakes. MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you're building or maintaining any significant application and are using MySQL, this book is for you.

Table of Contents

Introduction.- Review of MySQL Basics.- Keys, Indexes, and Normalization.- Operators, Functions and Branching.- Joins, Temporary Tables, and Transactions.- Finding the Bottlenecks.- Looking Ahead to MySQL 4 - 1 and MySQL 5.

Product Details

ISBN:
9781590593325
Author:
Stephens, Jon
Publisher:
Apress
Author:
Russell, Chad
Subject:
Programming - General
Subject:
Database Management - General
Subject:
Database design
Series:
Beginning: From Novice to Professional
Publication Date:
20041031
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
500
Dimensions:
9.38x7.02x1.10 in. 1.80 lbs.

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management

Beginning MySQL Database Design and Optimization: From Novice to Professional (Beginning: From Novice to Professional) New Trade Paper
0 stars - 0 reviews
$44.99 In Stock
Product details 500 pages Apress - English 9781590593325 Reviews:
"Synopsis" by , "MySQL Database Design and Optimization" 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.
"Synopsis" by , Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically realized using a database. For open source and many other projects, the MySQL database is a very popular choice: it's free; it's fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, it's easy to throw away 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 efficient, single query are some of the common mistakes. MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you're building or maintaining any significant application and are using MySQL, this book is for you.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.