"Superkeey - its like superman but it is a key ... its like a Giant Key .... " LOL! - Hilarious. Your such a Geek ... so awesome ! Helping me alot to understand DB structure ... Keep up the good work buddy ! THNX!
Check out the most recent Database Design Videos! Superkey and Candidate Key: buff.ly/1rWEwQR Primary Key and Alternate Key: buff.ly/1rWEwQU Surrogate Key and Natural Key: buff.ly/1rWEwR2 Should I use Surrogate Keys or Natural Keys?: buff.ly/1rWEx7o Foreign Key: buff.ly/1rWEys0 NOT NULL Foreign Key: buff.ly/1rWEys8 Foreign Key Constraints: buff.ly/1rWEx7C Simple Key, Composite Key, Compound Key: buff.ly/1rWEyIA Review and Key Points: buff.ly/1rWEyIH Introduction to Entity Relationship Modeling: buff.ly/1rWEyIK
I am not sure what your background is, but if you are not an professional educator in some capacity, the world is missing out! I am a 45 yr old college junior majoring in CIT and if it was not for your videos I would be failing Database Systems!!! Thank you Caleb!!!!
This is fantastic, I really like the way that your exploitations are given in a way that doesn't mean your rushing forwards to make every single point made in the duration of five minutes or so meaning really, it's going to take the person watching the video more time to go through the video again to check for what they missed. just as a personal thought which isn't to say I have anything against the way you've taught the concepts of super and candidate keys, in practice it would seem that be getting on and doing things you'd then automatically realize and fill in the details that seem plainly intuitive like a candidate key, completely forgoing the need for a super key to be plucked from table in the first place it's often that the smaller processes like that are often completed automatically so like personally, I can't stand demands for a system to have all components passed through a normalization system comprised of three or more steps as usually, you'll end up completing what seems natural automatically
I thought you did a pretty good job of explaining. Helped me out, so keep up the good work, and don't worry about the length of the video. You could always add bookmarks in a long video to allow viewers to quickly scrub ton the info they are looking for. Thanks for doing this.
can we consider a set of keys from which any one key is selected as primary key (ex : {user name, email id} and a combination of certain columns to find the uniqueness
In the vid you said that the candidate key is the least # of columns that force every row to be unique. So why would you refer the composite key (first name, last name, address, birthday,..) as a CK even though the number of columns it includes is greater than one ( the username only needs one column)?
Text book wasting my time, trying to tell me these concepts but they made it long and it is confusing. I just say Thank you. I was upset and now I am laughing .
In the candidate key explanation part you showed it as "fn+mn+ln+birthdate+address" can we use the "first name+address" as candidate key.....................And thank you for the video it was informative and keep it so because comparsions will be more helpful in understanding.
Although it was 20 minutes, it was not boring. I did study this in the past so that could have made it easier for me to watch this or more boring to watch it. But it was not boring and great explanation.
Thanks a lot Caleb, your video is amazing: you speak really clear and gave a practical example, it helped me understand so easily. Why I found your video a few days before my final exam :( Wish me luck with my final damn 60% :)
No worries. A primary key is like taking a super key and refining it to make the database better. Rarely will you ever need to figure out your super key when creating your database. primary keys and foreign keys are what really matter.
10:28 Superkey: Any number of columns that create unique rows
11:27 Candidate key: The least number of colums needed to force every row to be unique
My graduate school professor couldn't explain this. Thank you for helping me understand what is actually a pretty simple concept. - New subscriber
"Superkeey - its like superman but it is a key ... its like a Giant Key .... " LOL! - Hilarious.
Your such a Geek ... so awesome !
Helping me alot to understand DB structure ... Keep up the good work buddy ! THNX!
Learn about Superkey and Candidate Key by watching this video. Make sure you watch the other videos in the series!
buff.ly/1qSXqHA
this series will help me a lot getting my exam cleared tomorrow. thanks
Your example is much much much much much much... better than my notes given by school's lectures.
Caleb, U have made learning Databases a fun to me. Thank you so much.
Check out the most recent Database Design Videos!
Superkey and Candidate Key: buff.ly/1rWEwQR
Primary Key and Alternate Key: buff.ly/1rWEwQU
Surrogate Key and Natural Key: buff.ly/1rWEwR2
Should I use Surrogate Keys or Natural Keys?: buff.ly/1rWEx7o
Foreign Key: buff.ly/1rWEys0
NOT NULL Foreign Key: buff.ly/1rWEys8
Foreign Key Constraints: buff.ly/1rWEx7C
Simple Key, Composite Key, Compound Key: buff.ly/1rWEyIA
Review and Key Points: buff.ly/1rWEyIH
Introduction to Entity Relationship Modeling: buff.ly/1rWEyIK
I am not sure what your background is, but if you are not an professional educator in some capacity, the world is missing out! I am a 45 yr old college junior majoring in CIT and if it was not for your videos I would be failing Database Systems!!! Thank you Caleb!!!!
You explained better than my professor. Nice job! You earned a new subscriber.
you explained this better than my professor. great job!
I found that also, and also better than I read from book :)))
This is fantastic, I really like the way that your exploitations are given in a way that doesn't mean your rushing forwards to make every single point made in the duration of five minutes or so meaning really, it's going to take the person watching the video more time to go through the video again to check for what they missed.
just as a personal thought which isn't to say I have anything against the way you've taught the concepts of super and candidate keys, in practice it would seem that be getting on and doing things you'd then automatically realize and fill in the details that seem plainly intuitive like a candidate key, completely forgoing the need for a super key to be plucked from table in the first place
it's often that the smaller processes like that are often completed automatically so like personally, I can't stand demands for a system to have all components passed through a normalization system comprised of three or more steps as usually, you'll end up completing what seems natural automatically
Thanks Caleb, Learning a lot form your video.keep up the good job.
Young, Smart, Funny, finally I got what is candidate key :) the video is 5 years old, but, anyway, thx for fun, and Very good explanation.
Great video Caleb. Good teaching, nice humor injections.
Fave teacher ever!
Great video thanks. Don't change a thing. It's perfect as is.
I thought you did a pretty good job of explaining. Helped me out, so keep up the good work, and don't worry about the length of the video. You could always add bookmarks in a long video to allow viewers to quickly scrub ton the info they are looking for. Thanks for doing this.
thank you for your excellent videos, you made it easy for me to understand database keys.
Great video, time is great because your explaining it. Thanks.
Calet, you are too much. am a beginner and your videos helped me alot. Thanks soo much.
This was very useful buddy! Keep it up!!
simple, clear and very helpful. thanks
Great work! Your video helped me understand DB a little more.
candidate key is defined as the minimal superkeys needed to force a unique row
Just check out this comment guys. The vid takes way too long to get to the point.
you are my super teacher thank you for helping me
much more clear than my professor :p
Chef Curry 👍🏿👍🏿
can we consider a set of keys from which any one key is selected as primary key (ex : {user name, email id} and a combination of certain columns to find the uniqueness
''so nice your lecture but some times you make littlebit fun is awesome thank you for representing ''
Thank you, you're videos are a great help!
real helpful man !!
It is very helpful #Caleb..Thank you
In the vid you said that the candidate key is the least # of columns that force every row to be unique. So why would you refer the composite key (first name, last name, address, birthday,..) as a CK even though the number of columns it includes is greater than one ( the username only needs one column)?
happy birthday!
Happy Birthday!
Thank you ! Very helpful :D Keep it up man!!!
Text book wasting my time, trying to tell me these concepts but they made it long and it is confusing. I just say Thank you. I was upset and now I am laughing .
In the candidate key explanation part you showed it as "fn+mn+ln+birthdate+address" can we use the "first name+address" as candidate key.....................And thank you for the video it was informative and keep it so because comparsions will be more helpful in understanding.
Although it was 20 minutes, it was not boring. I did study this in the past so that could have made it easier for me to watch this or more boring to watch it.
But it was not boring and great explanation.
I think George Foreman named all of his sons George. I don't know if any of them were twins.
9:28 "This girl's last name could be Curry, and that would be perfectly OK" ... now hold on a minute
so are superkeys and andidate key a form compostie key?
can i buy you a whiteboard
do you mean..if A,B,C,D,E,F are columns of tables then (ABCDEF,ABCDE,ABCD,ABS,AB,A) are super keys and (ABCDE,ABCD,ABS,AB,A) are candidate keys
Thanks man!
candidate key can be a super key or not or vice versa?
".....shame on you." LOL
"If you have twins and named them the same thing SHAME ON YOU" lmaoo
Thank you
Thanks a lot Caleb, your video is amazing: you speak really clear and gave a practical example, it helped me understand so easily. Why I found your video a few days before my final exam :( Wish me luck with my final damn 60% :)
thanks a lot!!
I just realized you're left handed
thanks
The thumbnail fooled me. You looked a 10 year old there. Anyway, nice vid!
Keys are the Key to succes LOL
Now I understand.
awesome
He who would pun, would pick a pocket ..
19 minutes and 14 seconds? Time to use 1.5x playback speed
17:30 😂😂😂😂
Alwoys i whach videos in youtube is very funny and injioning iiiiiiiiiiiiiiiii heyyyyyyyyyyyyyyyyyyyyyy
Who else is thinking he looks a lot like Dylan from Modern Family?
this video DID NOT need to be 19 minutes long caleb...
Annoying ads throw me out every single time. This is so bad for learning.
Sorry *caleb
You are adorable!!!
I dont see the difference between a superkey and primary key :/ CalebTheVideoMaker2
No worries. A primary key is like taking a super key and refining it to make the database better. Rarely will you ever need to figure out your super key when creating your database. primary keys and foreign keys are what really matter.
dang ur so cute, I really like being lecturing
thank for your joke
Cringy but understandable. .-.
my name is caleb too
So. Many. Ads.
Your jokes are pretty lame but who cares you teach damn well :D Thanks man
Aditya Sastry Caleb is The Man. Lane would be your profile pic. Haha
you did not know how to explain what you understood. you talked about many topics
Thank you