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 promiseangels.com!
Est. Packaging Dimensions: Length: 9" Width: 7.2" Height: 0.3" Weight: 0.4 lbs.
Release Date Nov 25, 2006
Publisher Packt Publishing
ISBN 1904811302 ISBN13 9781904811305
Availability 139 units. Availability accurate as of Mar 27, 2017 10:49.
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
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.
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.