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.
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.
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 !!!
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
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.
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 ❤.
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
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.
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.
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 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.
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.
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
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
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❤️.
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
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 ...
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 🏆
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
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.
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
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!
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.!!!!
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 ❤️🩹✌🏻
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
It was really amazing, 🤩 the way you explain the concept is simply awesome. I request you to please make video on same concept with a dataset in SQL and how we need to do in SQL with different queries
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
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
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
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 RU-vid, there is no other video content available to beat this video. I am happy and understood fully. Thanks Santanu Roy