Introduction
- Who should read this book?
- Why this book?
- Chapter Guide
- Supplemental Files & Errata
- I want to hear from YOU!
Chapter I: Databases – In Theory and Everyday Life
- What is a Database?
- Everyday Database Examples
- Types of Databases
- Text files – Data Exchange and Basic Storage
- Mobile Databases – Smartphones, Tablets and the Web
- Desktop Database Software – Local Analysis
- Server Databases – Organizational Data and Enterprise Applications
- Cloud Databases – Outsourced Data Storage
- Chapter Summary
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
- Links
Chapter II: Choosing and Installing MySQL
- Why Choose MySQL?
- Notable Features of MySQL
- What is the GNU General Public License and Open Source?
- Installing MySQL and Creating an AMP Environment
- A Word on Virtual Machines
- Installing MySQL on Linux
- Installing MySQL on Windows
- Additional Resources
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
- Links
Chapter III: Database Design – The First Steps
- Creating a Model
- Formal vs. Informal Data Modeling
- Example Database – Job Search Plus
- Data Concepts and Relationships
- Filling in the Details
- Defining the Tables
- Chapter Summary
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
Chapter IV – Database Normalization
- From Design to Reality
- Looking Back
- The Normalization Process
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Boyce-Codd Normal Form (BCNF or 3.5NF)
- Additional Reasons for Normalization
- Application Specific Reasons
- Data or Database?
- Chapter Summary
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
Chapter V – Servers and Databases
- Building the Database
- Accessing the Server
- Creating Databases
- Database Users and Security
- For Further Study
- Review Questions
- Terms to Remember
Chapter VI – Tables and Indexes
- Introduction
- Storage Engines
- Models and Schemas
- MySQL Workbench
- Getting Started
- Executing Queries
- Creating the Tables
- Linking the Tables
- Documenting the Database
- Chapter Summary
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
Chapter VII – Reading and Writing the Data
- Structured Query Language
- Beginning Examples
- Adding Data to the System
- Executing Commands
- Trying This At Home
- SQL Basics
- Selecting Data
- Inserting Data
- Updating Data
- Deleting Data
- Chapter Summary
- For Further Study
- Review Questions
- Exercises
- Terms to Remember
Chapter VIII – Design Overview: Human Resources and Training Database
- Introduction
- Modeling the Data
- Conceptual
- Adding Details
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Many-to-Many Relationships
- Third Normal Form (3NF) and Boyce-Codd (BCNF)
- Design Notes
- Expansions
- Creating the Tables
- Writing the SQL
- Conclusion
- For Further Study
- Exercises
Chapter IX – Design Overview: Recipe Database
- Introduction
- Modeling the Data
- Design Notes
- Working Diagram
- Writing the SQL
- Populating the Tables
- Basic Queries
- Custom Searches
- For Further Study
- Exercises
Chapter X – User Interfaces
- Beyond the Database
- Website Design Tools
- WordPress and other Content Management Systems
- CiviCRM
- Desktop Interfaces
- Connecting to MySQL from the Desktop
- OpenOffice / LibreOffice
- Microsoft Access
- Designing From Scratch
- PHP
- ASP.NET (C# / Visual Basic)
- Java
- Supplemental Languages
- Chapter Summary
- For Further Study
- Review Questions
- Terms to Remember
Responses