Database Design 25 - Surrogate Key and Natural Key

[@ruixue6955]

3:16 surrogate keys

[@michaelseeds4221]

Your about 1000x better than my lecturer

[@VeraxMusic]

Yep, same here. Mine is dry, unenthusiastic, and generally lacks that intuition of knowing what points to like emphasize, as the students may not understand it, etc. Just a robot reading from notes.

[@codebreakthrough]

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

[@cedricphilibert7228]

+CalebTheVideoMaker2 good teacher +1

[@kmc6165]

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

[@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.

[@jackalcz2806]

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. KZbin spits on you few minute long video where somebody explains the problem easily and efficiently.

[@PravinJanjal92]

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

[@TonyTony-dn2ir]

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.

[@brauliogarcia1836]

you have a talent to teach these topics, congratulations!

[@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 :)

[@houstonfirefox]

A use case would be if a company was using a given application for a long time that used, let's say, numeric keys. They then changed to a system that used Alphanumeric keys with the new system. If surrogate keys are used then it would allow for this. Bear in mind that surrogate keys are used for Data Lake/Data Warehouse databases, not OLTP systems at the application level, they would use natural keys.

[@danmartin4737]

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

[@cholowao]

+Raj Narayandas better this maker looks terrible while writing code

[@hoohoopotahrebus1760]

+Raj Narayandas what?! you can't even withstand the sound of chalk on board?

[@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

[@brandondunn1622]

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

[@somachicasincity4232]

Thanks this clarified for me the surrogate keys

[@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!

[@ayasswain]

Very nicely explained in easy words.

[@hamedahmadi9291]

Well done

[@Kinnoshachi]

The good doctor

[@benysusanto7051]

thanks alot...

[@fNelHaLibE]

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

[@AdamSalma]

Good job, thanks!

[@sajadsh8260]

thank you

[@MessedUp_]

VERY helpfull! thanks mate :)

[@AnotherAgnostic]

Very helpful

[@DaanShooter]

really helpfull man, thanks a lot!

[@JulleHimself]

sick video dude!

[@tzezc]

Excelent... thanks!

[@suryakantpatra5228]

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

[@houstonfirefox]

It is simply adding a column to your existing datawarehouse/datalake table that auto-increments or otherwise becomes a composite key unique to that table.

[@PravinJanjal92]

What is domain key?

[@franekkimono7338]

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

[@ikebipe]

too long

[@Retrosenescent]

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