Creating your MySQL Database: Practical Design Tips and Techniques
Ebooks category
MySQL
File size
1.18 MB
, eBook Downloads [442]
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
|
RSS,
Feed
eBooks Space Blog
Sitemap ,
eBooks Link
Add your Link
 _2008_05_30_10_53_40.jpg)
