Database Normalization Tutorial for Beginners | Database Normalization in SQL

[@questpondvideos]

20+ SQL Server Interview Questions : kzbin.info/www/bejne/iXbHcnluorh-iZY Software Architecture Interview Questions : kzbin.info/www/bejne/d6W3mJaYgbSkg68 20 MSBI Interview Questions : kzbin.info/www/bejne/hKjCpHt7gNOCi6c 10+ Power BI Interview Questions : kzbin.info/www/bejne/eaDdlGyNg6eFqpY SQL Server Joins : kzbin.info/www/bejne/gYXZint7o9mppJo SQL Step by Step - kzbin.info/www/bejne/q3jPl4NvpJyeo7s Angular Step by Step Tutorial for Beginners : kzbin.info/www/bejne/Y2q5lIptgqd3qZo 25 Angular Interview Questions : kzbin.info/www/bejne/Y5vIoKx6f6mmia8 35 Important JavaScript Interview Questions : kzbin.info/www/bejne/kJOXlYOfbKh0hLc 30 Important C# Interview Questions : kzbin.info/www/bejne/eHzcn3h4hdacf68 25+ OOPS Interview Questions : kzbin.info/www/bejne/q2qcqHSld893rLM 25 Important ASP.NET Interview Questions : kzbin.info/www/bejne/ponQfpejf7p2Zsk 20 PHP Interview Questions : kzbin.info/www/bejne/Z5PTf4avo7qlopo 5 MSBI Interview Questions : kzbin.info/www/bejne/a3abYmiXjaaqj7M 20 MySQL Interview Questions : kzbin.info/www/bejne/b5nJm3Zjd9WMaJI

[@kavindurandika2140]

I spent 3 months to understand this, but this teacher taught me that in 30 mins, You are not a teacher, you are a LIFE SAVER

[@lajapathyarun4329]

Great 👍

[@abhijeetsharma773]

Thanks Sir for providing wonderful content, it helped me in clearing many .net interviews

[@mahirabubakar3673]

This video is excellent it helped me understand more about the concept thank you

[@davb9514]

Thanks. Very helpful

[@babajee4644]

very informative.......................... brilliant...................help me to clear all the issues...............

[@seancool1907]

If any of my students use the terms "table" and\or "field" when asked to describe normalisation, I automatically mark them wrong and make the repeat the exercise until they get it right. Normalisation is a technique used at the data analysis stage of the database development. This is followed by the design stage and then the build stage. Tables are created in the build stage, until then they do do exist, only table structures exist at the completion of the design stage. As the normalisation is performed at the analysis stage no tables existed back then. Attributes are normalised to create entities which are presented as an entity relationship model.

[@questpondvideos]

If any of my students use the word entities in normalization , i will not mark them wrong , neither will i tell to repeat :-) But i would CORRECT them and say Entities represent real world model and it should not be taken as base for DB design , its good for representing code objects like OOP , DDD. I would not even use the word normalization with entities must be aggregation , composition.... A DB design is more about storing efficiently. retrieving efficiently and word tables , fields should be used more. We just belong to different schools of vocab must be... Happy learning.

[@humorherald]

Ordinarily, I wouldn't quibble...but, this seems as bit severe. I might have understood if your sticking point was relation versus table. But, I don't believe Codd's original paper mentioned tables or entities. But, I get the point. I prefer a discussion of entities and attributes, when discussing conceptual modeling techniques...ER modeling. By the time you move into logical modeling (schemas - if you're going to do it) and physical modeling...yes, you should be talking about tables. But, when discussing normalization techniques, we're generally discussing relations. Not every table is a relation. But, every relation is a table. So, even this discussion seems pointless. I think it's just best if they know how to do it. But, to each his own method. Cheers.

[@gamingchennai4946]

awesome sir, thanks a million

[@cyberbizkit1321]

Amazing tutorial

[@yo-2029]

What program are you using? Is it MS Access?

[@questpondvideos]

SQL Server

[@valijoneshniyazov3859]

helped me!