Database Keys Made Easy - Primary, Foreign, Candidate, Surrogate, & Many More
HTML-код
- Опубликовано: 9 июл 2024
- 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
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
Come on man!! Please do more videos. 😢
please add Ads to incentivize yourself to do this more the world needs this.
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.
As a CS student, these videos are far superior to my uni learning material. well done
Same, what is it about universities and refusing to actually explain things in a relatable way? 😅
@@joshualee7002 question of the century
@@joshualee7002 Idk if it's the same everywhere, but in the US they already have your money what do they care if you don't understand the classes?
Common University L
They really are
Why does this channel have so few subscribers? Your videos are very good
100% agree. The content, pace, diagrams and examples are extremely well thought out and presented. Adding one subscriber now!
I just increased the subscriber count.
@@rudiklein
Me too!
Because its not Indian English
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.
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.
Really glad I could help.
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 :)
Damn!
I was so tensed about these concepts.
YOU EXPLAINED IT REALLY WELL !
I just can't express my thanks to you in words !
I thank the algorithm gods for putting you in my feed
Same bro
This is fantastic content! Would be great to see your take on a process of designing a database from start to end.
Another great video with great examples, thanks a lot
You have a very easy-to-follow style and a concise, interesting way of explaining. You truly decomplexify this stuff. Thanks.
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.
Really great video!
Dang! These are wonderful and fantastic!
Clear and precise explanation! Thank you!
Fantastic video! Everything I've watched so far from your channel has been excellent.
Really good breakdown. I really liked the illustrated tables to make the concepts clear.
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?
we need this
purely amazing.
for sure I'm gonna rewatch this .
A flawless video on this topic, inspiring and exemplary. Well done.
Thank you very much for this content! Very very clear and well explained. Fantastic introduction to these concepts!
Smooth. Seems like you framed a new key for learners - A key to success! Great video! 💯👏
Perfectly explained. Thank you
A video on relationship types would be good 👍🏼 you have a great way of making a complex things seem easy. Thanks!
I watched the normal form clarification video by you and now I am here and havent yet finished it... but I am compelled to give you my gratitude for making all things DB so simple. Thank you for that!!! 🙏🙂
Awesome job!
You are a good man. May god bless your soul.
I hope this videos help a lot of people thats truggle to make good relational database designs.
Amazing!!! very good!! thanks!
Amazing and intuitive explanation
Thank you! Much appreciated!
Keep uploading mate, we're all waiting for you :)
Working on it!
This was really helpful! Explained it in an easy to understand manner, with great examples!
Thanks! Yep, the idea was to make the explanations as easy and accessible as possible for people. Glad the video helped you.
Brilliant! Well said!
Thanks so much for this video! I just started my first BI job after studying in a different field. Your videos have been super useful. :)
Hi there, loved all you videos..Thank you .. Looking forward to more such videos.
easy to follow , very well illustrated and crisp, with real world examples and applications and with associated pros and cons too.. comfortably demistifying👍🏻👍🏻 .
I like this video, calm and informative… please more like it
I learn more with this way of teaching. Thanks. Greetings from Brazil
I have learnt something, thank you.
Thank you so for this. Remain blessed.
Very Good!
Thanks. This is pretty good and interesting
Super awesome :)
I like really the simple explanations :) Very well done, this stuff isnt easy. As suggestion for more topics: Design Patterns, and possibly anti patterns? Or if databases are more your thing (I've read some of your replies) Maybe some examples how to manage a lot of data? Various DB systems, or performance tricks and why those work? Or some 'under the hood' explanations as to *why* some things work like they do? Looking forward for more video's :)
thank you very much...superb stuff
Thank you very much!
such a great video
Thanks, it's very helpful to understand
FINALLY I understood, thanks)
Your way of explanation is getting a new subscriber..
You are too good!!!😃👍
Thanks , it's really helpful
Thank you so much for being able to explain these concepts in a succinct and clear manner. I wish you were my professor instead! Cheers
You are awesome!
thanks, you're awesome. May God bless you
Thank you!
Clearly explaining!
Thank you for this very clear explanations. I like your videos! I would be interested to see a deep dive into (different kinds of) joins
Much appreciated! A video on joins is a good idea, I might create one of those at some point.
God bless you...i needed this for exams
Very well explained
Thanks a lot!
OMG! I finally found a great video explaining this. There are so many videos that they are far less effective.
this is extremely useful, thank you so much. my database flashcard collection has been replenished
I teach online classes on Cybersecurity and my students often get tripped up by these concepts. I have reviewed a lot of videos and this is by far the best one I have seen. Keep it up!
can you create more content please? Your animation and way of explaining is superb!!!
very very good video. 👍
Amaaazzziinng!
Upload more videos please, these are well-explicated even for a non CS background student to comprehend
Thanks for this great bunch of well put together Information.
For intelligent keys I have three rules I follow.
- only use it, if there is a real (and known) value in the usage of the ID later
- only use it, if you can‘t achieve this value on a better way (e.g. no suitable field in a given database available)
- only use inherent and unalterable information in this id (as you mentioned e.g. date of birth.)
If you have to use this method with a changable information, try to make it an unalterable property. E.g. if you put the information in a materialnumber if you buy it or manufacture it (m-123, b-739…), think of creating a new dataset when this changes (like a buy and a manufacture version) but keep in mind that you might have to maintain both datasets or think of setting an expired flag on the old one.
As you can see this almost always opens a can of worms.
This is a great video, I could understand a lot of things that I was seeing and never asked before because I thought they were that way at random. I would like to see more videos on DAX as I find it challenging but I have the conspiracy theory that giving trainings on DAX can infringe copyright somehow. .The complex thing about DAX is how DAX behaves depending on the context of where it's used within Power BI and it's differences from regular Excel Power Pivot DAX models
Thanks!
Thank you very much for explaining it in such beautiful way, waiting for your next videos and also can you please make a video on difference between model and schema, I've gone through many websites but unable to grasp the difference.i strongly believe u can decomplexify.
Once again thanks for providing amazing content.
I just subscribed without delay
Comment for algorithm - great content
Dude your videos are great, make more? :)
Suggestions - star schema, snow flake schema, conformed dimensions. Great videos!
Have discovered you today in watching ur tutorials while previously i was struggling from others as i thought to myself that my understanding is so poor nearly i lost interest but now am happy have meet you
That is great to hear - I'm pleased that these tutorials have helped you so much.
Thank you
Excellent video,waiting for the latest update
well explained
So good!\
Your last Intelligent Key example is basically national identity number in Poland called PESEL :)
I hope that you will have more videos in the future.
man they should just play your videos in my dbms uni course ahah
@22:54 - it's probably fair to say that intelligent keys are those most likely to get printed on documents or displayed in emails. They are much easier to read out or reference by humans when making phone calls and so on.
amazing breakdown, good examples as well, thanks for putting your time into this. Just curious are you a backend developer? what did get you interested in the database design
Thanks! Actually my background is in business / systems analysis, translating user requirements into solutions. Just purely by chance, I got assigned to a lot of "data" projects and ended up specializing, without ever really intending to, in data modelling and in writing extract/transform/load (ETL) functional specs - especially in the context of data warehouses. There's a side of me that's very logical and precise and also very focused on communicating meanings clearly, all of which maybe accounts for why I find database design to be an interesting pursuit (& also why I like the challenge of finding ways to explain the concepts to others!)
Good primary keys are FUSSI:
Familiar
Unique
Stable
Simple
Irreducible
a hero to all cs students
very usefull
This man is single handedly saving my exam mark lol
Wow !
14:04 hmm niice example (of caution with surrogate keys)
can you make a video on different authorization in a database, on the basis of the work the user does. This confuses me when using an orm for my project. New to this and trying to understand more. Great video 👍.
hi, the video was very helpful. Btw, i'm not sure if i understood well the difference between superkeys and composite keys. Superkeys are a type of composite keys that can consist also of one attribute while the other must be 2+?
More videos pleaaase!!!!
Yo it's sad that this video is 7 months ago and no more were posted 😥
Have you already considered enabling the Super Thanks button? You totally deserve some extra credit!
Good suggestion - have enabled it now!
please add a video on identifiable relationship & non-identifiable relatioship