Hands-On Data Modeling: Convert ERD to 3NF and Star Schema #datamodeling #sqlforbeginners

In this video, I have explained in a very simple language what is a Data Model and various components in it. I have explained Entity Relationship Diagram (ERD) and how to build one. Then I have explained Normalisation and also shared how to convert ERD into 3NF form. Moreover I have explained dimensional modeling and how to convert 3NF table into Star Schema. Other recommended videos from my channel : Star Schema vs Snowflake Schema :    • Star vs Snowflake Schema: Understanding Da...   Innovative method to create Data Model :    • Create a Data Model from SQL: Free Python ...   Slowly Changing Dimensions :    • Slowly Changing Dimensions (SCD): The Ulti...   Starting with ETL ? Check this :    • ETL Explained: Key Concepts for Building a...   Starting with PySpark ? Check this :    • PySpark for Absolute Beginners: Part 1 – G...   Starting with SQL ? Check this :    • 3 Proven Strategies to Solve Any SQL Query...   Starting with Redshift ? Check this :    • Amazon Redshift for Beginners: Complete St...   Learning SQL ? If you are learning SQL & looking for some help, then I will recommend you following videos: SQL Pattern System (Part-1):    • Solve Complex SQL Queries Using Patterns: ...   SQL Pattern System (Part-2):    • Solve Complex SQL Queries Using Patterns: ...   The Maze Approach :    • The Maze Method: Solving SQL Queries for B...   SQL Breakdown Structure:    • Mastering Complex SQL Queries: Step-by-Ste...   Data Lemur referral link for easy reference: https://bit.ly/3SuF3wf If you like my videos, please subscribe the channel. I put lot of effort to create such videos and your engagement motivates me to come up with more such videos. Video Timeline: 00:00 Introduction 00:47 What is Data Model 01:10 Entity Relationship Diagram 08:38 Normalisation - 1NF, 2NF, 3NF 10:15 Dimensional Modeling - Dimensions & Facts 11:47 Hands-on ERD 17:05 Hands-on Normalisation (Third Normal Form) 20:56 Hands-on Dimensional Modeling (Star Schema) 25:30 Conclusion