Complete guide to Database Normalization in SQL

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 426

  • @petruciucur
    @petruciucur Рік тому +146

    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  Рік тому +8

      thanks buddy, glad you’ve liked my content

    • @Maya.1988
      @Maya.1988 Рік тому +4

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

    • @Amigo1452
      @Amigo1452 Рік тому

      Very clearly explained each and every point

    • @shubhjangid7881
      @shubhjangid7881 3 місяці тому

      Can you share this sheet? or where can I find the same?

  • @iamnoob7593
    @iamnoob7593 Рік тому +5

    Hands Down , Best video on normalization in entire internet.

  • @varsharani5601
    @varsharani5601 Рік тому +5

    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

  • @kunalkumar-hl6gv
    @kunalkumar-hl6gv Рік тому +5

    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 !!!

  • @suganyanatarajan2661
    @suganyanatarajan2661 Рік тому +11

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

  • @JayavishnuMadhiri
    @JayavishnuMadhiri 5 місяців тому +4

    the one you are who clarifies the normalization without any doubts
    thank you so much sir

  • @greendaywithtrading7408
    @greendaywithtrading7408 Рік тому +2

    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  Рік тому +1

      You're welcome ☺️

  • @dhanush98b11
    @dhanush98b11 11 місяців тому +1

    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 ❤.

  • @shadowitself
    @shadowitself Рік тому +1

    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

  • @Fashionsparklers
    @Fashionsparklers Рік тому +1

    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

  • @mohammedshahil4898
    @mohammedshahil4898 Рік тому +16

    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 😎

  • @anuragshah3433
    @anuragshah3433 Рік тому +6

    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.

  • @abhishekpunia606
    @abhishekpunia606 10 місяців тому

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

  • @varshagoel5315
    @varshagoel5315 10 місяців тому +1

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

  • @pranajpatil903
    @pranajpatil903 6 місяців тому

    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.

  • @joaofstock
    @joaofstock Рік тому

    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

  • @sominramchiary5880
    @sominramchiary5880 8 місяців тому +2

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

  • @ManojKumar-hy8wc
    @ManojKumar-hy8wc Рік тому +9

    Don't stop providing free content bro. Some people really can't afford the bootcamp course. I know it takes lot of effort from you to create the content. But trust me people will always remember you for what you have done.

    • @RohithS-ig4hl
      @RohithS-ig4hl Рік тому

      You try spoke facts!

    • @ManojKumar-hy8wc
      @ManojKumar-hy8wc Рік тому

      @@RohithS-ig4hl?? You try spoke facts... what does that sentence mean?

    • @RohithS-ig4hl
      @RohithS-ig4hl Рік тому +1

      @@ManojKumar-hy8wc what you said in the comment is true. "people will remember you for what you have done"

  • @suyash7450
    @suyash7450 Рік тому

    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 ...

  • @jameskelly3574
    @jameskelly3574 6 місяців тому

    just "WOW". I have been struggling to understand normalization for my db class. You used a great visual example and I love how you copied the table from 1 form to the next so we could see the process building upon itself as we get to the higher levels of normalization. You just earned a sub and like. Thanks so much.

  • @542_jayalaxmi_cse-a2
    @542_jayalaxmi_cse-a2 Рік тому +1

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

  • @parthibangopi8393
    @parthibangopi8393 7 місяців тому

    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

  • @hsudhdhud
    @hsudhdhud 10 місяців тому +1

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

  • @attilapekkaszabo-iv6tl
    @attilapekkaszabo-iv6tl Рік тому

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

  • @vaibhavpatel6996
    @vaibhavpatel6996 3 місяці тому

    Great explanation by you. Really learned something and I appreciate the length of content. You made short crisp and straight to the point.

  • @bharath8017
    @bharath8017 6 місяців тому

    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

  • @shravyatharapatti
    @shravyatharapatti 6 місяців тому

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

  • @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.!!!!

  • @akashchristopher
    @akashchristopher 9 місяців тому

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

  • @jaychavhan6267
    @jaychavhan6267 Рік тому +2

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

    • @techTFQ
      @techTFQ  Рік тому

      Your welcome buddy

  • @Valture.
    @Valture. 5 місяців тому

    Fantastic guide on database normalization! 🌟
    This video breaks down complex concepts into easy-to-understand steps, making it accessible for both beginners and intermediate learners. The examples were clear and simple, helping me grasp the importance of each normalization form
    Kudos to the creator for such an informative and well-structured tutorial.
    Looking forward to more content like this!

  • @Wanderer-c9u
    @Wanderer-c9u Місяць тому

    Such an amazing video! Just watched it for once and that too in ~2x and I got the whole concept in one go.

  • @satyabharadwaj7779
    @satyabharadwaj7779 Рік тому +8

    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  Рік тому +2

      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  Рік тому +1

      Thank you Siva.. very kind of you

  • @rahultino
    @rahultino 3 місяці тому +1

    Good explanation. One observation about the foreign keys. It might be a matter of personal preferences. Your example shows a separate 'relationship' table where you store primary keys of all the tables to tie them together. This is a good way. But another way which I have seen is to add the primary key of the product, customer, employee in the order table as a 'foreign key'. So you don't need a separate relationship table. This also simplifies the join. For example if you just want to show all the orders and customers. In the case of having a relationship table, you would have to join the order table with the relationship table, and then join with the customer table. In case you store the foreign key of customers in the order table, you just join the order and the customer table. I would love to read the benefits of choosing one over the other.

  • @quintonbart8452
    @quintonbart8452 Рік тому

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

    • @techTFQ
      @techTFQ  Рік тому

      Glad it was helpful

  • @mohitdaxini3067
    @mohitdaxini3067 Рік тому +1

    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

  • @mianawais99
    @mianawais99 5 місяців тому

    Best ever detailed and well explained video on DB normalization.

  • @basavaprabhusherikar7737
    @basavaprabhusherikar7737 Рік тому

    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.

  • @mangeshc1265
    @mangeshc1265 Рік тому

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

    • @techTFQ
      @techTFQ  Рік тому

      Great to hear that

  • @dineshvardam2176
    @dineshvardam2176 Рік тому +1

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

  • @souravshome2602
    @souravshome2602 Рік тому +1

    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❤️.

  • @VaishnaviShinde-hh8sg
    @VaishnaviShinde-hh8sg 7 місяців тому

    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

  • @emmanueljustice9059
    @emmanueljustice9059 Місяць тому +1

    First time commenting on a UA-cam even though I always give likes to good ones. Thanks for what you do. Hopefully in future, we see contents on Trigger, transaction on SQL from you too. ❤

    • @techTFQ
      @techTFQ  Місяць тому

      I appreciate you taking the time to add your first comment.. means a lot and many other topics coming soon

  • @parandama4589
    @parandama4589 Рік тому +1

    Your a master of RDBS concepts

  • @estherngina5278
    @estherngina5278 18 днів тому

    Thank you sir,,,,you just gat no idea on how much this content has helped me,,,,May God bless you Abundantly 🙏🏾🙌

  • @garrettlassalle6544
    @garrettlassalle6544 Рік тому +1

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

  • @santanuroy2121
    @santanuroy2121 Рік тому

    Hello Thoufiq, as I told in Linkedin that I will watch Normalization...
    Yes, I watched now...
    As per I think this video is the most easiest to understand about RDBMS with Normalization those who have fear about Normalization...
    In the UA-cam, there is no other video content available to beat this video.
    I am happy and understood fully.
    Thanks
    Santanu Roy

    • @techTFQ
      @techTFQ  Рік тому

      Thank you Santanu 🙏🏼
      Super glad you found this helpful

  • @Sumikthoughts
    @Sumikthoughts 7 місяців тому

    00:00 Normalization is the process of designing a database effectively to avoid data redundancy.
    05:28 Data set is denormalized, all the data is bundled together into a single file or table.
    10:36 The data set satisfies the first normal form.
    16:11 The dataset should be split into separate tables based on dependencies.
    21:24 Normalize the database to satisfy the third normal form
    26:15 The data set has been normalized into third normal form.
    31:23 In denormalized databases, insertion anomalies can occur due to data redundancy.
    36:14 Insertion anomaly can be eliminated by using a normalized database.

  • @mohs8789
    @mohs8789 Рік тому

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

    • @techTFQ
      @techTFQ  Рік тому

      Thank you 🙏🏼

  • @Joshua_t_
    @Joshua_t_ Рік тому +1

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

  • @viveksingh524
    @viveksingh524 9 місяців тому

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

  • @shubhjangid7881
    @shubhjangid7881 3 місяці тому

    Beyond Awesome. God bless you Sir. absolute gorgeous. Crystal clear understanding. Thank You so much.

  • @VishalKumar-sc9ep
    @VishalKumar-sc9ep Рік тому +1

    Hats off sir ❤
    Now my concepts are crystal clear

  • @bilalshahbazakmal2543
    @bilalshahbazakmal2543 Рік тому +2

    Best Chanel for SQL

  • @juberbashakhadumiya8527
    @juberbashakhadumiya8527 Рік тому

    i have watched many normalization videos but your teaching made me to completely understand this concept. Thank you 😊 @Thoufiq bhai

    • @techTFQ
      @techTFQ  Рік тому +1

      Glad to know that Basha 👍

  • @bhupellygopikrishna3039
    @bhupellygopikrishna3039 Рік тому

    Excellent Explanation, It Cleared every doubt in Normalization. Thanks

  • @poojas26
    @poojas26 2 місяці тому

    Best explanation in a simple and clear way .

  • @shorakhutte1887
    @shorakhutte1887 Рік тому

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

  • @MdNisarAhmed-de7vd
    @MdNisarAhmed-de7vd Рік тому

    I have read about Normalisation many times from many different sources but never understood so clearly as I did watching your tutorial. Thank you!
    Keep teaching us ❤️‍🩹✌🏻

  • @maheshvaran3342
    @maheshvaran3342 4 місяці тому

    Your way of explanation is awesome🙌, This is what I'm expecting. Thanks!

  • @breserskcrimp9310
    @breserskcrimp9310 Рік тому

    best video so far on normalization.

  • @prajackW
    @prajackW Рік тому +1

    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

  • @yordanosadigo
    @yordanosadigo Рік тому

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

  • @deepkaan
    @deepkaan Рік тому

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

    • @techTFQ
      @techTFQ  Рік тому

      Glad it was helpful

  • @vignesan4197
    @vignesan4197 Рік тому +1

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

  • @minithyagraj6692
    @minithyagraj6692 7 місяців тому

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

  • @ajaychavan1268
    @ajaychavan1268 Рік тому

    Yeah Tfq. I have no words . You are great come up with more complex sql queries . I am regular viewer hence . Love you from india

    • @techTFQ
      @techTFQ  Рік тому

      Thank you very much 😊

  • @sudhanshugrover2726
    @sudhanshugrover2726 Рік тому +4

    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

  • @micaelzekarias1537
    @micaelzekarias1537 Рік тому

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

  • @joshuastates
    @joshuastates Рік тому +1

    Great video, Thoufiq. Very clear explanations

  • @PatrickMuvunyi10
    @PatrickMuvunyi10 Рік тому +1

    Thanks for making it crystal clear! Satisfied!

  • @ananyamitra6645
    @ananyamitra6645 Рік тому

    you are the gem of a teacher. Thanks

  • @santoshhulloli7625
    @santoshhulloli7625 Рік тому +1

    Awesome explanation in a simple way. Superb sir keep it up & thank you so much

    • @techTFQ
      @techTFQ  Рік тому

      Glad you liked it bro

  • @travelnlearn
    @travelnlearn 7 місяців тому

    Amazing video, I completely got entire concept in 1 video

  • @gagankrpandit
    @gagankrpandit 4 місяці тому

    16:54 I think in this example the highlighted non key columns are dependent on both order id and product code. Because for example there are 2 different order ids with the same item price (780 and same for 850) so we would need product code also to differentiate between these rows of the same item price. Please correct me if I'm wrong with explanation as it will help me to understand the concept 🙂

  • @srinubathina7191
    @srinubathina7191 10 місяців тому +1

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

  • @chinyeremgbebuihe2536
    @chinyeremgbebuihe2536 8 днів тому

    Your explaining style is superb😮

  • @Mind_hit
    @Mind_hit Рік тому +1

    Thank you sir the way you explain everything is easy to understand for beginners.

    • @techTFQ
      @techTFQ  Рік тому

      Glad to know that buddy

  • @spiritualthoughts5813
    @spiritualthoughts5813 Рік тому

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

  • @AparajithaSaravanakumar
    @AparajithaSaravanakumar 11 місяців тому +1

    Best normalisation explanation sir
    Thank you ❤

  • @hafizmoizmoiz6901
    @hafizmoizmoiz6901 7 місяців тому

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

  • @sher.5027
    @sher.5027 Рік тому

    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.

  • @manikantashet5921
    @manikantashet5921 Рік тому +1

    Amazing explanation and clarity. Thank you!

  • @liberatingpanda7878
    @liberatingpanda7878 Рік тому

    You should be a lecturer....Made me understood the concept better than my current prof who took 3 hrs and i did not understand sh*t

  • @suriyars5662
    @suriyars5662 Рік тому

    There is no second thought if a video comes by techtfq the thing is it will have some insights which make us even better in that topic so I watch all videos even when I know the concepts also

  • @amirtahaehsaei1609
    @amirtahaehsaei1609 Рік тому

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

  • @dannycollins5698
    @dannycollins5698 Рік тому +1

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

  • @vickysreeramadas6386
    @vickysreeramadas6386 6 місяців тому

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

  • @PrithamPranamyaReddy
    @PrithamPranamyaReddy Рік тому

    Such a nice way of teaching really the way u r teaching is very well understandable and too full knowledge about subject

  • @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

  • @rezatajari-k2i
    @rezatajari-k2i Місяць тому

    Thank you for the best clear explanation and share this information
    helpfully for me 🙏🏼

  • @Nikhilg-rs7iv
    @Nikhilg-rs7iv 8 місяців тому

    Wasted few days watching videos from other channels. Completely I recommend this guys channel anything related to SQL

    • @aroraaaditya
      @aroraaaditya 7 місяців тому

      check jenny lectures bro on normalization makes you unsubscribe this channel

  • @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

  • @SivaVuyyuru-p1m
    @SivaVuyyuru-p1m 8 місяців тому

    You Simply nailed 👍. Simple and crisp. It would be have been nice if you could explain BCNF, 4NF and 5 NF. Your explanation damn good.

  • @avinashk8585
    @avinashk8585 Рік тому +1

    That's was a great explanation with good examples sir and i learn much about normalization from you.cheers 😀and thank you

    • @techTFQ
      @techTFQ  Рік тому

      Your welcome buddy .. glad you liked it

  • @shabanabegum3302
    @shabanabegum3302 Рік тому

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

  • @Infosys2022-j3j
    @Infosys2022-j3j Рік тому

    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.

  • @kasulagovardhan3
    @kasulagovardhan3 28 днів тому

    Thank you. A great session with more depth review.

  • @jameselechi6209
    @jameselechi6209 10 місяців тому

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

  • @sandeepmanjunath8004
    @sandeepmanjunath8004 Рік тому +1

    Thank you looking forward for more sessions like this