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

[@ka2165]

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

[@TechCoach]

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

[@latedeveloper7836]

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

[@michafabich9213]

best explanation of topic I've ever came across

[@TechCoach]

Thanks Michal ,I am glad I could help

[@KamranKhan006]

You sir are outstanding with the explanations. Thank you

[@Johnwilliams-th9hq]

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

[@TechCoach]

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-gl7js3kz3x]

thanks

[@TechCoach]

I am glad I could help

[@sheetaljaiswal2955]

very nicely explained

[@TechCoach]

Thanks Sheetal

[@jyotikothari499]

Good explaination..

[@TechCoach]

Thanks Poorva :)

[@neerajshukla6907]

Super explained bro .

[@TechCoach]

Thanks Neeraj, please consider subscribing to my other channel. It will really help me kzbin.info/www/bejne/oGPGnn2ZrbmjfNk

[@phani-3493]

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

[@user-qd2zp6xf8z]

Wow nice 👍

[@shreyadiwaker7172]

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]

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 .

[@tanushreenagar3116]

Thank you 😊

[@TechCoach]

Thanks tanushree

[@aditishree3132]

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

[@TechCoach]

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

[@aditishree3132]

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

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

[@TechCoach]

@@aditishree3132 please consider helping me in building my other channel by subscribing to it :) kzbin.info/www/bejne/nYXKZ6F5itqMhZo

[@aditishree3132]

@@TechCoach sure my pleasure 🤗

[@classichindifilmstrailers4079]

Thanks bro

[@surajpatil3579]

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

[@TechCoach]

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

[@surajpatil3579]

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

[@TechCoach]

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

@@TechCoach Thanks

[@dhavalpandya4162]

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

[@sandeepsiddharth1248]

can you xplain composite key as well? you missed that