Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc

For complete DBMS tutorial: www.studytonight.com/dbms/
This video covers the different types of DBMS Keys like Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite & Compound Key and Surrogate Key with complete explanation and example.
Introduction to Normalization: • Basic Concept of Datab...
First Normal Form: • First Normal Form (1NF...
Second Normal Form: • Second Normal Form (2N...
Third Normal Form: • Third Normal Form (3NF...
BCNF: • Boyce-Codd Normal Form...
Fourth Normal Form: • 4th Normal Form (4NF) ...
Fifth Normal Form: • 5th Normal Form (5NF) ...
If you LIKE this video, give it a thumbs up and do SUBSCRIBE to our channel.
Our website: www.studytonight.com
Facebook: / studytonight
Twitter: / studytonight

[@eirikram]

I've spent the last month trying to fully understand this concept by reading boring textbooks for my college course. This video did that for me in 10 minutes. Excellent! Highly recommend!

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@mohsin6312]

Same here bro. This is a great video.

[@rohithgowra3979]

yeah

[@puneetpathak4742]

Same here 😊😊

[@Studytonight]

More videos being added. Checkout the new What is ….? series

[@rafaellacauduro6376]

I´m shocked with the amount of good professors with good didactic we have online and the amount of uncapable professors on universities... Thanks for your concise and clear explanation.

[@Studytonight]

Glad you liked it 😬 and thanks for the lovely comment 🐥

[@desusaivenkat4518]

Watched many videos but had no clarity about differences between keys, but after watching this video i am very happy that i understood them very well and even the entire normalization series is a life saver. Love you Studytonight

[@rialc6238]

Very nicely explained! I am a biology student who is now motivated to go into the field of Bioinformatics thanks to you. Keep it up & keep posting more & more videos!

[@RasheedKhan-bm8fm]

MAN, WHAT A LEGEND, THANK YOU, IT FEELS SO GOOD TO FINALLY UNDERSTAND ALL THESE DIFFERENT KEYS, CLEAR, CONCISE, NO B.S. EXPLANATION, MUCH LOVE

[@Studytonight]

Thank you, Rasheed Khan. We are working on making more videos.

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@gorheomkar]

This video is exceptional! I was so so confused... You cleared my doubts in less than 10 minutes! Keep going dude !!!

[@dard4642]

I just left a lecture where the professor described all of these keys verbally, with NO examples, no visual aids, and, prior to this lecture, had never mentioned Keys to use. Everyone in class was glossy-eyed the entire lecture. THANK YOU FOR THIS!

[@gayatridesai9925]

I was trying to understand these concepts for an entire semester and this man did it in 9 min.

[@Studytonight]

Thank you Gayatri :) Watch other videos too, and do subscribe to the channel :)

[@orange_cat]

That was quick, clear, and to the point-- thanks!

[@arkapravabiswas239]

Bruh.! an actual video that makes so many confusing concepts understand so easily, in such a concise manner, plus making it entertaining too. GJ man

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@5a1snehitha39]

Hats off to the one who made this video...understanding this topic within 10 mins is like ...great clarity in explanation...

[@anonanon6982]

Thank you so much, such lucid and crisp illustration. Simply amazing, Sir!

[@alannahkeena9489]

Fantastic thanks guys. Was really struggling to get my head around this before I watched this. Hello from Ireland!

[@trevosh15]

10/10 would watch again (if it wasnt for the fact that I got it the first time I watched it)

[@shelbyfaaron739]

This has never been so clear, thank you SO MUCH!

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@GG_Booboo]

Perfect explanation!!! Why didn't I discover this channel earlier! Thanks so much!

[@vsriram105]

Seriously,I have gone through series of videos before. But I understand everything in your ten minutes video..Thank u so much.

[@007Anukul]

So much and so clear information in 9 minutes. Hats off.

[@shivuk3501]

i was so confused with the concept initially even if i read through books, but u explained the concept within minutes.thank u

[@antoinemarange5114]

Thank you so much for your video ! You helped out a lot man, far more useful than my teachers online class ! Keep it up

[@hobaolan1243]

thanks, sir, you make my day. I've never been taught a good lesson like that so far. I spent many times in college learning these concepts but I didn't understand what the professor taught and I looked up this video that helps me a lot.

[@boushaft3459]

The lil easter eggs in this video are awesome!
Really enjoyed it and learned about the keys of DMBS! :)

[@anujkhairnar8947]

Bhai, kya sikhaya hai... ek number... sidhi baat no bakwas, clear hai 🤩👍🏼

[@rabiakhan324]

Best DBMS keys video I've ever came across, highly recommended 🔥🔥🔥
Thanks a lot senior 💜👏🏻

[@Studytonight]

Glad you enjoyed it Junior! New video on Database Transaction coming today :) Hope you like it too.

[@Jose-xh3tz]

Crystal clear and quite helpful. Thank you!

[@derry_yeh]

Brilliant stuff. Bookmark it and will re-watch multiple times. Thanks!

[@Studytonight]

Glad you enjoyed it!

[@fahadasad5782]

Thank you so much, this really helped me in understanding the keys in DB. I cannot recommend this enough

[@wiseJerry40]

I was trying to understand the difference between different types of keys as their definitions look similar so I got confused each time but this video explained it in 10 min. Thank you for this video sir.

[@navodsilva5621]

Mannn ! You are a life savior..Explained it well ! Thank you very much.

[@Studytonight]

Glad it helped!

[@sreekanththota2200]

Hi sir...Your videos are "AWESOME" and very informative...which saves a lot of time for me from the frustratable lectures..

[@m1hdi333]

Clear and straight to the point👏👏

[@DharmaanAcademy]

Bravo, Clear, Concise and to the Point, bundles of thanks

[@Studytonight]

Glad it was helpful!

[@jou2959]

hatss off man you made all those complex definitions of each key, easy as hell to understand....ty for this piece of cake!!!

[@shashankmandiya6832]

are you a kv student?

[@jou2959]

@@shashankmandiya6832 yes?

[@shashankmandiya6832]

@@jou2959 haan kesa hua preboard aaj ka?😂😂

[@jou2959]

Bro mai koi aur hun...

[@shashankmandiya6832]

@@jou2959 nhi ese hi puch rha hu me me bhi kv me hi hu
jaipur

[@fizakhan1427]

full-fleged understandable vedio lecture...was really helpful for preparation of exams.

[@Studytonight]

Thank you :) Glad it helped you

[@simmzzzz]

Extremely helpful. Thank you!

[@user-cc8qg1ll8c]

Much better then other long videos, Thank You!!! ❤

[@Studytonight]

You're so welcome!

[@madskillz1o1]

Wonderful, complete information, but simply presented.

[@Bigjb08]

Great clear, concise explanation. Thank you!

[@Studytonight]

[@racheltower6864]

Thank you so much for making this educational and engaging video!!!

[@SomethingBetter570]

Thank you so much i couldn't understand this in college's lecture of 1 hr but understood in just 5 Minutes here 👍

[@durgabaddela6674]

Simple teaching with more clarification 👍👍

[@surbhi412]

Concise and crisp information, useful video, recommended ✅

[@hongannguyenpham1005]

You explain very clear the concept. Thank you so much professor

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@raghulgunasekar2422]

Excellent vid mate!

[@abhishekgandhewar6858]

hIGHLY rECOMMENDED!!! Well done....

[@SkaterJay789]

I now understand because of you! Thank you!

[@abhishekpandey3105]

finally cleared all of my doubts, thank you for making this video

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@darenferrell]

Thank you sir! I was confused with my course work, and this video really helped to clear it up!

[@darenferrell]

By the way, great English. Just one suggestion, foreign is spelled f-o-r-e-i-g-n. Again, thank you very much for a very helpful video!!!

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@avinashsinghaniya8033]

I understood in a single time ,nice way of teaching

[@shawnforrest5880]

Yea dude that was awesome!! I literally having been rereading my book the past 3 hrs and all I had to do was watch this!! Thank you!!

[@sajishavs5589]

Understood well. Expecting more classes on dbms

[@hla260]

What a simple and compact explanation...
Thanks a lot...
🍁🍁

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@may83195]

Thank you!! This is so clear!

[@chiomae]

thank you for this video!!
It was very helpful, and insightful!
I also LOVED the expressive gifs you used! hahah!
It really helped too, to understand the topic you just taught! :)
THANK YOU AGAIN! 🥰❤❤

[@yogendravutukuri3849]

thank you bro, you helped me a lot i;m having my exam tommorrow and i saw the video this night i got this thanks for support keep going!!!!

[@shelbyfaaron739]

Same! Exam tomorrow! lol
Good luck to you

[@rocketleagueshorts1961]

@@shelbyfaaron739 same here XD

[@zainabansari573]

Thanks a lott sir 🤠. You made this topic so easy and simple to understand 💯.

[@ramsus6088]

Fantastic video thank you for clarifying this concept for me!

[@aishwaryasingh246]

Short and simple. Thanks a lot! :)

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@farhadkhan3893]

Very clear concept,, I watched many videos about DBMS keys but I did not get it clear,,, you made my concept clear l, thank you

[@Studytonight]

Glad it helped 😍

[@stayblessed8504]

Awesome.... Explanation and easily understanding content...... 🙏

[@senthamilselvir8168]

Fantastic... now I have a clear idea about these different keys... superb great job...

[@Studytonight]

Thanks a lot 😊

[@shubhamk840]

thank you very much you saved my lots of time on keys in the database management system.

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@user-no2xg7mv7h]

your teaching is really great!! new subs

[@abhishekpanigrahi1822]

Bhai Kya samjhaya h bro !! Loved it a lot .. thank u .. I have added u to my playlist !!

[@KeshariPiyush24]

Very clear explanation...... thankyou very much!!!!!

[@humtumsaath123]

Very nicely i understand all these keys....thanks for this..

[@johnnys3501]

By far the best I’ve ever seen this explained!

[@Studytonight]

Thanks bro 😎

[@johnnys3501]

@@Studytonight No problem! I have an exam for my database systems module on Friday and was finding it hard to see the difference between some of the keys...all good now, I understand.

[@mauryaji8999]

The best explanation possible.
Like we teach each other in hostel before exams😄

[@Studytonight]

Thanks a lot 😊

[@dirceualejandrogutierrezca7515]

now this is what i call a perfectly explained video, of course I'm leaving a like :)

[@nhd_puff]

you guys should make more dbms videos. you deliver all things needed by students in few minutes thank you for that!

[@Studytonight]

We will! If you can please share some topics that you think we should cover.

[@nhd_puff]

@@Studytonight relational algebra calculus and sql schema definition constraints, queries and views chapters thanks in advance

[@yutaitadori7318]

Best website and UA-cam channel is here .

[@ManojKumar-hj7fh]

A great explanation on keys of DBMS, kindly keep making more videos, I subscribed after I watched this video
Thank you

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@akhila1909]

Thanks a lot for amezing video sir!
Really! I got a clear picture about what are keys and why we use.
Thank you sir! ❤️

[@SandyRocker]

next level explanation bro !!!! understood it clearly thank u ❤️

[@Studytonight]

Most welcome 😊

[@AzimBaldiwala]

Thankyou for the Amazing content. Thanks again for explaining it very nicely.

[@shauryashrivastava8965]

Awesome video !! Can you make a complete DBMS course for college students that includes such concepts ? Please ?!

[@Studytonight]

Hey 'WHY SO SERIOUS', we are working on a few new things, will definitely create more videos on DBMS and SQL.

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@aparnavemuri89]

Awesome videos.. I watched all of them..Its a request if you can provide us with Oracle practical part..thankyou

[@anirbansaha8001]

Saved a lot time, thanks a lot

[@sanglee1755]

simple and clear, thank you!

[@Studytonight]

You're welcome!

[@Brijeshkumar-lk5mt]

Thank you so much. Very Helpful for everyone.

[@Studytonight]

You are welcome! and Merry Christmas :)

[@avisat7677]

this guy saved 10 hrs of my life. Hats off

[@Studytonight]

Thanks bro! for your comment 😍 and I am glad that the videos helped you.

[@durgaprasadmajji8057]

Really superb 👍👍👍I had watched so many videos for keys in DBMS....but this one made my day...and I saw your playlist there aren't lot of videos....why don't u make it more....(just for suggestion)

[@amitsingh1591]

Thank you Sir !!...you really a good Teacher...I kindly request you to launch a course on front end development

[@timbarnbou372]

Thank you sir for this high quality and easy to understand video.

[@Studytonight]

You are most welcome

[@Samuel-wl4fw]

Thank you, fantastic explanation

[@Escko]

great explanation of this concept...thank you!!!

[@Studytonight]

Glad you enjoyed it!

[@hasnainasif1657]

Great explanation.
Thanks

[@bikramdeepyadav7493]

To the point explanation... ❤

[@shreyashachoudhary480]

Loved this.

[@ranzitdey1307]

tnx man. i am grateful to you

[@kalyan07parigi57]

Excellent explaination brother. Keep uploading the videos. Your way of presentation is tooo awesome.

[@waterbottlexd1298]

Thank you for making this. Helped me alot.

[@Studytonight]

Glad to hear it!

[@santoshperne3608]

Great explanation sir, thank you so much

[@sumairahasnain4734]

Your editing is really superb !!!

[@sivasanjayraahulm7947]

Thanks for the clear explanation 🤝🤝

[@naffiahanger9316]

Accurate and precise.

[@taefnadim]

Thanks for the elaboration

[@kiranjape3941]

Thanks alot ...its gr8 explained to know clear understanding of keys.

[@mukkamallasrinathreddy4121]

ua-cam.com/video/tKgqbrBakd0/v-deo.html

[@norannoran2296]

thank you! easy & perfect explanation

[@Studytonight]

You're welcome!

[@SunilSharma-jw3kk]

Super crispy and time saving