Database Design 29 - Foreign Key Constraints

Подписаться 624 тыс.

Просмотров 40 тыс.

50% 1

Start your software dev career - calcur.tech/dev-fundamentals 💯 FREE Courses (100+ hours) - calcur.tech/all-in-ones
🐍 Python Course - calcur.tech/python-courses
✅ Data Structures & Algorithms - calcur.tech/dsa-youtube
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/newsletter
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/subscribe
👨🏻‍🎓 Courses - www.codebreakthrough.com
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com/shop/calebcurry
🅿 Patreon - calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - github.com/sponsors/CalebCurry
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/crypto

Наука

Опубликовано:

29 июл 2014

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 43

@briddenattech 5 лет назад

"Sorry if I talk fast." Bud, I've been listening to you at 2x. Talk as fast as you want. Give me a challenge.

@jacobcasey28 4 года назад

One of the best things about self-studying is coming across cool dudes like this who can explain things in a good way, thanks!

@weatherlye71 5 лет назад

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.

@codebreakthrough 10 лет назад

Learn about Foreign Key Constraints by clicking below. Make sure you watch the other videos in the series! buff.ly/1uqxUf6

@joelkeane8740 7 лет назад

Awesome video mate! Really well explained - thanks : )

@sherlock4209 3 месяца назад

Thank you man. Amazing explanations and easy to understand!

@amynash1999 7 лет назад

one of the better videos on database.

@basementhermit3607 8 лет назад

Excellent explanation, very easy to understand. Thanks a lot for uploading this video.

@somachicasincity4232 10 лет назад

Thank you again this was helpful!

@minhtao9774 7 лет назад

"Get away stupid fly!" Hahahaha! Best part of this video =] and everything else hehe!

@soultouchingsongs 6 лет назад

Excellent. Thanks a ton!

@canberkuyar5469 5 лет назад

thx buddy it was so helpful you teach really well ^^

@robertoquinones785 7 лет назад

Great DUDE!!! Thanks

@anishkuber764 7 лет назад

Thanks man

@eluented 2 года назад

thanks man life saver

@kayoutube690 4 года назад

Question, is there any conflict to FK constrain once i am going to backup the table which associated to the FK?

@JoshuaMusau 3 года назад

well explained. thanks

@alexdan111111111111 9 лет назад

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

@dnj20 8 лет назад

thumbs up. t'es vraiment bon

@aw18473 8 месяцев назад

Well explained 👍👍👍👍

@grafitechdesigns6312 8 лет назад

great job bro, do you have videos on selection of tuple, projection operator, Cartesian product?

@amritkaur2142 8 лет назад

u r awsome

@davidflash1 7 лет назад

thanks, regards

@amalsakkoumi1392 3 года назад

Thanks from morocco

@hunterblake2710 5 лет назад

Good explanation

@pearlipop 9 лет назад

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?

@codebreakthrough 9 лет назад

***** I am! ...on RU-vid. hehehehe

@joshfraser3991 6 лет назад

pearlipop is right you are good! I am going to follow you!

@varunjain3756 3 года назад

well explained Foreign Key Constraints

@liangwu8328 11 месяцев назад

In what book I can learn these database concepts? Do you have any recommendations?

@manjuelaiya8597 7 лет назад

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

@sierrakilo9695 5 лет назад

So how WOULD you keep comments if a user deletes their account?

@cjlion7081 3 года назад

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

@TheSkepticSkwerl 5 лет назад

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

@TheSkepticSkwerl 5 лет назад

504 - gcih. 508 - gcfa

@danopo 6 лет назад

Your chalk is small.

@kld0093 8 лет назад

noll

@guypicard1648 5 лет назад

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.

@codebreakthrough 5 лет назад

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

@cjlion7081 3 года назад

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