Relational Data Modeling
Course description
Read more about the course
Besides performance, the relational model must ensure data quality and integrity—through the use of constraints, primary and foreign keys, validation, and relationships between tables.
What you will learn:
How to design and read a data model
You will get acquainted with three levels of relational modeling: conceptual, logical, and physical models. We will go through the entire process—from defining entities and attributes to building tables and relationships between them using keys and constraints.
Normalization from 0NF to 3NF
You will learn how to normalize data to avoid duplication and enhance integrity. We will step through the first, second, and third normal forms and explain how to apply them when building a database.
Deploying a MySQL server using Docker
In practice, you will learn to deploy MySQL as a container using Docker. We will also discuss alternative approaches, including local installations and cloud services.
Working with MySQL Workbench
You will install and use MySQL Workbench—one of the most popular GUI clients for working with MySQL. As part of the practice, you will create an ER diagram of a database using built-in modeling tools.
This course is an excellent start for those who want to think in terms of data structure, design databases “smartly,” and use best modeling practices.
Watch Online
All Course Lessons (17)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Introduction Demo | 02:03 | |
| 2 | Goals of the course | 03:40 | |
| 3 | Relational data models history | 03:17 | |
| 4 | Installing MySQL server and MySQL Workbench | 08:05 | |
| 5 | MySQL Workbench introduction | 04:37 | |
| 6 | The design process explained | 04:15 | |
| 7 | Discover the entities | 10:25 | |
| 8 | Discover the attributes | 13:10 | |
| 9 | Define entity relationships and normalize the data | 11:20 | |
| 10 | Identifying vs non-dentifying relationship | 02:02 | |
| 11 | How to resolve many-to-many relationships | 04:01 | |
| 12 | How to resolve one-to-many relationships | 02:35 | |
| 13 | How to resolve one-to-one relationships | 01:46 | |
| 14 | Create your ER diagram using workbench | 19:47 | |
| 15 | Create a physical data model | 04:14 | |
| 16 | Populate the mysql db with data from a .xls file | 15:14 | |
| 17 | Course Conclusion | 01:29 |
Unlock unlimited learning
Get instant access to all 16 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Time Series Analysis, Forecasting, and Machine Learning
Apache Airflow Workflow Orchestration
Case Study in Product Data Science
Data Engineering on Databricks
