Relational Data Modeling

1h 52m
English
Paid

Course description

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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 17 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction

All Course Lessons (17)

#Lesson TitleDurationAccess
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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

The Data Engineering Bootcamp: Zero to Mastery

The Data Engineering Bootcamp: Zero to Mastery

Sources: zerotomastery.io
Learn to build streaming pipelines with Apache Kafka and Flink, create data lakes on AWS, run ML workflows on Spark, and integrate LLM models into...
13 hours 23 minutes 15 seconds
Dimensional Data Modeling

Dimensional Data Modeling

Sources: Eka Ponkratova
In today's world, where data plays a key role, effective organization of information is the foundation for quality analytics and report building.
1 hour 37 minutes 57 seconds
The Data Bootcamp: Transform your Data using dbt™

The Data Bootcamp: Transform your Data using dbt™

Sources: udemy
Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course
4 hours 10 minutes 51 seconds
Choosing Data Stores

Choosing Data Stores

Sources: Andreas Kretz
One of the key tasks when creating a data platform and pipelines is the selection of appropriate data storage systems. This course is dedicated to that topic.
1 hour 25 minutes 31 seconds
Machine Learning with Python : COMPLETE COURSE FOR BEGINNERS

Machine Learning with Python : COMPLETE COURSE FOR BEGINNERS

Sources: udemy
Machine Learning and artificial intelligence (AI) is everywhere; if you want to know how companies like Google, Amazon, and even Udemy extract meaning and insig
13 hours 12 minutes 31 seconds