|
Creating your MySQL Database: Practical Design Tips and Techniques
Ebooks category
MySQL
, eBook Downloads [4106]
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
Sitemap ,
eBooks Link
Add your Link
