This book is a quick guide to the innovative and important for everyone on how the data structure and set-up MySQL database tables efficiently and easily. If you create a dynamic web applications using open source tools, then you may make a MySQL database and you definitely need this book. Getting the exact design of this database for your applications and critical data, but this is often intimidating and little-known process for non-developers and developers alike.
Written by the creator of the popular phpMyAdmin tool, this book is brief but complete guide on how to design good data structures for MySQL. For most of us, setting up a database for the application are often outdated. While you do not have to be a professional database designer to create a working application, knowing a little insider tips and techniques can make the process easier and the end result is much more effective. This book does not set out to make you an expert in data analysis, but does not provide a quick and easy way to improve your game in an important part to get your application correctly.
Book covers: Asking users the right questions to gather 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 producing documentation of system performance (data dictionary, relational schema) Testing the model with appropriate SQL queries This book takes a practical approach, implementing all theoretical concepts with examples. This is a quick tutorial that focuses on important decisions you need to make every time you build MySQL database. It is rich with tips and advice from an experienced physician.
This book is ideal for anyone working with applications that use MySQL database backend will benefit greatly from the advice and techniques in this book. Although knowledge of both SQL and MySQL are assumed, the book is suitable for beginners and intermediate users alike. Did you read it and absorb the advice or work through it on a live project, efficiency and maintenance of your database will inevitably increase 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
0 comments:
Post a Comment