Complete guide to Database Normalization in SQL

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:
00:00 Intro
00:46 1. What is Normalization
03:12 Different levels of Normalization
05:14 2. Step-by-Step Normalizing a dataset
07:35 First Normal Form (1NF)
12:44 Second Normal Form (2NF)
25:59 Third Normal Form (3NF)
32:42 3. Different Anomalies (Insertion, Updation, Deletion Anomalies)
37:10 Deletion Anomalies
39:08 Updation Anomalies
🔴 My Recommended courses 👇
✅ Learn complete SQL: learnsql.com/?ref=thoufiqmoha...
✅ Practice SQL Queries: www.stratascratch.com/?via=te...
✅ Learn Python: codebasics.io/courses/python-...
✅ Learn Power BI: codebasics.io/courses/power-b...
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ 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

Пікірлер: 356

  • @petruciucur
    @petruciucur Жыл бұрын

    There is no doubt, for me you are the best Relational Database Management System trainer. The way you explain really makes me understand. Thanks!

  • @techTFQ

    @techTFQ

    Жыл бұрын

    thanks buddy, glad you’ve liked my content

  • @Maya.1988

    @Maya.1988

    Жыл бұрын

    @@techTFQ Hi any dedicated course is there .... on sql performance and sql admin in Udemy or anywhere I will make my company to buy🙏🔥

  • @vasuhii2250

    @vasuhii2250

    Жыл бұрын

    Very clearly explained each and every point

  • @pranajpatil903
    @pranajpatil9037 сағат бұрын

    I have learned SQL from different platforms but never understood this concept but for the first time i felt it was so easy. Thankyou so much sir for such great videos.

  • @suganyanatarajan2661
    @suganyanatarajan2661 Жыл бұрын

    Best SQL trainer .. you teach the thought process as well which goes a long way! Thank you for all the great work.

  • @shravyatharapatti
    @shravyatharapatti12 күн бұрын

    Best way of explaining NF's,First time I understood the concepts clearly.

  • @sominramchiary5880
    @sominramchiary5880Ай бұрын

    Clear and straightforward explanation, all concept cleared on Normalization, Thank you so much buddy

  • @shadowitself
    @shadowitself Жыл бұрын

    as soon as I started my journey with sql databases I came across Ur channel every film proves that it was super good choice another great content THX

  • @vijaygupta7066
    @vijaygupta706613 күн бұрын

    Till now I read many post articles but unable to understand but from your video I got proper understanding. On KZread you and Ankit bansal content are like breaking hard problems and explaining in simple manner

  • @bharath8017
    @bharath801710 күн бұрын

    too good sir,been searching in various other channels for this content but I could not understand anything,but your content and explaination was too good that i can understand by just a single watch

  • @kunalkumar-hl6gv
    @kunalkumar-hl6gv9 ай бұрын

    This is the best video on internet which talks about this topic so perfectly!!!!!!!!!!!!!!!!!!!!! you forced me to comment!!!!!!!!!!!!!!!!!!!!! you are the best out there !!!

  • @iamnoob7593
    @iamnoob7593 Жыл бұрын

    Hands Down , Best video on normalization in entire internet.

  • @vignesan4197
    @vignesan419711 ай бұрын

    I love your way of explanation and your SQL series will give a clear idea about basic to advanced levels of SQL skills. Thanks!❤

  • @mohammedshahil4898
    @mohammedshahil4898 Жыл бұрын

    One of the most difficult concept explained in the best way possible👌👏🏻 As always a very useful video🙌🏻 No doubt you’re the best SQL trainer out there.

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you bro 😎

  • @sudhanshugrover2726
    @sudhanshugrover2726 Жыл бұрын

    Great explanation Thoufiq. Always a pleasure to watch your videos. I really like the way you channelize your thoughts in an easily comprehensible manner. The speed, clarity and content of your videos are absolutely perfect. Have watched other videos of yours and same opinion goes for them too. Coming to this one, i guess you knowingly kept the sales info till the 3rd step to explain transitive dependency, though you could've eliminated it at the same time you normalized Order/Prod/Cust info, since sales, just like customer, was also absolutely independent of candidate keys. Keep up the good work

  • @poojabagane3691
    @poojabagane3691 Жыл бұрын

    One of the best video on Normalization I have ever seen... Thank you for this beautiful explanation I got clarification on Normalization in an unequivocal manner.!!!!

  • @amirtahaehsaei1609
    @amirtahaehsaei1609 Жыл бұрын

    Brief, solid, and easy to understand. thumbs up!

  • @varshagoel5315
    @varshagoel53154 ай бұрын

    My Goddd!!!!! What an easy explanation of such complex subjects. Great work!!!

  • @varsharani5601
    @varsharani56018 ай бұрын

    I used to think Normalization as a complex concept. But till the point, I reached in video yet, I am finding it very simple because of your explaining style. Thanks

  • @joaofstock
    @joaofstock11 ай бұрын

    I have to say that I have made 3 courses with modules about data modeling and schemas, and this is the first time that I'm realling understanding how to build an ER Diagram. Many thanks for your explanation and all the best

  • @souravshome2602
    @souravshome2602 Жыл бұрын

    No doubt, you are the best sql trainer. After watching your video my all doubts about normalisation is cleared. Never miss your single video. Because of you I got to know lots of concepts about sql. Thank you Sir❤️.

  • @shorakhutte1887
    @shorakhutte1887 Жыл бұрын

    Very clearly explained. My doubts got clear. Thanks for providing valuable content.

  • @yordanosadigo
    @yordanosadigo Жыл бұрын

    No one explained this like you do....Thank you!

  • @minithyagraj6692
    @minithyagraj6692Ай бұрын

    Very well explained! This concept couldn't be made simpler. Thank you!!

  • @PatrickMuvunyi10
    @PatrickMuvunyi10 Жыл бұрын

    Thanks for making it crystal clear! Satisfied!

  • @akashchristopher
    @akashchristopher2 ай бұрын

    I love the way of your teaching. Crystal clear explanation.. Thank you Toufiq...

  • @Joshua_t_
    @Joshua_t_10 ай бұрын

    Great video. Working through the example database helps a lot.

  • @abhishekpunia606
    @abhishekpunia6063 ай бұрын

    "Mind is officially blown! 🤯 Thanks for simplifying Normalization in DBMS with real-world examples. You're a rockstar teacher! 🌟 #DBMSSimplified"

  • @parthibangopi8393
    @parthibangopi839326 күн бұрын

    I was very confused in this concept and have seen many videos and no one explained the way you explained. You are awesome. Expecting more videos related to SQL. Thank you

  • @anuragshah3433
    @anuragshah343310 ай бұрын

    For those who are confused on transitive dependency in 3NF, if we just look at the output of 2NF, Order_ID -> Order Number and Order number -> Sales contact first name and Order number -> Sale contact second name hence there is a transitive dependency. It was not flagged in 2NF as Order ID -> Sales contact first name and Order Id -> Sales contact second name, hence these are completely dependent on pk as well.

  • @manikantashet5921
    @manikantashet592110 ай бұрын

    Amazing explanation and clarity. Thank you!

  • @quintonbart8452
    @quintonbart84526 ай бұрын

    Absolutley brilliant. I understood the concept immediately. You are an excellent trainer.

  • @techTFQ

    @techTFQ

    5 ай бұрын

    Glad it was helpful

  • @bhupellygopikrishna3039
    @bhupellygopikrishna3039 Жыл бұрын

    Excellent Explanation, It Cleared every doubt in Normalization. Thanks

  • @david-mc8hc
    @david-mc8hc Жыл бұрын

    bravo! Very good examples and great/neat presentation! I have been struggling with this topic for quite sometime and now I can put it to rest. Thank you

  • @mohitdaxini3067
    @mohitdaxini3067 Жыл бұрын

    Too useful and seemed a relatable example rather than just reading out the definitions like other yt videos do when it comes to SQL normalisation topic...kudos 🏆

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thanks buddy, glad you like it

  • @basavaprabhusherikar7737
    @basavaprabhusherikar77378 ай бұрын

    I had no idea about what is 1NF, 2NF, or anything related to it. But after watching this video I get the idea now. And also why is it good to have different tables, and what kind of anomalies we would be facing if not done. Thanks buddy! Really a very good tutorial. Very clear and detailed explanation.

  • @Fashionsparklers
    @Fashionsparklers Жыл бұрын

    I found the best tutor to learn the Database and the it's content is very clear to understand. Thanks for the video.

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Glad you liked the content

  • @garrettlassalle6544
    @garrettlassalle65449 ай бұрын

    Thank you for this video. After watching it, I understand it now. You explained it well.

  • @attilapekkaszabo-iv6tl
    @attilapekkaszabo-iv6tl6 ай бұрын

    Brilliant, had this topic way back in Uni, but your explanation is 100x better. Great for refreshing my knowledge.

  • @techTFQ

    @techTFQ

    5 ай бұрын

    Great to hear

  • @dannycollins5698
    @dannycollins569811 ай бұрын

    This was a lot of fun and very helpful! You did an excellent job! Liked and subscribed

  • @viveksingh524
    @viveksingh5242 ай бұрын

    Finally today I learnt normalisation in easy way. Thanks a lot 😊

  • @princenischal3515
    @princenischal3515 Жыл бұрын

    I am really enjoying the video, great and comprehensive content. Thumbs up !!

  • @542_jayalaxmi_cse-a2
    @542_jayalaxmi_cse-a28 ай бұрын

    Nice explanation sir I have just started to learn SQL u have cleared the way how to learn in the proper manner

  • @hafizmoizmoiz6901
    @hafizmoizmoiz6901Ай бұрын

    Very informative tutorial. All my concepts are clear now. Keep it up ❤

  • @travelnlearn
    @travelnlearnАй бұрын

    Amazing video, I completely got entire concept in 1 video

  • @mohs8789
    @mohs8789 Жыл бұрын

    All concepts Explained in really simple ,clear and crisp way.👍

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @mangeshc1265
    @mangeshc1265 Жыл бұрын

    The best explanation ever on concept of Normalization. The concept is perfectly understood. kudos!

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Great to hear that

  • @Rajnikapoor-vm4mm
    @Rajnikapoor-vm4mm Жыл бұрын

    You are truly amazing sir, the way you describe each concept make it so clear and easy .... normalization is the topic which i always get to confuse but your explanation cleared all my doubts... thanks again

  • @parandama4589
    @parandama4589 Жыл бұрын

    Your a master of RDBS concepts

  • @omkargurme20
    @omkargurme20 Жыл бұрын

    Very well explained sir. Thank you for the information

  • @greendaywithtrading7408
    @greendaywithtrading74087 ай бұрын

    You’re the best SQL trainer .you teach the thought process ,I think Normalization is a complex concept but after watching your video i feel it will be easy !!!! thank you very much for making it so easy to understand

  • @techTFQ

    @techTFQ

    5 ай бұрын

    You're welcome ☺️

  • @VishalKumar-sc9ep
    @VishalKumar-sc9ep8 ай бұрын

    Hats off sir ❤ Now my concepts are crystal clear

  • @hsudhdhud
    @hsudhdhud3 ай бұрын

    Definitely this is one of the best best best best video from an organisation perspective.

  • @breserskcrimp9310
    @breserskcrimp9310 Жыл бұрын

    best video so far on normalization.

  • @joshuastates
    @joshuastates Жыл бұрын

    Great video, Thoufiq. Very clear explanations

  • @suyash7450
    @suyash74509 ай бұрын

    Normalization was topic that used to confuse me very time i saw so much content regarding NFs but getting confused more n more but now after watching ur video i am absolutely clear abut it ...

  • @subodhpatel3179
    @subodhpatel3179 Жыл бұрын

    Thank you for making everything crystel clear.

  • @dineshvardam2176
    @dineshvardam2176 Жыл бұрын

    You are really great sir, you explained this complex concept in easiest way...

  • @deepikasanthanakrishnan3264
    @deepikasanthanakrishnan32649 ай бұрын

    Amazed by your explanation😊. Thank you. Very usefull.

  • @triparnodas2269
    @triparnodas2269 Жыл бұрын

    You are doing a great job brother, most crystal clear explanation i have found on this topic normalisation, you are making SQL learning a cake walk for all the learners, kudos to you

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you Das .. so glad this helped

  • @endalekinfe3391
    @endalekinfe339112 күн бұрын

    That is wonderfull explanation, thank you so much sir.

  • @VaishnaviShinde-hh8sg
    @VaishnaviShinde-hh8sgАй бұрын

    You are the best teacher.your all sql videos are best for learning. Your explanation throughout the videos is mindblowing. please make more videos on Sql

  • @vickysreeramadas6386
    @vickysreeramadas63867 күн бұрын

    sir an awesome explanation just like one video whole concept of normalization cleared

  • @satyabharadwaj7779
    @satyabharadwaj7779 Жыл бұрын

    Each time you post a video, I'd always feel that this is the session tailor made for me. This video goes into one of many straight-in and simple to grasp conceptual videos of yours @Thoufiq. If there's anything I can ask, please make videos with mini projects on topics like normalization on complex data. Once again, thanks for sharing such a valuable content!

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you Satya .. much appreciated.. and noted on the suggestion

  • @sivasrimakurthi206

    @sivasrimakurthi206

    Жыл бұрын

    @@techTFQ I would be eagerly looking for it :-) every time, there is a video from you, it feels like a obligation for me to watch it :-) as I don't want to miss a valuable lesson that you teach. May god bless you and, keep rocking brother.

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you Siva.. very kind of you

  • @srinubathina7191
    @srinubathina71913 ай бұрын

    Thank You so much the way of your teaching is excellent sir

  • @josephaliyu1443
    @josephaliyu14436 ай бұрын

    Best explanation I've seen, thank you 🙏

  • @techTFQ

    @techTFQ

    5 ай бұрын

    Welcome:)

  • @jaychavhan6267
    @jaychavhan6267 Жыл бұрын

    Sir this is what I'm searching for from last couple of days .... Thank you so much 🙏🙏

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Your welcome buddy

  • @sohelshaikh9678
    @sohelshaikh967810 ай бұрын

    😮 You are great trainer 😀 Is reason to follow you sir

  • @shabanabegum3302
    @shabanabegum33028 ай бұрын

    Thank you so much Toufiq! It is beautifully explained, thoroughly understood..

  • @makav3li665
    @makav3li6652 ай бұрын

    Well curated and properly explained 👍

  • @user-zh2oz9fe4m
    @user-zh2oz9fe4m9 ай бұрын

    Great job! Thanks for this extremely useful video!

  • @dhanush98b11
    @dhanush98b115 ай бұрын

    Toufiq bro, I can say that you are the gem 💎 For teaching the sql concepts in the most understandable way. I'm working as plsql developer from 2 years without knowing anything about normalization. Thank you bhai for very informative contents on sql ❤.

  • @pavanareddy4536
    @pavanareddy4536 Жыл бұрын

    Awesome, can't wait to watch! thank you!

  • @micaelzekarias1537
    @micaelzekarias1537 Жыл бұрын

    Ur way of explaining things are so interesting. Keep it up. Love ur way of teaching. GBU

  • @spiritualthoughts5813
    @spiritualthoughts5813 Жыл бұрын

    That is very easy and well explained to understand for every one. Thank you Sir

  • @yegnapage7982
    @yegnapage79823 ай бұрын

    Thanks for such a quality content!

  • @GabrielOcheGodwin
    @GabrielOcheGodwin Жыл бұрын

    Got much value as usual.. Thank for this sir

  • @AparajithaSaravanakumar
    @AparajithaSaravanakumar5 ай бұрын

    Best normalisation explanation sir Thank you ❤

  • @belchchitura5116
    @belchchitura51164 ай бұрын

    Your videos are informative!

  • @sarahliu6891
    @sarahliu68913 ай бұрын

    super clear omg! you saved me, thank you so much!!

  • @user-zg8sq2on1c
    @user-zg8sq2on1c9 ай бұрын

    i finally understood normalization. subscribed

  • @nitinchoudhary9015
    @nitinchoudhary9015 Жыл бұрын

    Real life example loved it..

  • @user-qx3xz2me3h
    @user-qx3xz2me3h10 ай бұрын

    Thank you, thank you so much for knowledge sharing with us in good understanding manner. I Love your content and your way of explanation too.

  • @pankajdhome
    @pankajdhome11 ай бұрын

    Very well explained. Thanks a lot for such valuable content 😀

  • @shashankemani1609
    @shashankemani1609 Жыл бұрын

    This is a great video with a very clear explanation. Thanks a lot!👏 Please try to make a video on data modelling and data warehousing. 🙏

  • @prajackW
    @prajackW Жыл бұрын

    No one can explain it better than you sir ... thank you very much for making it so easy to understand 🙏♥

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thanks buddy, much appreciated

  • @INGCI_3694
    @INGCI_3694 Жыл бұрын

    thank you for providing valuable information

  • @sher.5027
    @sher.502710 ай бұрын

    Very good I loved the video. The colored data was helpful to understand. Keep your data coloured it helps. And your clear speaking also helps.

  • @utbkpreparation1401
    @utbkpreparation1401 Жыл бұрын

    Great Explanation!

  • @harithamenon6384
    @harithamenon6384 Жыл бұрын

    This helps me to understand the concept clearly.Thank you so much sir!

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Glad this helped

  • @ananyamitra6645
    @ananyamitra66456 ай бұрын

    you are the gem of a teacher. Thanks

  • @techTFQ

    @techTFQ

    5 ай бұрын

    Welcome:)

  • @hecksonchamutanga1996
    @hecksonchamutanga1996Ай бұрын

    Thanks a lot for making me understand

  • @Ashokkumar-xf8fn
    @Ashokkumar-xf8fn11 ай бұрын

    very well explained thanks a lot

  • @learnCodingTechguru
    @learnCodingTechguru Жыл бұрын

    Thanks bro nice explanation on Normalisation.

  • @Arif_Sk123
    @Arif_Sk1239 ай бұрын

    Keep up the good work , nice explanation. It helps.

  • @basavapn6487
    @basavapn648710 ай бұрын

    Just awesome as always ❤, Appreciate the knowledge share

  • @pulokmahato2416
    @pulokmahato2416Ай бұрын

    Superb explanation ❤

  • @MawandeDlomo
    @MawandeDlomo2 ай бұрын

    Simply the BEST

  • @naidubora2990
    @naidubora2990 Жыл бұрын

    Great Explanation Bro

  • @deepkaan
    @deepkaan5 ай бұрын

    Thanks for making this video. I was searching for this type of concept. Finally I came across your content.

  • @techTFQ

    @techTFQ

    5 ай бұрын

    Glad it was helpful

  • @jameselechi6209
    @jameselechi62093 ай бұрын

    Bro burst my brain, you're too good abeg, I swr. After you na you.

  • @anjuaj363
    @anjuaj36310 ай бұрын

    Very well explained sir