Relational Data Modeling

1h 52m
English
Paid
Relational modeling is widely used in the construction of transactional databases. You might say, "But I'm not planning to become a backend engineer." However, knowing not only how to move data, but also how to **effectively store** it, is a key skill. This includes creating a **scalable data structure** that ensures fast query processing and efficient data retrieval.
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 Relational Data Modeling

Join premium to watch
Go to premium
# Title Duration
1 Introduction 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

Similar courses to Relational Data Modeling

Case Study in A/B Testing

Case Study in A/B TestingLunarTech

Category: Data processing and analysis
Duration 1 hour 56 minutes 17 seconds
Data Analysis for Beginners: Python & Statistics

Data Analysis for Beginners: Python & Statisticszerotomastery.io

Category: Python, Data processing and analysis
Duration 6 hours 34 minutes 20 seconds
Spark and Python for Big Data with PySpark

Spark and Python for Big Data with PySparkudemy

Category: Python, Data processing and analysis
Duration 10 hours 35 minutes 43 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
Choosing Data Stores

Choosing Data StoresAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 25 minutes 31 seconds
Case Study in Product Data Science

Case Study in Product Data ScienceLunarTech

Category: Data processing and analysis
Duration 1 hour 4 minutes 47 seconds
Data Structures and Algorithmic Trading: Machine Learning

Data Structures and Algorithmic Trading: Machine Learningudemy

Category: Data processing and analysis
Duration 2 hours 20 minutes 32 seconds
Machine Learning with Javascript

Machine Learning with JavascriptudemyStephen Grider

Category: Java, Data processing and analysis
Duration 17 hours 42 minutes 20 seconds
Case Study in Causal Analysis

Case Study in Causal AnalysisLunarTech

Category: Data processing and analysis
Duration 2 hours 3 minutes 34 seconds
Machine Learning A-Z : Become Kaggle Master

Machine Learning A-Z : Become Kaggle Masterudemy

Category: Python, Data processing and analysis
Duration 36 hours 23 minutes 54 seconds