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

Machine Learning Design Questions

Machine Learning Design Questions

Sources: algoexpert
Several videos presenting the practice required to pass machine learning design interviews. It will not be boring.
3 hours 3 minutes 57 seconds
Deep Learning A-Z™: Hands-On Artificial Neural Networks

Deep Learning A-Z™: Hands-On Artificial Neural Networks

Sources: udemy
Artificial intelligence is growing exponentially. There is no doubt about that. Self-driving cars are clocking up millions of miles, IBM Watson is diagnosing pa
22 hours 36 minutes 30 seconds
dbt for Data Engineers

dbt for Data Engineers

Sources: Andreas Kretz
dbt (data build tool) is a data transformation tool with a priority on SQL. It allows for simple and transparent transformation, testing, and documentation...
1 hour 52 minutes 55 seconds
Data Analysis for Beginners: Python & Statistics

Data Analysis for Beginners: Python & Statistics

Sources: zerotomastery.io
This course is your first step into the world of data analysis using one of the main tools for analysts - Python. Without complicated terms, advanced...
6 hours 34 minutes 20 seconds
Streaming with Kafka & Spark

Streaming with Kafka & Spark

Sources: Andreas Kretz
This course is a comprehensive project with a full cycle of real-time data processing. You will work with data from an online store, including invoices...
2 hours 46 minutes 25 seconds