Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Modeling 2 - Relational Data Modeling
Introduction & Goals
Introduction (2:02)
Goals of the course (3:39)
Basics and prepare the environment
Relational data models history (3:16)
Installing MySQL server and MySQL Workbench (8:04)
MySQL Workbench introduction (4:36)
Create the conceptual data model
The design process explained (4:14)
Discover the entities (10:24)
Discover the attributes (13:09)
Define entity relationships and normalize the data (11:19)
Defining and resolving relationships
Identifying vs non-dentifying relationship (2:01)
How to resolve many-to-many relationships (4:00)
How to resolve one-to-many relationships (2:34)
How to resolve one-to-one relationships (1:45)
Hands on-Workbench - creating the database
Create your ER diagram using workbench (19:46)
Create a physical data model (4:13)
Populate the mysql db with data from a .xls file (15:13)
Conclusion
Course Conclusion (1:28)
How to resolve many-to-many relationships
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock