Complete guide to Database Normalization in SQL
175.4 هزار بار بازدید -
2 سال پیش
-
This is a complete guide
This is a complete guide for anyone to understand Database Normalization in SQL. I will not just explain the Normalization concepts but also show you step by step process of normalizing a de-normalized dataset taken from Kaggle by following the different levels of normalization (Normal forms).
The video is divided into 3 sections:
In the first section, I will explain the basic concepts of normalization and the different levels of normalization (different normal forms), and some key points you need to know to better understand normalization.
In the second section, I will explain all the above concepts in detail with proper examples. We shall use a de-normalized dataset taken from Kaggle for illustration purposes. We shall follow different normal forms to normalize the Kaggle dataset which should give a complete understanding of how to normalize any dataset.
Finally, in the third and last section, I shall explain the different anomalies that exist in a de-normalized dataset such as insertion, updation, and deletion anomalies. We shall also see how a normalized database can overcome these anomalies.
Timestamp:
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Intro
https://www.seevid.ir/fa/w/rBPQ5fg_kiY 1. What is Normalization
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Different levels of Normalization
https://www.seevid.ir/fa/w/rBPQ5fg_kiY 2. Step-by-Step Normalizing a dataset
https://www.seevid.ir/fa/w/rBPQ5fg_kiY First Normal Form (1NF)
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Second Normal Form (2NF)
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Third Normal Form (3NF)
https://www.seevid.ir/fa/w/rBPQ5fg_kiY 3. Different Anomalies (Insertion, Updation, Deletion Anomalies)
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Deletion Anomalies
https://www.seevid.ir/fa/w/rBPQ5fg_kiY Updation Anomalies
🔴 My Recommended courses 👇
✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmohammed
✅ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ
✅ Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId=70170e4c-7511-4c83-b769-c5cc8339c731
✅ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic concepts
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Intermediate concepts
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance concepts
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC SQL Queries
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTERMEDIATE SQL Que...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPLEX SQL Queries
✅ Data Analytics Career guidance:
• Data Analytics career and more
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
✅ Git and GitHub Tutorial:
• Git and GitHub
✅ Data Analytics Projects:
• Data Analytics Projects
THANK YOU,
Thoufiq
2 سال پیش
در تاریخ 1401/12/16 منتشر شده
است.
175,445
بـار بازدید شده