Best explanation thank you so much! My professor should learn from you.
@TechCoach3 жыл бұрын
Wow that's some compliment:) made my day:)
@latedeveloper78362 жыл бұрын
3:00 Super key definition - just what I came for and much better than my lecturer's explanation. Thanks.
@michafabich92132 жыл бұрын
best explanation of topic I've ever came across
@TechCoach2 жыл бұрын
Thanks Michal ,I am glad I could help
@KamranKhan0062 жыл бұрын
You sir are outstanding with the explanations. Thank you
@Johnwilliams-th9hq2 жыл бұрын
Thanks for using a databse table as an example to explain the topic.
@TechCoach2 жыл бұрын
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.
@sheetaljaiswal29552 жыл бұрын
very nicely explained
@TechCoach2 жыл бұрын
Thanks Sheetal
@jyotikothari4993 жыл бұрын
Good explaination..
@TechCoach2 жыл бұрын
Thanks Poorva :)
@neerajshukla69073 жыл бұрын
Super explained bro .
@TechCoach3 жыл бұрын
Thanks Neeraj, please consider subscribing to my other channel. It will really help me kzbin.info/www/bejne/oGPGnn2ZrbmjfNk
@aditishree31323 жыл бұрын
very understanding video. can you please give the answer of the table you dropped for normalizing.
@TechCoach3 жыл бұрын
Thanks Aditi, I am sorry can you please confirm which table are you referring to?
@aditishree31323 жыл бұрын
@@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🤗
@TechCoach3 жыл бұрын
Wow that's awesome Aditi :) I am glad I could help :)
@TechCoach3 жыл бұрын
@@aditishree3132 please consider helping me in building my other channel by subscribing to it :) kzbin.info/www/bejne/nYXKZ6F5itqMhZo
@aditishree31323 жыл бұрын
@@TechCoach sure my pleasure 🤗
@dhavalpandya41623 жыл бұрын
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
@shreyadiwaker71723 жыл бұрын
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.
@TechCoach3 жыл бұрын
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 .
@phani-34938 ай бұрын
What is the difference between pk and surrogate key... Seems same
@TOP5-w4n5h Жыл бұрын
Wow nice 👍
@TEGUIAKAMEGNEDimitriAbel6 ай бұрын
thanks
@TechCoach6 ай бұрын
I am glad I could help
@sandeepsiddharth1248 Жыл бұрын
can you xplain composite key as well? you missed that
@surajpatil35793 жыл бұрын
For validations of scd2 {historical records} what will be the query/ approach?
@TechCoach3 жыл бұрын
We usually look for act_ind/flag to get the latest records :)
@surajpatil35793 жыл бұрын
@@TechCoachLast question... if Start date & end date is given... & if we want to findout mismatch records between source to target then?
@TechCoach3 жыл бұрын
@@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 .