Types of Keys in Database |Primary Key |Candidate Key |Super Key |Surrogate Key| Natural Key

Подписаться 34 тыс.

Просмотров 23 тыс.

50% 1

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
www.youtube.com/watch?v=oDZUV...
Here is the link to the 2nd Video - 1st Normal form
www.youtube.com/watch?v=RyqhX...
The 2nd Normal focus on No Partial Dependency.
Here is the link to the 3rd Video - 2nd Normal form
• Second Normal Form in ...
The 3rd Normal focus on the transitive dependency.
• third normal form in d...
#Keys #NormalizationSeries #TechCoach

Опубликовано:

24 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@latedeveloper7836 2 года назад

3:00 Super key definition - just what I came for and much better than my lecturer's explanation. Thanks.

@KamranKhan006 2 года назад

You sir are outstanding with the explanations. Thank you

@ka2165 2 года назад

Best explanation thank you so much! My professor should learn from you.

@TechCoach 2 года назад

Wow that's some compliment:) made my day:)

@michafabich9213 2 года назад

best explanation of topic I've ever came across

@TechCoach 2 года назад

Thanks Michal ,I am glad I could help

@dhavalpandya4162 3 года назад

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

@Johnwilliams-th9hq 2 года назад

Thanks for using a databse table as an example to explain the topic.

@TechCoach 2 года назад

Hey John , I am glad I could help. If you have any other questions please do let me know I will be happy to help.

@user-qd2zp6xf8z Год назад

Wow nice 👍

@classichindifilmstrailers4079 Год назад

Thanks bro

@neerajshukla6907 3 года назад

Super explained bro .

@TechCoach 3 года назад

Thanks Neeraj, please consider subscribing to my other channel. It will really help me ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-j2cmJcxTpFw.html

@sheetaljaiswal2955 2 года назад

very nicely explained

@TechCoach 2 года назад

Thanks Sheetal

@tanushreenagar3116 2 года назад

Thank you 😊

@TechCoach 2 года назад

Thanks tanushree

@shreyadiwaker7172 2 года назад

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.

@TechCoach 2 года назад

Natural key is something that normal people/business users use to identify a record in the table , they are more logical and easily recognizable like your employee id or your aadhar card or pan card number .

@jyotikothari499 2 года назад

Good explaination..

@TechCoach 2 года назад

Thanks Poorva :)

@user-gl7js3kz3x 4 месяца назад

thanks

@TechCoach 3 месяца назад

I am glad I could help

@surajpatil3579 2 года назад

For validations of scd2 {historical records} what will be the query/ approach?

@TechCoach 2 года назад

We usually look for act_ind/flag to get the latest records :)

@surajpatil3579 2 года назад

@@TechCoachLast question... if Start date & end date is given... & if we want to findout mismatch records between source to target then?

@TechCoach 2 года назад

@@surajpatil3579 start date and end date signify between those records which record was active. This is especially important in hierarchies. For example if you were reporting to manager A till aug'21 a part of your trade commision for trades done till aug should go to manager A and for all later trades it should go to the new manager B .

@surajpatil3579 2 года назад

@@TechCoach Thanks

@phani-3493 6 месяцев назад

What is the difference between pk and surrogate key... Seems same

@aditishree3132 3 года назад

very understanding video. can you please give the answer of the table you dropped for normalizing.

@TechCoach 3 года назад

Thanks Aditi, I am sorry can you please confirm which table are you referring to?

@aditishree3132 3 года назад

@@TechCoach hey vivek sorry I commented on different video ,I was referring to the table you mentioned at last of your video on normalization exercise In this series 😅. Btw you are awsm I have actually able to crack interviews only after covering all your video 🤓 thanks a tons🤗

@TechCoach 3 года назад

Wow that's awesome Aditi :) I am glad I could help :)

@TechCoach 3 года назад

@@aditishree3132 please consider helping me in building my other channel by subscribing to it :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gTg6nCUuYO8.html

@aditishree3132 3 года назад

@@TechCoach sure my pleasure 🤗