Udemy – Relational Database Design: A Data Modeling Workshop 2023-8

The main value of this course is in learning how to translate business needs into data models using hands-on projects! We will work with two hypothetical clients who present us with a set of business needs. We create charts to meet their needs and modify the charts as their business needs grow and change. In short, you will learn data modeling skills by doing data modeling.

What you will learn in this course

• What is a relational database?
• How to avoid problems that can occur when storing data in tables
• Designing a database model that meets business needs and avoids data storage problems
• Prepare your data model to build the actual database
• An introduction to relational databases:
• Components of relational databases
• Tables
• Primary and foreign keys
• Correct database design:
• Data anomalies and avoiding duplicate data
• Normalization (first to third normal forms)
• Over normalization
• Data modeling:
• Entity-relationship diagrams: entities and attributes
• Relationships and entity cardinality
• Solving many-to-many relationships
• Data Modeling Project 1: Downtown Flower Shop:
• Building the basic data model based on business needs
• Update the model based on business changes
• Data Modeling Project 2: Best Technology University:
• Building the basic data model based on business needs
• Update the model based on business changes

Who is this course suitable for?

• Current or emerging technology professionals who need an introduction to database design.
• Anyone who needs to design a database to solve a business problem.
• Absolute beginners in database design

Installation guide

After Extract, view with your favorite Player.

Subtitle: None

Quality: 720p