Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
2h 16mIntermediate2024-06-25
Authors
Dr. Brandeis Marshall
Course details
In this hands-on course, learn the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. Instructor Brandeis Marshall takes you through a practical application of database design, database implementation, and data querying to determine when SQL querying is more appropriate. Learn how to develop effective SQL queries and leverage SQL as part of your responsible/ethical data practices. Brandeis takes you through the full arc of a database project, and finishes the course with a project that lets you apply all you’ve learned.
Skills covered
Data Resource ManagementSQLDatabase AdministrationData EngineeringDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
Introduction
- Designing and implementing a data model
- What you should know
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
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
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
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
SQL Querying
- Overview of the SELECT statement
- Another toy dataset
- SELECT-FROM clauses
- SELECT-FROM-WHERE clauses
- GROUP BY and ORDER BY clauses
Final Project
- Bringing it all together
- Final project - The Brainery
Conclusion
- Next steps