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

MongoDB Fundamentals

MongoDB Fundamentals

Sources: Andreas Kretz
Document-oriented databases are rapidly gaining popularity among NoSQL solutions. Working with JSON documents in MongoDB is convenient, flexible, and...
1 hour 23 minutes 19 seconds
Case Study in A/B Testing

Case Study in A/B Testing

Sources: LunarTech
Examples from practice in A/B testing - this course will introduce you to the methods of designing, conducting, and analyzing experiments using A/B...
1 hour 56 minutes 17 seconds
Statistics for Data Science and Business Analysis

Statistics for Data Science and Business Analysis

Sources: udemy
Is statistics a driving force in the industry you want to enter? Do you want to work as a Marketing Analyst, a Business Intelligence Analyst, a Data Analyst, or
4 hours 49 minutes 30 seconds
Machine Learning A-Z : Become Kaggle Master

Machine Learning A-Z : Become Kaggle Master

Sources: udemy
Want to become a good Data Scientist? Then this is a right course for you. This course has been designed by IIT professionals who have mastered in Mathematics and Data Science....
36 hours 23 minutes 54 seconds
Apache Iceberg Fundamentals

Apache Iceberg Fundamentals

Sources: David Reger
Modern data platforms need the flexibility of data lakes and the reliability of warehouses. Apache Iceberg combines both approaches. In this course, you will...
33 minutes 32 seconds