There are way too many keys in DBMS and at times it is confusing to differentiate them on a high level. This video clarifies all your doubts related to keys. The video is part of the normalization series, Please watch these videos as well for better understanding on the entire concept. The video is the 5th video in the video series of Normalization. Here is the link to the 1st Video - normalization 🤍🤍youtube.com/watch?v=oDZUV... Here is the link to the 2nd Video - 1st Normal form 🤍🤍youtube.com/watch?v=RyqhX... The 2nd Normal focus on No Partial Dependency. Here is the link to the 3rd Video - 2nd Normal form 🤍youtu.be/ShNshBTtrYc The 3rd Normal focus on the transitive dependency. 🤍🤍youtube.com/watch?v=tJtZLJ-EFrE #Keys #NormalizationSeries #TechCoach
Wow nice 👍
You sir are outstanding with the explanations. Thank you
best explanation of topic I've ever came across
1obYexonVDo&t=3m00s 3:00 Super key definition - just what I came for and much better than my lecturer's explanation. Thanks.
Thanks for using a databse table as an example to explain the topic.
very nicely explained
Best explanation thank you so much! My professor should learn from you.
For validations of scd2 {historical records} what will be the query/ approach?
what is the difference between natural and candidate key ? both of them are used to uniquely identify record in table and there can be more than 1 natural and candidate key.
Good explaination..
Thank you 😊
very understanding video. can you please give the answer of the table you dropped for normalizing.
Super explained bro
.
Hello sir,
Could you please explain us on explain plan for a complex query that have some with cluase and all. actually for small query I can understand the plan but if the query is too complex how we can start understanding the explain plan ?
Thank you