Newsletter   Secure Checkout   View Cart (0 items)  
Search:    Welcome Guest! Save up to 30-40% on most items with our awesome everyday discounts!

Creating your MySQL Database: Practical Design Tips and Techniques [Paperback]

Our Price $ 20.79  
Item Number 270624  
Buy New $20.79
Available on the Internet only.

Item description for Creating your MySQL Database: Practical Design Tips and Techniques by Marc DeLisle...

This book is an innovative and essential short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike. Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL.

For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.

The book covers:
- Asking users the right questions to collect relevant data for the system you are building
- Detecting bad structures
- Sound data-naming techniques for both table and column names
- Modeling data with future growth in mind
- Implementing security policies with data privileges and views
- Tuning the structure for performance
- Producing system documentation (data dictionary, relational schema)
- Testing the model with appropriate SQL queries

This book takes a practical approach, implementing all theoretical concepts with examples. It is a fast-paced tutorial that focuses on critical decisions that you need to make every time you build MySQL databases. It is rich with tips and advice from an experienced practitioner. The book is ideal for anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result.

Chapter 1: Introduction
Chapter 2: Data Collection
Chapter 3: Data Naming
Chapter 4: Data Grouping
Chapter 5: Data Structure Tuning
Chapter 6: Case Study: An Airline System

Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at!

Item Specifications...

Pages   108
Est. Packaging Dimensions:   Length: 9" Width: 7.2" Height: 0.3"
Weight:   0.4 lbs.
Binding  Softcover
Release Date   Nov 25, 2006
Publisher   Packt Publishing
ISBN  1904811302  
ISBN13  9781904811305  

Availability  139 units.
Availability accurate as of May 23, 2017 06:48.
Usually ships within one to two business days from La Vergne, TN.
Orders shipping to an address other than a confirmed Credit Card / Paypal Billing address may incur and additional processing delay.

More About Marc DeLisle

Register your artisan biography and upload your photo! Marc is a system administrator at Cegep de Sherbrooke, Quebec, Canada. He has been teaching networking, security, and web application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children. The original edition of this book, Mastering phpMyAdmin for Effective MySQL Management, was Marc's first book and was followed by Creating your MySQL Database: Practical Design Tips and Techniques, also with Packt Publishing.

Are You The Artisan or Author behind this product?
Improve our customers experience by registering for an Artisan Biography Center Homepage.

Product Categories

1Books > Subjects > Computers & Internet > Databases > General
2Books > Subjects > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
3Books > Subjects > Computers & Internet > Databases > Specific Databases > SQL > General

Reviews - What do customers think about Creating your MySQL Database: Practical Design Tips and Techniques?

It just kinda let down halfway through  Jul 23, 2008
This book starts off with a real bang, working you through the logic of how you would structure your data in a MySQL database. It works through two examples, a car dealership's needs for tracking the details about particular cars and their sales, and then a simplistic schema for storing airline flight information. About halfway through this book, you feel like you're really learning a lot of information, and then the second half just seems to mainly cough out some table definitions. I can't quite put my finger on exactly what went wrong about halfway through, but that's about the point where I felt like I stopped learning from this book and was just reading the remainder of what the author wanted to get regurgitated before he hit his page limit.
You probably won't come away from reading this book with any more confidence in your ability to structure the tables of a database than before you started reading it. Some good info. Overall - disappointing.
Light on content and value  Jun 23, 2008
In a nutshell, this book is pretty worthless. Potential readers would be much better off with the "MySQL Tutorial" book.

Write your own review about Creating your MySQL Database: Practical Design Tips and Techniques

Ask A Question or Provide Feedback regarding Creating your MySQL Database: Practical Design Tips and Techniques

Item Feedback and Product Questions
For immediate assistance call 888.395.0572 during the hours of 10am thru 8pm EST Monday thru Friday and a customer care representative will be happy to help you!

Help us continuously improve our service by reporting your feedback or questions below:

I have a question regarding this product
The information above is incorrect or conflicting
The page has misspellings or incorrect grammar
The page did not load correctly in my browser or created an error.

Email Address:
Anti Spam Question. To combat spammers we require that you answer a simple question.
What color is the sky?
Leave This Blank :
Do Not Change This Text :

Add This Product Widget To Your Website

Looking to add this information to your own website? Then use our Product Widget to allow you to display product information in a frame that is 120 pixels wide by 240 pixels high.

    Copy and paste the following HTML into your website and enjoy!

Order toll-free weekdays 10am thru 10pm EST by phone: 1-888-395-0572 (Lines are closed on holidays & weekends.)
Customer Service | My Account | Track My Orders | Return Policy | Request Free Catalog | Email Newsletter

Gift Certificates
RSS Feeds
About Us
Contact Us
Terms Of Use
Privacy Policy