I not only learned some essential things here that allowed me to understand the schema of a programmer I know, but it makes me feel like you are my older grandson! You are brilliant AND adorable. Thank you. Also, I could not understand why fields in Infinium were being changed by SQL while working in a contract position. Now I realize the programmer probably was not aware that all these things are BUILT INTO Infinium and don't need to be updated, deleted or inserted by SQL. That approach is very illogical but it makes me appreciate IBM application SO MUCH. I don't hate SQL or Microsoft but it increased my appreciation of the iSeries (old AS400) systems and applications they support.
Great! I have never found yet such a great explanation on other tutorials... ON DELETE/ON UPDATE ... RESTRICT/CASCADE/SET NULL. ON DELETE SET NULL... that fantastic. You can delete the parent, but not the childeren...
i need answer for this question To ensure that the amount withdrawn shoulb be less then the credit card limit amount , to ensure integrity what type constraint will be use ? a. column level check constraint b.table level foreign constraint c.table level level check constraint d.column level foriegn key constraint
Reddit shows the comments forever, unless the comment is deleted. It just updates the user to [deleted]... I wonder if they set null, or some other set like 'set = 0' and any comment with 0 or null (whatever they do) is the user [deleted] However, i think if you restore your account, it restores the comment owner. They're good
an update to set all comments by user x to null in the child table with the comments by users, select pk * inner join select fk from comments table where user = x
Most of these constraints are based on the fact that you plan on changing the primary key in one of the tables - which you should never do. Foreign keys are important. But foreign key contraints? meh. Just make sure to never change the value of a primary key.
Well foreign key constraints also ensure that the value of the foreign key field exists in the referenced column on insert. That way you you avoid orphaned rows
@@codebreakthrough which is what the fk constraint construct is for, if you choose to use it. It's not a normal thing to do clearly, but can be useful. His overview also helps people understand basic key and constraint interaction concepts, important to beginners
i need answer for this question To ensure that the amount withdrawn shoulb be less then the credit card limit amount , to ensure integrity what type constraint will be use ? a. column level check constraint b.table level foreign constraint c.table level level check constraint d.column level foriegn key constraint
One of the best things about self-studying is coming across cool dudes like this who can explain things in a good way, thanks!
"Sorry if I talk fast."
Bud, I've been listening to you at 2x. Talk as fast as you want. Give me a challenge.
I not only learned some essential things here that allowed me to understand the schema of a programmer I know, but it makes me feel like you are my older grandson! You are brilliant AND adorable. Thank you. Also, I could not understand why fields in Infinium were being changed by SQL while working in a contract position. Now I realize the programmer probably was not aware that all these things are BUILT INTO Infinium and don't need to be updated, deleted or inserted by SQL. That approach is very illogical but it makes me appreciate IBM application SO MUCH. I don't hate SQL or Microsoft but it increased my appreciation of the iSeries (old AS400) systems and applications they support.
Learn about Foreign Key Constraints by clicking below. Make sure you watch the other videos in the series!
buff.ly/1uqxUf6
Awesome video mate! Really well explained - thanks : )
"Get away stupid fly!" Hahahaha! Best part of this video =] and everything else hehe!
Thank you man. Amazing explanations and easy to understand!
Your teaching is great Caleb, thank you for your videos! I have a question, is your goal to be a teacher? Or are you one, already?
***** I am! ...on UA-cam. hehehehe
pearlipop is right you are good! I am going to follow you!
Excellent explanation, very easy to understand. Thanks a lot for uploading this video.
one of the better videos on database.
Great! I have never found yet such a great explanation on other tutorials... ON DELETE/ON UPDATE ... RESTRICT/CASCADE/SET NULL.
ON DELETE SET NULL... that fantastic. You can delete the parent, but not the childeren...
In what book I can learn these database concepts? Do you have any recommendations?
great job bro, do you have videos on selection of tuple, projection operator, Cartesian product?
well explained. thanks
thx buddy it was so helpful you teach really well ^^
Thank you again this was helpful!
Question, is there any conflict to FK constrain once i am going to backup the table which associated to the FK?
i need answer for this question
To ensure that the amount withdrawn shoulb be less then the credit card limit amount , to ensure integrity what type constraint will be use ?
a. column level check constraint
b.table level foreign constraint
c.table level level check constraint
d.column level foriegn key constraint
Thanks man
Well explained 👍👍👍👍
thumbs up. t'es vraiment bon
well explained Foreign Key Constraints
thanks man life saver
Thanks from morocco
Great DUDE!!! Thanks
u r awsome
Excellent. Thanks a ton!
Good explanation
Reddit shows the comments forever, unless the comment is deleted. It just updates the user to [deleted]... I wonder if they set null, or some other set like 'set = 0' and any comment with 0 or null (whatever they do) is the user [deleted] However, i think if you restore your account, it restores the comment owner. They're good
thanks, regards
So how WOULD you keep comments if a user deletes their account?
an update to set all comments by user x to null in the child table with the comments by users, select pk * inner join select fk from comments table where user = x
504 - gcih. 508 - gcfa
Most of these constraints are based on the fact that you plan on changing the primary key in one of the tables - which you should never do. Foreign keys are important. But foreign key contraints? meh. Just make sure to never change the value of a primary key.
Well foreign key constraints also ensure that the value of the foreign key field exists in the referenced column on insert. That way you you avoid orphaned rows
@@codebreakthrough which is what the fk constraint construct is for, if you choose to use it. It's not a normal thing to do clearly, but can be useful. His overview also helps people understand basic key and constraint interaction concepts, important to beginners
Your chalk is small.
noll
gosh you are so handsome..
People would love you in India. (hint : your surname)
i need answer for this question
To ensure that the amount withdrawn shoulb be less then the credit card limit amount , to ensure integrity what type constraint will be use ?
a. column level check constraint
b.table level foreign constraint
c.table level level check constraint
d.column level foriegn key constraint