Database Design 25 - Surrogate Key and Natural Key

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[michaelseeds]

Your about 1000x better than my lecturer

[VeraxMusic]

I remember being super pumped to see the Bruce Willis Surrogates movie, and then only being mildly entertained. It's like they didn't know where to go with the great idea.

[codebreakthrough]

Learn about Surrogate Keys and Natural Keys by watching this video! Make sure you watch the other videos in the series!

[jackalcz]

That is the power of youtube. You type definition of something you want to know to google, google spits on you datasheets "Hey, you can find it there", or you visit some site where it takes like double of time to figure something you wanted to know. Or you can just type thing you want to know to youtube. Youtube spits on you few minute long video where somebody explains the problem easily and efficiently.

[kmc]

Seriously saved so much time reading through some of my textbooks man, thank you.

[damarh]

We meet again :) i used these courses to learn while going through school and now 7 years later using it to refresh the old noggin' for work >D

[PravinJanjal]

This is the only video that explains the difference between surrogate key and natural key!
Awesome!

[TonyTony-dnir]

As someone who basically had to learn this on my own, this is a great, clearly explained resource. I'm having to make the full switch over to surrogate keys for Sharepoint now. I've got a start on this, so think I'm find, but you may get a good response to  video with an example database on how to do this.  (Something else I had to learn the long way!).   Thanks much.  I'll subscribe.

[brauliogarcia]

you have a talent to teach these topics, congratulations!

[danmartin]

Caleb, could you please start using the white board with color markers. the chalk piece is making a creepy noise and also while wiping what you wrote on the board. Thanks for these video classes, I appreciate your knowledge sharing

[brandondunn]

Glad I came across these gems. Thank you for your time and effort!

[KatyKarineLee]

Does anyone know in the case of when the natural key is already unique, why we use the surrogate key to link tables? thanks in advance :)

[TheRonTait]

So in the last example there, the username would be a natural candidate key, and the user ID would be a surrogate primary key?

[MikeKenning]

This was such a great explination. Thank you!

[fNelHaLibE]

Is it possible to use a surrogate key in a intersection?

[somachicasincity]

Thanks this clarified for me the surrogate keys

[suryakantpatra]

Can anyone please write the query to add surrogate key in a table in mysql?

[franekkimono]

hey buddy how old are you ? I wished I had known what you know at your age :P

[Wes-Tyler]

Man even at 2x speed it's still way too slow. Wish there was a 4x speed option