Learn the fundamental concepts underlying database system design, including applications using databases and the implementation techniques used in database systems.
Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Overview
Syllabus
Introduction
- Designing and implementing a data model
- What you should know
- 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
- Entities and relationships
- Cardinalities
- Scoping the database requirements
- Analyzing the overall data requirements
- Connecting entities, relationships, and business rules
- Identifying data integrity requirements
- 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
- Overview of MySQL Workbench
- Creating entities in MySQL Workbench
- Creating relationships in MySQL Workbench
- Confirming identifying and non-identifying relationships
- Creating the database schema
- Overview of the SELECT statement
- Another toy dataset
- SELECT-FROM clauses
- SELECT-FROM-WHERE clauses
- GROUP BY and ORDER BY clauses
- Bringing it all together
- Final project: The Brainery
- Next steps
Taught by
Dr. Brandeis Marshall
