Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More

An easy-to-follow tutorial covering the whole gamut of RDBMS keys: primary keys, candidate keys, superkeys, alternate keys, foreign keys, surrogate keys, natural keys, simple keys, composite keys, compound keys, and intelligent keys. Featuring lots of examples and a focus on the design process.

0:00 Introduction
0:53 Primary Keys
3:29 Candidate Keys
6:09 Superkeys
7:57 Alternate Keys
8:49 Foreign Keys
10:39 Surrogate vs. Natural Keys
16:55 Composite vs. Simple Keys
18:02 Compound Keys
19:01 Intelligent Keys

[decomplexify]

CONTENTS

0:00 Introduction
0:53 Primary Keys
3:29 Candidate Keys
6:09 Superkeys
7:57 Alternate Keys
8:49 Foreign Keys
10:39 Surrogate vs. Natural Keys
16:55 Composite vs. Simple Keys
18:02 Compound Keys
19:01 Intelligent Keys

[Damnedindenial]

please add Ads to incentivize yourself to do this more the world needs this.

[craigwebber]

As a CS student, these videos are far superior to my uni learning material. well done

[Tezla]

Why does this channel have so few subscribers? Your videos are very good

[rudiklein]

I have been modeling databases for years, to help me generate reports. I'm an on-the-job trained database builder. For the first time the concepts of all the key types are now clear to me. Thanks.

[albinkafexhiu]

Even if my 10 year old brother watches these, he will understand the keys for sure. Please keep going and post more videos about database.

[akindayoakinlabi]

I came only for primary keys and candidate key, but I didn't even realized when I got to the end of the video. The explanation was that amazing. The only part I am a little bit confused is in the compound key.

[MrTomfooligans]

Exceptionally well made content from a naturally gifted instructor. You are helping people like me make it to the end of school in one piece and what you're doing is so valuable. Thank you.

[SathyaPrakashMoparthi]

This is easily going to be my recommendation to my friends and peers who need a recap incase of interviews. So well put together. Most people don't bother going into it with examples and caveats the way you did :)

[roman_mf]

This is fantastic content! Would be great to see your take on a process of designing a database from start to end.

[bungus]

All of your videos have been super helpful for me. You explain stuff really well and I've had a hard time finding good resources. Would you ever consider making a video on entity relationship diagrams and crow foot notation?

[c-adhirajjadhav]

Damn!
I was so tensed about these concepts.
YOU EXPLAINED IT REALLY WELL !
I just can't express my thanks to you in words !

[wehbe]

I thank the algorithm gods for putting you in my feed

[diptendumandal]

Smooth. Seems like you framed a new key for learners - A key to success! Great video! 💯👏

[mikefochtman]

I've worked with computing for 40+ years, much of it with relational data in one form or another. And yet, I've learned some new things from your videos. Thank you for some great content presented in a clear and useful way.

[EmergencyChannel]

Came for the basic example, stayed for the quadcopters and sentient teddy bears

[ElOroDelTigre]

You have a very easy-to-follow style and a concise, interesting way of explaining. You truly decomplexify this stuff. Thanks.

[AdityaLakshmipathy.]

Hi there, loved all you videos..Thank you .. Looking forward to more such videos.

[The_Iron_Yuppie]

Really good breakdown. I really liked the illustrated tables to make the concepts clear.

[MethodOverRide]

Fantastic video! Everything I've watched so far from your channel has been excellent.