normally the primary key for a table is an extra column that is noramlly a NUMBER or ALPHANUMERIC type that is incremented by a certain rule when a new data row is inserted.
Often, but not necessarily. This is what one does to have a short key that needs to be referenced elsewhere and when the "natural key" is long (eg composed of several columns)
I am watching your video now on SQL Database Design in 11 Minutes Part 1. I find your teaching style very easy to follow, and I just want to say, I will be watching all of your series. I like how you keep it interesting and expand the thinking process building techniques. Thank you very much! This Relational Database Design course is fast paced and difficult to follow. I only have taken a basic introduction to Python Programing with no prior experience. I only have 2 weeks to complete it.
Just got tha books database at bookdowner[dot]com
longphi54 7 months ago
normally the primary key for a table is an extra column that is noramlly a NUMBER or ALPHANUMERIC type that is incremented by a certain rule when a new data row is inserted.
militantmindset 11 months ago
@militantmindset
Often, but not necessarily. This is what one does to have a short key that needs to be referenced elsewhere and when the "natural key" is long (eg composed of several columns)
roughsealtd 11 months ago
The teaching style was very good and made a fairly difficult topic easy to understand, thanks a lot.
mookjais 1 year ago
I am watching your video now on SQL Database Design in 11 Minutes Part 1. I find your teaching style very easy to follow, and I just want to say, I will be watching all of your series. I like how you keep it interesting and expand the thinking process building techniques. Thank you very much! This Relational Database Design course is fast paced and difficult to follow. I only have taken a basic introduction to Python Programing with no prior experience. I only have 2 weeks to complete it.
flyboydale54 2 years ago
Hey I have been looking for something like this to clarify basic database design!... nice!
And thanks!
nateaus 2 years ago
thanks, i've been looking for a basics lecture on database theory. awesome, simple, and well explained!
jonzart 2 years ago
Thank you. I've watched and enjoyed all of your sql videos.
jkolt89 2 years ago 3