Creating your MySQL Database Practical Design Tips and Techniques 1st Edition by Marc Delisle ISBN 1847190200 9781847190208

Creating your MySQL Database: Practical Design Tips and Techniques 1st Edition by Marc Delisle – Ebook PDF Instant Download/Delivery. 1847190200, 9781847190208
Full download Creating your MySQL Database: Practical Design Tips and Techniques 1st Edition after payment

Product details:

ISBN 10: 1847190200
ISBN 13: 9781847190208
Author: Marc Delisle

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. 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.

Creating your MySQL Database: Practical Design Tips and Techniques 1st Table of contents:

1. Introducing MySQL Design
MySQL’s Popularity and Impact
The Need for MySQL Design
“What do I do Next?”
Data Design Steps
Data as a Resource
But this is my Data!
Data Modeling
Overview of the Relational Model
Rule #1
Rule #2
Simplified Design Technique
Case Study
Our Car Dealer
The System’s Goals
The Tale of the Too Wide Table
Summary
2. Data Collecting
System Boundaries Identification
Modular Development
Model Flexibility
Document Gathering
General Reading
Forms
Existing Computerized Systems
Interviews
Finding the Right Users
Perceptions
Asking the Right Questions
Existing Information Systems
Chronological Events
Sources and Destinations
Urgency
Avoid Focusing on Reports and Screens
Data Collected for our Case Study
From the General Manager
From the Salesperson
From the Store Assistant
Other Notes
Summary
3. Data Naming
Data Cleaning
Subdividing Data Elements
Data Elements Containing Formatting Characters
Data that are Results
Data as a Column’s or Table’s Name
Planning for Changes
Pitfalls of the Free Fields Technique
Naming Recommendations
Designer’s Creativity
Abbreviations
Clarity versus Length: an Art
Suffixing
The Plural Form
Naming Consistency
MySQL’s Possibilities versus Portability
Table Name into a Column Name
Summary
4. Data Grouping
Initial List of Tables
Rules for Table Layout
Primary Keys and Table Names
Data Redundancy and Dependency
Composite Keys
Improving the Structure
Scalability over Time
Empty Columns
Avoiding ENUM and SET
Multilingual Planning
Validating the Structure
Summary
5. Data Structure Tuning
Data Access Policies
Responsibility
Security and Privileges
Views
Storage Engines
Foreign Key Constraints
Performance
Indexes
Helping the Query Optimizer: Analyze Table
Accessing Replication Slave Servers
Speed and Data Types
Table Size Reduction
In-Column Data Encoding
Case Study’s Final Structure
Vehicle
Person
Sale
Other tables
Summary
6. Supplemental Case Study
Results from the Document Gathering Phase
Preliminary List of Data Elements
Tables and Sample Values
Code Tables
Themed Tables
Composite-Key Tables
Airline System Data Schema
Sample Queries
Inserting Sample Values
Boarding Pass
Passenger List
All Persons on a Flight

People also search for Creating your MySQL Database: Practical Design Tips and Techniques 1st:

    
creating your mysql database practical design
    
creating a mysql database from scratch
    
creating your own database
    
mysql database design tutorial
    
database design youtube