Lec-8: What is CANDIDATE KEY and PRIMARY key | Full Concept | Most suitable examples | DBMS

[@ShwetaBfit]

This man is amazing. Kudos to his way of teaching. He made me pass my NPTEL exam even though I am not a non medico I could still learn it so easily. Thankyou so much.

[@letsknow7676]

Whole set of keys which can be uniquely identified (can be null) are "Candidate keys " An appropriate key among candidate key which can't be null is "primary key" And remainig keys i.e. (candidate keys-primary key) are alternating keys.... Thanku so much sirjii. You are best😇😇😇

[@KRITISHARMA-fr7es]

no

[@piikachyu]

Bro the "remaining keys " after choosing one specific primary key from the candidate keys are called alternative keys.

[@zain-mi6js]

Watching from Pakistan 🇵🇰.This video Deserve a like.

[@ms_007_]

Respect India 🇮🇳💝

[@ideafacts7319]

India🥰🥰🥰🥰🥰🥰🥰

[@bilalqadri5312]

I m also..🇵🇰

[@Aamish553]

love from india🥰

[@adarsh_kr_maurya]

💓❤️🇮🇳❤️🇮🇳❤️💓

[@AK-us1by]

Best DBMS Tutorial I have seen so far.

[@prince43917]

your explanation is really good ,we really appreciate .

[@amanrathore4889]

One of the best teachers, I have ever seen. Thank you.

[@abhaymaitra7032]

The best teacher for Computer Knowledge

[@veenarani9160]

Gate Smashers.... Thank you sooo much for uploading such vedios.... Your way is very easy nd amazing

[@manishreddy1036]

This was in my interview and I bummed it last time and now I really got a good idea about SQL commands Thanks Bhai

[@MixInfo4554]

I want to given millions of like to you but it doesn't allow me more than one. Today I understand the concept of Condidate key. Much more love and respect for you. Sajjad from Pakistan. 🇵🇰

[@silent7810]

I like every video after watching this and pay tution fee by watching at last two ads.Thank you brother for this videos

[@silent7810]

Please make complete tutorial video on trending technologies like intellipath,simlpi learn and edureka makes. you will get huge audience support because your way of teaching is unique. we are here to support you brother

[@VictorFrankenstain]

Nice explained sir and you have amazing teaching quality by god gifted every critical topic you could handle easily.love and respect from Bangladesh.🇧🇩🥰

[@bilal8286]

Huge respect man from Pakistan🇵🇰🇵🇰..you deserve million likes and prayers..you are doing a wonderdull job..God Bless You ..thanks

[@souramitadebnath575]

ya💙💙💙....&🇮🇳🤝🇵🇰

[@hassansafdar2089]

Very nice explanation. I am watching the lecture before the exam and now I am ready for the exam. Thank you so much Brother keep it up and keep shining.

[@ankitatripathi9743]

Really U explain very well and few questiones asked by interviewer ,which i answerd ,Thanks

[@studentsheaven-d8v]

LOVE AND RESPECT FROM PAKISTAN DEAR SIR.

[@anjandeka1383]

Jai shree Ram🚩

[@amitsahgal2000]

@@anjandeka1383 😂😂😂😂

[@Anonymous-pb4kf]

@@snehagrawal They want to make databse of terrorist and their achievements in India So they can know how much they should fund that particular terrorist 😂😂😂

[@asaduddinowaisi-3498]

As Aslam Alaikum 🇮🇳🇮🇳

[@snehagrawal]

@@studentsheaven-d8v i am not interested to engage in altercation with idiots....

[@Creative_Edit09]

Thanks sir , youtube must have suggested your video on the top , really very helpful...

[@malikharoon6378]

Your way of teaching and explaining is next lvl.Thanks for clearing my concepts .

[@arghasen8236]

Thank You sir! :) I have started my preparation for WB JECA 2023 and your DBMS videos are helping me a lot to cover DBMS syallabus for my coming exam! All the best to all the learners who are reading this comment📒🔥

[@Ramjiram9997]

Suggest book for dbms

[@jyotsisters6300]

Bahut jagan se padha tha but concept get cleared now after seeing your videos .......really good job.

[@realfaceofindia2478]

Awesome teaching sir.. lots of love. .and keep going on. . Best of luck..god bless you. ..all video help us lots of .. thank you sir..

[@prabhprabh00]

My fav teacher in youtube sir are u sach a amazing i got passed in bca sem 3 by study through yours video 🎉❤

[@HannanZahid-us7ht]

0:00 - Introduction to Candidate Key 0:07 - Key 0:16 - Attribute 0:33 - Use of Key 4:28 - Candidate key set 4:40 - Primary Key 4:49 - Alternative Key

[@ammadahmad6361]

Dude, just watch the lec and stop wasting your own time

[@HannanZahid-us7ht]

@ammadahmad6361 Okay dear

[@RJ-ns6gf]

Yeh hain asli desi londa..hindi main padhata hain aur aise padhata hain ki ek baccha ko bhi samajh main aajaye👍👍👍👍

[@adityathakur8951]

chup

[@RJ-ns6gf]

@@adityathakur8951 kyu be...tere gaand me mirchi kyu laga

[@SHANMUKHASHARMA-s6h]

@@adityathakur8951 chup

[@viratjain7130]

Amazing explanation sir , it helped me a lot.

[@piikachyu]

Got it sir! It was easier to understand by your teaching. Thank you!

[@mutahirmehmood6138]

Very informative all videos Sir. I appreciate your afforts. Thanks

[@nareshkumar7354]

Thanks bro It helped me a lot while learning my ms access chapter

[@ZohaibRajpootFromSheikhupura]

Love from Pakistan 🇵🇰❤️ Great work sir.

[@Apnasafar-24]

who are watching this video in 2024?

[@pragyasingh1810]

Kya kroge jankr pdhaoge kya 😂

[@cropcatalyst396]

Me

[@sachinmishra9353]

Kal paper hai 😂

[@MishraV2024]

Me

[@ShikhaSingh-ej2xm]

Me😂

[@shashwatdhingra3580]

GLAD TO SAY THAT, EVERYTHING'S CLEAR. THANKS SIR!! 🙏

[@sahilshaikh5946]

wish my teacher could teach like you.... you are superb man

[@ShubhamSharma-ol4rl]

Thanks a lot sir...Thanks to your video series on DBMS and on OS that i was able to get placed in a good company.!!

[@aveshgamingworld7830]

agar aap na hote to me idhar udhar youtube par bhatak rha hota apne bca ke dbms subject ki study ke liye thanks sir you are a brilliant teacher.

[@tanayasingh9987]

Its ossom sir . Bina kisi confusion ke sab clear ho gaya😀😊☺

[@onkarta5300]

Nice video sir. Thanks for this video.👍👍👍

[@nishantbutani6323]

gajab gajab key topic kya bdhiya padhaya hain thank u sir g

[@sajansekhu8785]

Excellent explanation sir....thnkk u so much jii...🙏🙏

[@rupafavkumari9626]

Thank you so much sir for making my interest towards DBMS

[@adityapathak1748]

SIR, YOU'RE PLAYLIST IS TOTALLY AWESOME... I WANT TO KNOW ONE MORE THING, IS YOUR THIS DBMS PLAYLIST COMPLETE OR YOU ARE GOING TO ADD SOME MORE TOPICS AFTER PL-SQL VIDEO... PLEASE ANSWER AND THANK YOU, SIR !!

[@palakdixit7421]

Really within two years I hated the topics related to keys bcoz didn't understood bt today this video was so usefull n finally cleared the concept of keys . Thenkeww so much sir ❤️

[@aashishchaubeyschannel2676]

I believe this is a half-hearted attempt to explain this concept, doesn't even leave me with a comprehensive understanding of key vs candidate key.

[@pranabeshroy6295]

Sir your vedio is easy to understand and very use ful also very effective

[@anamaftab28]

Sir you are the best teacher in the world

[@rinkooyadav5793]

Thanks sir. .. You explain is very good. ..

[@behappyandmotivated598]

Thank you so much sir, it's really helpful.

[@techupdates987]

Thank you so much sir you are best teacher

[@Hey_saloni708]

Seriously best explanation 😮❤🎉

[@swatimahi4596]

Thankuuu so much sir literally itna easy laga keys topic apke samjhane k baad😍

[@aashvi6612]

Thank you sir, this helped alot!

[@ShubhamGupta-dm8tr]

Well explained. Keep it up sir 😊😊

[@saint_lunatic]

I am watching all 102 of your videos, I conclude, you are a GOD! sorry for spamming all your videos.

[@bhargavavaranasi8347]

Hello sir, video is incomplete, hope you correct that. Rest of the things are well explained..!!!

[@technicalnileshrathod.579]

Sir... No words for ur explanation... Great

[@indudwivedi706]

Dhanywaad sir 🙏 Watching from kanpur

[@simrankumariofficial4118]

Thanku so muchh sir🙏❤️❤️

[@MindandMatter-e7p]

What an outstanding & easy explanation

[@anonymousfan9703]

Sir mast teach karta ho Teacher ho to aapka jasa Aapke video ko dekh ka he to interest bna mara pdna ma

[@Sumit-tn9kg]

Watching from dubai 🇦🇪 habibi you are good

[@vinitkundu6397]

i finally got an idea of this concept. Thank you soo much sir. I really loves the examples they were simple and esay to understand.

[@shilpaprabhudesai9444]

All ur videos are really helpful. My revision is done with ease.

[@yashasvi1235]

Very good explanation sir ☺️😁

[@toonsforkids-z7e]

Sir bohat acha samjhaya ap ❤ nay

[@kartikprajapati2306]

Thanku So much Sir ❤️

[@Starwork09]

Huge respect in the field of Computer Science

[@khanmautube04]

Awsome... simple but comprehensive

[@_se7en_x]

DAY 8 Started this for 6th semester and interview preparation date:-12.03.2024 Hope so I will be able to complete this playlist..... 9/131 💯

[@Lifeofbloggerrr]

Excellent explanation!❤

[@vikashjha6628]

it is like a god gift , during COVID pandemic

[@rabindra66]

00:39 Candidate key is a crucial concept in databases. 01:18 Keys in a table uniquely identify tuples 01:57 A key in a database uniquely identifies tuples. 03:15 Candidate keys uniquely identify tuples in a table. 03:54 Different types of candidate keys and primary keys in DBMS. 04:33 Candidate key is a set of attributes that uniquely identify a tuple 05:12 Choosing primary key from candidate key set

[@sanaiftikhar2759]

great teaching method sir

[@nitulpratapsingh9016]

*Sir ka moustache bahut shandaar hai* 👨👨👨

[@ajeetprakash9204]

Thanku sir....great...hamlog ka kalyaan karte rahe

[@G.T828]

I would have almost mistaken you for K.L Rahul from your looks but then I realized that you are helping the country

[@ridaafzal6028]

Thanks sir Your explanation very good 👌

[@hanudeep6672]

1st tme..got to know dat wt r keys...superb explanation....

[@DevikaShah-ki2cw]

Properly explained....nice

[@motivational_thoughts6760]

Key is uniquely identify any two tuples which is same or different

[@Superhuman757]

I want complete sql and pl/sql videos in hindi. please make ..your way of teaching is v good

[@Axel_XxX]

So help full bro thanks....

[@ajgamer7873]

Thank you sir 🥰 nice explaination

[@ashisahu6841]

Your explanation is fantastic... Kindly give the full vedio. Plz want to learn primary key by yoy

[@Yashika_027]

Bahi mera viva h abhi 7 vje lkin mne yh Channel dekha suddenly sir inke jsa koi nhi pdha skta ❤❤❤

[@RojinaPariyar-xh4ks]

Thank you so much form nepal🇳🇵

[@nitheeshs5854]

Lucid explanation ❤

[@aishwaryasutar1553]

Well I get to know which books should I refer for DBMS

[@piyushchiddarwar6321]

thanks for such easier explanation..

[@kirtisisodiya7406]

please sir made videos on C++ and Java. Thank You So Much Sir. You Teach us in very easy way.

[@Jehnova7]

You're Amazing Bro!

[@anishchar4282]

Thanks 😊

[@amanprajapati3417]

best explaination sir😍😍😍😍😍😍😍

[@piyushtripathi5566]

Thank you sir ❣️

[@jyotiradityatiwary615]

Correction: Candidate key is a minimal superkey. In other words, no subset of the candidate key must be able to uniquely identify a row. Hence the set is not a valid candidate key since each component (eg. aadhar card) can uniquely identify any student. The individual elements, instead are valid candidate keys. Eg. is a valid candidate key and is another valid candidate key, but both together in a tuple would not make a valid candidate key.

[@vaibhavcharan9069]

Thank you sir 😊

[@GenAiStuff]

U r very smart sir 😍

[@umangverma3660]

Are you from Shimla?

[@FoodieTechieLife]

Raju saathi 😃😃

[@ashsharma6433]

Well explained

[@yashparmar5722]

Thanks sir❤

[@Shreya-ff9dx6fv1s]

Very nicely explained

[@bhagwatdhavale6091]

Engineering student key liye apka channel bahut helpful he Mere liye to bahut bahut Thanks sir

[@AkashKumar-qn7xm]

Nice video 👌👌👌💯💯