Practical Database Design: Implementing Responsible Data Solutions with SQL Querying

Learn the fundamental concepts underlying database system design, including applications using databases and the implementation techniques used in database systems.

Introduction

• Designing and implementing a data model
• What you should know

1. Business Rule Development

• How databases help businesses
• The DIKW Model
• What's a business rule?
• A business rule vs. a business operation
• A business rule vs. a business practice
• A business rule vs. a business policy
• Example business rules

2. Database Design

• Entities and relationships
• Cardinalities
• Scoping the database requirements
• Analyzing the overall data requirements
• Connecting entities, relationships, and business rules
• Identifying data integrity requirements

3. Data Generation and Datasets

• The data you're given: Now what?
• Asking questions of the data
• The data you're creating: Pros and cons
• Asking questions of your made-up data

4. Database Implementation

• Overview of MySQL Workbench
• Creating entities in MySQL Workbench
• Creating relationships in MySQL Workbench
• Confirming identifying and non-identifying relationships
• Creating the database schema

5. SQL Querying

• Overview of the SELECT statement
• Another toy dataset
• SELECT-FROM clauses
• SELECT-FROM-WHERE clauses
• GROUP BY and ORDER BY clauses

6. Final Project

• Bringing it all together
• Final project: The Brainery

Conclusion

• Next steps