Working with Primary & Foreign key Constraint in SQL Server | SQL Server Tutorial

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@mukundnawale6565]

I SEARCHED MANY YOU TUBE VIDEOS FOR UNDERSTANDING THIS CONCEPT I I DIDNT GET ANY ACCURATE PLATFORM BUT AS A LAST TRY I OPEN THIS AND I GET UNDERSTAND.... IT IS SUPERB AND SUBERB WAY TO EXPLAIN WITH EXMPLE
THANK YOU

[@AlamontagnedelEternel]

I really like the way you have explained both Primary Key (PK) and Foreign Key (FK) from basics using theories. It was very very clear

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@baijayantisundaray210]

concept is nicely explained, Non-IT student can understand it as well

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@netajimohite3744]

Very simple and easy to understand everyone. Thanks

[@rehanashaik5497]

Thank u sooooooooooooooooo much sir plz again and again plz do the complete SQL and tsql i really understand what ur thougting each and every point

[@ajtechboy1424]

You are all in one Boss wow God richly bless you for us all ❤

[@vengalrao5772]

Really hatsoff bcoz itwas shooted 4 years ago 🙏🙏🙏❤️🤷 and very nice explanation !

[@LoveShashikanta]

my favourite teacher in Naresh It you are so talented sir you explained very clearly and easy to understand everyone

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@Shaik_zabi]

Really I watched many videos about PK and FK i didn't get after I watched your video clearly understood thank you soo much sir🎉 for clear explanation.

[@herilshah652]

Thanks for clearing the concept.Now it is more easy to understand and do practical

[@umamaheshpilla4951]

This concept is like an inheritance concept in Java programming language. Properties of parent class will be accessed by child class .. Good explanation from you sir👏👏 very glad to see your videos..

[@cococnk388]

yes you are right, but not all reference values in the parent table must be in the child table column...so it doesnot necessarily take all the properties of the parent (but all the values of the child column must be in the parent table (column)).

[@kunaljoshi2358]

Best faculty for oracle in nareshIT🙏😌

[@melodymathew5218]

The concept is clearly and nicely explained..

[@technologyfriends1589]

ruclips.net/video/tKgqbrBakd0/видео.html

[@technologyfriends1589]

ruclips.net/video/tKgqbrBakd0/видео.html

[@cm-037hemanth8]

Thank you sir for explaing more clearly

[@saitejapendli7036]

Nice explanation with very good example thank you so much 👍...

[@KarthiKeyan-re1uh]

Really you done a very great lesson sir ..its so useful for my interview.. Thank u😇

[@srinathmukkamalla9236]

ruclips.net/video/tKgqbrBakd0/видео.html

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@Kishorekumar-wt3rg]

You have cleared all my doubt in this video😊
Thank you sir

[@alialrahem9817]

your videos are so clear and l learn a lot good teaching and explanation thank you

[@tteejjj]

Teaching best.... Perfectly explained 👍👍👍

[@balusubbu81]

Crystal clear explanation sir I love u. . god of explanation

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@shubhamchavan2441]

Thanks a lot sir.. I was confused in Key topic , this vdo solved my confusion..

[@greezelsenilla9959]

thanks for this tutorial... at least i know from you ..... unlike my teacher i learned nothing .......he don't know how to teach

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@vinoderramsetty1093]

Great Explanation!!

[@Travelling_With_Kamalu]

Dear Sir.. big thank you -- for the clear my concept

[@worldoframanan3358]

Thankyou sir real life saver

[@726ashok]

Concept is very much clear...nice explanation..thanks

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@mrandroidzone2099]

Very helpful sir, explanation was very clear and understood.

[@bandaruneeraj7246]

Cristal clear Explanation

[@menagasanthaseelan6612]

very very good and nice explanation sir. thank you

[@qugamechannel6876]

I love man!! It helped me alot i wish i had a teacher like you

[@srinathmukkamalla9236]

ruclips.net/video/tKgqbrBakd0/видео.html

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@yogeshchaudhari8441]

Very Nicely Explained 👍👍

[@muskanramchandani7642]

Awesome Explanation

[@sandhiyas9987]

Thnq fr teaching us a good way it's very easy to understand 😌

[@maven558]

Hello Sandhiya

[@maven558]

Are you working anywhere?

[@anirudhvedullapalli4147]

Thanks a lot bro you are genius👏💙

[@ranjithas7238]

You have given good explanation sir. Thank q sir.

[@maven558]

Hello Ranjitha you working anywhere?

[@sureshmanthri6492]

Nice..good explanation by taking simple examples...Thank you sir..

[@abhisurya7487]

check this quiz on SQL ruclips.net/video/Hs5I24HSzsg/видео.html this might be useful for you. @Cheers!

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@cococnk388]

@@abhisurya7487 we no longer have acces to the link? can we have a new one?

[@sureshv7739]

simple but very clear

[@NARAHARINAYAK-vx3xd]

HARE KRISHNA ..SIR
VERY INCE TEACHHING

[@gatorade1129]

Very well explained...thanks for these amazing videos...concepts are getting clear

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@sureshkv8123]

Explanation is super

[@buddhikaperera5716]

thank you very much. this is the lesson i have been looking .. your presentation is very clear.

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@Sanjay-gz2wj]

Well explained Sir.... Thank you.. Keep up the same..

[@sandeepkumarverma6331]

It's really very helpful video lacture. Thank you so much sir 😊🤗

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@souvikdas812]

great video,,,,this is very helpful,,,concept is very clear

[@abhisurya7487]

check this quiz on SQL ruclips.net/video/Hs5I24HSzsg/видео.html this might be useful for you. @Cheers!

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@saiendeavours2154]

Thanks for this video. Indeed helpful. Nice explanation!!!

[@jeevaratnam3336]

Good teaching sir

[@vidyasagar5212]

Excellent 👍

[@srinivasentertainments2690]

Good explaination sir

[@thembeselecomene7385]

THANKS, THIS IS VERY CLEAR

[@bavadharanianbazhagan64]

Thank you for the understanding..

[@mdnadeem4288]

Thank soo much sir

[@kajalpatil2400]

But how to use PK & FK in 3/4/5 tables how to understand which key use for which table .....

[@varalakshmivara9360]

Excellent teaching sir

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@jayanthiramcharan4419]

Thanx for ur explanation sir ...❤️

[@krishnashauzshenikala9240]

Excellent explanation sir

[@anilamurtha2034]

ruclips.net/video/rRmI16IkqG0/видео.html

[@mahwishali1092]

It's really very helpful..Thank you so much Sir!

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@priyaroy9509]

Awesome lecture

[@pradeepkumarv5184]

thank you sir lecture video awesome its helped me lot...👍

[@pravinromano8774]

thank you sir, very nice explanation sir, it is very helpful for me sir, thank you once again sir

[@sandeepkhawas3367]

Wishing you all the happiness..! Like the way you have explained.!***

[@mohansaivelagapudi929]

Thanks for helping sir

[@avtarsashia4897]

thank u sir...you are giving concept clearing lectures

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@Negere-maryam]

thank you more my teacher!

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@bhaskararaogaddam4221]

Excellent class

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@bhaskarreddy-qo9sz]

Nice explanation sir

[@jeevanperala5138]

Sir as you told we can establish relationship between multiple tables by using the primary key and foreign keys.... But how...?? I'm thinking that primary key is only one(i.e fixed) but 'n' number of foreign keys are used with reference to primary key...???

[@MrBryan4you]

Same I’m thinking

[@MrBryan4you]

I have re watch his video and analysis... Yer, same thing he did.. Basically, you have to use the foreign key column and you can choose any other column from the child or second table with same data type ... I hope it helps

[@MrBryan4you]

Another issue is, when doing this in Oracle the syntax is hard to get right ... been trying to use the alter syntax and add constraint but it’s terrible 😭

[@cococnk388]

In order to know if a Primary Key column (parent) will be a foreign Key column in another table (child)...we should first map a relationship between the tables and find the cardinalities of the association..
table 1 (1,1 ) mapped to the table 2(0,n).....the primary key column of table 2 (parent) will become a foreign key column in table 1 (child)..
the primary Key column of table 2 (parent) has unique and NOT NULL values
the foreign Key column of table 1 (child) will have NON UNIQUE VALUES and NOT NULL (all of its values must be in the primary key column of the parent table 2)

[@VamshiKrishna-it3pf]

great explanation sir

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@jagadeeshk3910]

Worthful.. Thank you.

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@HARISHBUDDY]

Supebb sir. excellent teacheing......

[@nagurumarshaik3991]

good sir as i am beginner i understand well

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@Yagerlij7016]

THANK YOU BROTHER.

[@gemlanguevara9159]

Thank you sir👏🏻👏🏻👏🏻👏🏻

[@paarupallu6386]

good session sir

[@ॐसूर्यायनमः-घ3झ]

Then what's is the use of it, we need to create first parent table, then child table, how we can use it dynamically ?
I tried several times, also I first create parent table, and then use last insert I'd option, to insert in child table column, but facing errror. 😭

[@SrinadhVibesandBites]

well explained sir

[@justforyou7866]

very very gd methode of teaching

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@joyjk.]

very good video thanks, Sir

[@abhisurya7487]

check this quiz on SQL ruclips.net/video/Hs5I24HSzsg/видео.html this might be useful for you. @Cheers!

[@mathsystem8452]

I want to know that where we create front hand of this sql database backend

[@CuriousFear]

thank you come again

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@manishpal7454]

It is really nice

[@gouravchugh7524]

Thanks 🙏 🙏 🙏 🙏

[@crazyvideosshah2864]

Awsome sir.... Thank u.. To help them..

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@SugamMaheshwari]

thank you sir!
very much appreciated

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@oscarandcamille]

Very good explanation !!!

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@santharajup7150]

Thank you sir super

[@Ezhil_arasi21]

Sir whether v should use only same values in foreign key table and primary key table values

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@yaravallirohit8014]

Good one sir

[@cococnk388]

Thank you so much

[@vamsi4411]

Even if my tables doesn't have any matching columns can I give pk and fk..in the case of connecting 3 tables ??

[@manjuelaiya8597]

i need anser for this , to ensure that the amount withdrawn should be less than the credit card limit amount , to ensure integrity what type constraints will be used ?
a. column level check constraints
b.table level foreign key constraints
c.table level check constraints
d.column level foreign key constraints

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@javierdiaz1855]

Hi and thank you for your videos. How can I make three tables to follow each other? Thanks again

[@cococnk388]

Let us say we have table 1, table 2 and table 3
Create a relationship (Primary Key and Foreign Key) between table 1 and 2, another one between table 2 and 3 or table 3 and 1..
Use the join to retrive data from the 3 tables.
Hope it helps.

[@prasadk7792]

Thanq sir very helpful

[@srinathmukkamalla9236]

ruclips.net/video/L0ZibOAKbU4/видео.html

[@surenkumars3181]

thank you so much sir

[@shivavishwakarma7109]

Great sir

[@maddytherover]

thank u very much sir for providing knowledge to us.

[@jesayjulie2828]

ruclips.net/video/rRmI16IkqG0/видео.html

[@prathameshhiremath1379]

thank you sir........!!!!!!!

[@97sravanthi]

For other constraints in this tutorial please refer 36/47 vedio that is Working with Unique Not Null And check Constraints in SQL Server | MSSQL Training | By Mr.Sudhakar L
ruclips.net/video/o9WGbvWP2iE/видео.html

[@AKHILDS-j3v]

thank you anna..............njan oop exam pass aayath ee chanell karanma//thank you///

[@marychris2318]

ruclips.net/video/rRmI16IkqG0/видео.html

[@sagarjain4128]

I understood all. Is this an example of Primary key constraint?