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