文档介绍：Creating your
Creating your MySQL Database:
Practical Design Tips and MySQL
Techniques Database
The popularity of MySQL and phpMyAdmin has brought many non-IT specialists to the
field of database design, usually with a view to building a dynamic website with a MySQL
back end. Most users would be interested mainly in developing a functional website, but : Practical Design
would have little interest in learning about good practices in designing their MySQL
databases. One reason is that MySQL design is seen as an advanced plex topic
that requires a lot of time, which most people would not be able to afford or just would not
care to invest. This book attempts to e this barrier, which is both perceptional and
real, by positioning itself as a fast and easy way to learn the most important aspects of
MySQL database design. T
i
ps and
What you will learn from this book
T
• Asking users the right questions when collecting relevant data for the system you echniques
are building From Technologies to Solutions
• Detecting bad structures
• Sound data naming techniques, both for table and column names
• Modeling data with future growth in mind
• Implementing security policies with data privileges and views Creating your
• Tuning the structure for performance
• Producing system documentation (data dictionary, relational schema)
• Testing the model with appropriate SQL queries MySQL Database
Who this book is written for
Marc Delisle Practical Design Tips and Techniques
This book is for new web developers and MySQL database administrators who want to learn
how to build better data structures. A basic understanding of MySQL and SQL is assumed.
A short guide for everyone on how to structure their data and
$ US Packt Publishing set up their MySQL database tables efficiently and easily
£ UK Birmingham - Mumbai
€ EU
Prices do not include
local sales tax or VAT
where applicable Marc Delisle
Creating y