Lec-11: Insert, Update & Delete from Foreign Key table | Referential Integrity

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 พ.ย. 2024

ความคิดเห็น • 660

  • @rj...12ka4
    @rj...12ka4 6 ปีที่แล้ว +338

    Such a simple and nice explanation for Referential Integrity 👌👌👌 100 times better than those college lectures 👍👍😊😊🙏🙏

    • @keshavkumar-ro3zm
      @keshavkumar-ro3zm 5 ปีที่แล้ว +18

      the stupid egofull professors of indian colleges just come to colleges for money nothing else. they dont care for Indian education.

    • @ankitatripathi9743
      @ankitatripathi9743 5 ปีที่แล้ว +1

      @@keshavkumar-ro3zm true

    • @adilismail3593
      @adilismail3593 5 ปีที่แล้ว +1

      Malayali?

    • @shirishabanuri2927
      @shirishabanuri2927 4 ปีที่แล้ว

      Exactly I think I'll pass my exam dis year

    • @h_s_4049
      @h_s_4049 4 ปีที่แล้ว +1

      @@keshavkumar-ro3zm He is also a University Prof @ LPU, Punjab,India. But all colleges lack such professors.Max prof only join colleges to have stability in teaching career in CSE and IT

  • @swayamsiddharath2224
    @swayamsiddharath2224 4 ปีที่แล้ว +47

    You are a Saviour of all the students who are in 4th year and sitting for placements,those who are giving semester exams,for gate candidates and for professionals.You are the Best.Thanks for the whole playlist.You have a great teaching style and the content is mindblowing.

  • @shailyjain912
    @shailyjain912 4 ปีที่แล้ว +49

    My few concepts were not clear being SQL developer in IT company..
    After watching this ..It really helped me on debugging the issues.
    Trust me its all about learning thanks for such amazing tutorials..🤩

  • @webrobust4491
    @webrobust4491 4 ปีที่แล้ว +48

    Million times easy explanation for any new beginner. Thanks, Bro. University lectures are just filthy. Keep posting :)

  • @aj_s_unboxing
    @aj_s_unboxing 6 ปีที่แล้ว +14

    16.36 - "Yaha pe toh koi tu ta nahi hai"
    Sir amazing hai apka style.
    Liked your video a lot.

  • @rs-no1ju
    @rs-no1ju 5 ปีที่แล้ว +49

    Thanks a lot sir..your way of teaching is very interesting..i never get bored while learning from your videos..💚💚💚💚

    • @GateSmashers
      @GateSmashers  5 ปีที่แล้ว +8

      Thank you Susmita Rathoud for your love and support. Bless you

  • @Official-tk3nc
    @Official-tk3nc 4 ปีที่แล้ว +162

    if you are watching in lockdown believe me you are one of the rare species on the earth who are working hard to achieve their goal

    • @thumarmitesh6559
      @thumarmitesh6559 4 ปีที่แล้ว +6

      Abhi start kiya hai cuz switch karna hai

    • @damansharma6737
      @damansharma6737 4 ปีที่แล้ว +5

      @@thumarmitesh6559 pehle konsi skill thi??

    • @codingmaniac6005
      @codingmaniac6005 3 ปีที่แล้ว +5

      kal exam hai isiliye dekh raha houn!!!!

    • @Unknown-Stranger
      @Unknown-Stranger 3 ปีที่แล้ว

      @@codingmaniac6005 konsi uni. h teri

  • @vimalprakash4115
    @vimalprakash4115 3 ปีที่แล้ว +7

    You seem to have poured your heart with your explanation ... Just brilliant. 👌🏻

  • @AnandKumar-kz3ls
    @AnandKumar-kz3ls 5 ปีที่แล้ว +180

    When legends started youtube channel

  • @483_saurabhjindal6
    @483_saurabhjindal6 ปีที่แล้ว

    What a Brilliant teacher.
    He knows the #pedagogy of teaching .
    He can sell this course at a good amount but he has given it in free.

  • @sruthishamithun2810
    @sruthishamithun2810 2 ปีที่แล้ว +3

    this lecture is just woooooow...... clear cut explanations , way of teaching also just woooooooow....... thank you sir :)

  • @SHASHANKRUSTAGII
    @SHASHANKRUSTAGII 5 ปีที่แล้ว +7

    I'm so happy that I found your playlist on DBMS. AFTER seeing all the videos my basics has become more strong

  • @ritikabali6466
    @ritikabali6466 3 ปีที่แล้ว +3

    the comment section is already full of good wishes and your praises.👏 Thank you would be a small word for teachers like you😊

  • @purnimapanat5178
    @purnimapanat5178 3 ปีที่แล้ว +2

    Best explained sir ❤️❤️ Cristal clear .. and this video is 3 years ago can't believe coz I couldn't find better explaination on TH-cam than this ..lots of love sir may god bless you ❤️

  • @shreyasgosavi9647
    @shreyasgosavi9647 4 ปีที่แล้ว +11

    16:26 that change of expression shows how he teaches with feeling's 👏👏👏

  • @shaikhshugufta3741
    @shaikhshugufta3741 4 ปีที่แล้ว +3

    Seriously one of the bestest explinations of foreign key concept...Thank you Soooooo much 😊😊😊
    Don't know why people dislike your videos....crack minded people

  • @rupaprasad5407
    @rupaprasad5407 2 ปีที่แล้ว +1

    I was watching each Teachers but I can't understand with them and finally I founded your TH-cam channel and it is very helpful for the students ..I just love your teaching style..Thank you sir 😊😊

  • @hum__shyam
    @hum__shyam 6 ปีที่แล้ว +2

    Pure TH-cam p Kisi ne Aaisa Nahi samjhaya hai Sir!
    #best_teacher 👌👌

  • @ankitmehta4133
    @ankitmehta4133 4 ปีที่แล้ว +3

    No words to admire you. Such a beautiful explanation ever.
    Mere UGC clear ho jayga, by the help of yours.

  • @siddharthshukla758
    @siddharthshukla758 3 ปีที่แล้ว

    Sir kya padhate ho ek dam perfect and super understandable vedio series.I'll suggest each and everyone to learn from this.Hats off sir.

  • @saikiranp.r6966
    @saikiranp.r6966 5 ปีที่แล้ว +7

    Hands down the best explanation I ever came across Referential Integrity. Thank you sir, may you get more power and strength to teach us the same way smiling. This channel will grow in no time. God bless.

    • @GateSmashers
      @GateSmashers  5 ปีที่แล้ว +5

      Thank You so much Sai for your love and blessings

  • @adityadiwan3485
    @adityadiwan3485 4 ปีที่แล้ว +4

    I've was reading about this but couldn't get the hang of this.
    You've made it clear. Thanks!

  • @schoudhury1911
    @schoudhury1911 2 ปีที่แล้ว +2

    He is an ASSET to everyone who needs help to understand things from root level. GOD bless .

  • @ginadekeana
    @ginadekeana 5 ปีที่แล้ว +2

    I watch most of your videos now i have a better basic idea on DBMS . God Bless you !! You will do very well in future !!!

  • @__idyllist
    @__idyllist ปีที่แล้ว +1

    I didn't see that much clear and simple explanation before! Sir salute 🫡you

  • @theenlightenedsoul4209
    @theenlightenedsoul4209 5 ปีที่แล้ว

    Kya padhate ho yaar aap.JABARDAST .Loved your teaching .May you be blessed

  • @ShivenduShree
    @ShivenduShree 4 ปีที่แล้ว +3

    With each and every video I watch on Gate Smashers channel, my love and respect for you multiplies multiple times. I wish ki har learner ko aap jaise teacher se pdh paane ki kismat ho.
    🙏🙏

  • @guddurocking7599
    @guddurocking7599 4 ปีที่แล้ว +1

    BEST TEACHER OF DBMS ON TH-cam. YOU ARE TOO GOOD SIR. YOUR EXAMPLES NAILED IT.

  • @roshandhaker7745
    @roshandhaker7745 4 ปีที่แล้ว

    Sir sir sir , you are Amazing sir.
    Jitni tarif kare utni km hai.
    College ka 1 mhina ho gya kuch samaj nahi aaya dbms.
    Par aapke lecture dekh kr sb kuch samaj aa rha hai.
    You are really great teacher @gatesmashers

  • @tomgodsalo3333
    @tomgodsalo3333 3 ปีที่แล้ว +1

    I have a good teacher, but online classes suck......so yours is better....you are a live saver in exams

  • @PankajKumar-yi4sn
    @PankajKumar-yi4sn 2 ปีที่แล้ว

    Kya baat hai Sir, aaj maine youtube par pehlibar aisa video dekha.

  • @freeforall9298
    @freeforall9298 2 ปีที่แล้ว +1

    One of the Best teaching method.

  • @techworld3043
    @techworld3043 3 ปีที่แล้ว +5

    reached lec 11 thanks for good content, I prep for my college exam.

  • @FactuponFacts
    @FactuponFacts 2 ปีที่แล้ว

    I could easily understand your lecture and better then college teacher and such a simple all the lectures of dbms

  • @shovikanand3214
    @shovikanand3214 3 ปีที่แล้ว +2

    The best way to teach these basics & most important concepts of sql..all ur videos r much knowledgeable sir.. thanks for sharing ur knowledge.. live long n healthy always☺️

  • @ajaybachate7137
    @ajaybachate7137 3 ปีที่แล้ว +1

    I'm speechless I did some projects using a database but I never understood the foreign key concept and what is on delete cascade I just used to copy paste this concept now I understood what really is a foreign key..amazing sir lots of love and hats off to Your teaching

  • @ibadshaikh2215
    @ibadshaikh2215 5 ปีที่แล้ว +3

    Next level Explanation..Love from PAKISTAN.

  • @PankajKumar-cw6rs
    @PankajKumar-cw6rs 4 ปีที่แล้ว

    Sir bahut heen Simple, Sharp, Smart ways se always Explain karte hain app
    Thank you Sir...

  • @kishanbhargav7655
    @kishanbhargav7655 4 ปีที่แล้ว

    Sir you are the best teacher that I found on TH-cam I am watching your video continuously from 3 hrs and even I have no background in this filed but you are able to create so much intrest with you teaching skills thank you sir

  • @rohitmali8670
    @rohitmali8670 5 ปีที่แล้ว

    Thank you .... sir, app ke jesa tutorial koi explain nahi krta hua deka..... mene bahut video dekhi he like movie,songs,tutorails...... unhe like bhi karta hu lekin aj pahilibar comment kar raha hu.... apka explaination A111111111

    • @GateSmashers
      @GateSmashers  5 ปีที่แล้ว

      Wow...Thank You so much for your love and support. Keep learning and sharing

  • @devendraraghuwanshi3136
    @devendraraghuwanshi3136 3 ปีที่แล้ว +1

    Your explanation is incredible an respect you alot. You are very Humble, like ARIJIT Singh

  • @piyushkhanduri2905
    @piyushkhanduri2905 3 ปีที่แล้ว +1

    never understood from college professor thoroughly following you sir you are the best

  • @dipsikhaphukan5563
    @dipsikhaphukan5563 4 ปีที่แล้ว +2

    In love with your explanations. 😊Respect from Assam. Thank you so much for making the critical concepts easily understandable.

  • @vandanapatidar3751
    @vandanapatidar3751 3 ปีที่แล้ว +10

    Today's class is totally depends on your this video.......NITS'S professors also follow you sir❤️......keep it up 🔥🔥🔥

  • @Kp-pn1pz
    @Kp-pn1pz 3 ปีที่แล้ว

    This all videos are best on TH-cam for DBMS

  • @aniruddhagayake2456
    @aniruddhagayake2456 5 ปีที่แล้ว +5

    Thank you so much 🙏🙏 The way you simplify the concepts is really awesome and fantastic👌💯 I really enjoys learning💖

  • @bhargavkakadiya3499
    @bhargavkakadiya3499 3 ปีที่แล้ว +3

    Ohh well-done very very very very amazing explanation.

  • @sakshisingh4516
    @sakshisingh4516 3 ปีที่แล้ว +3

    I just want to tell everyone that this teacher is a gem of a person and the way he teaches is next level. I took a moment to appreciate him and his good work. May you prosper in life and your career. Your career is great ahead. You are too good!!

  • @prikeshsingh5971
    @prikeshsingh5971 3 ปีที่แล้ว +1

    This is best Video for foreign key concepts 🙏🙏🙏🙏

  • @Ashutosh1986
    @Ashutosh1986 2 ปีที่แล้ว

    Your videos are best videos available on TH-cam on the particular topics....keep sharing knowledge bro...Thanks

  • @yummysoup
    @yummysoup 5 ปีที่แล้ว +5

    Thank you sir ,i subscribed to channel just afterwatching 2mins of the video

  • @Abhishekkumar-gr5vr
    @Abhishekkumar-gr5vr 6 หลายเดือนก่อน +1

    Sir aapki videos se padh kar ke, saare subjects easy lagne lagte hai😍🥰.

  • @jatinsidana3971
    @jatinsidana3971 5 หลายเดือนก่อน

    Doing great job, i never thought you will explain this with that much ease.

  • @merida3975
    @merida3975 3 ปีที่แล้ว +6

    Reading text book to get all the concept is impossible for me . But you made things far more better. Thanks a lot😇
    Love from🌴 Kerala 🌴

  • @horainfatima2451
    @horainfatima2451 8 หลายเดือนก่อน +1

    Thank you Sir for such a good lecture you explained it very simply you made complicated topic simple it is easy to understand😍😍👍👍👍

  • @ravidahiya8505
    @ravidahiya8505 4 ปีที่แล้ว

    Sir thank you very much. Nobody can explain this in that simple way. You are genius.

  • @MANISHYADAV-dd4ug
    @MANISHYADAV-dd4ug 3 ปีที่แล้ว

    One of the best teacher that I have ever seen.love you sir❤️❤️❤️❤️

  • @shivangibali9973
    @shivangibali9973 4 ปีที่แล้ว +16

    Hello Sir,
    I've switched my career from finance to IT and that too after working 3 years in Finance domain only. Initially it was so difficult to understand the concept of DBMS, RDBMS , SQL and i was struggling hard to understand the concept and wanted to make strong base in SQL then i came cross your channel. Thanks for amazing studying style.

  • @justgetit5931
    @justgetit5931 4 ปีที่แล้ว

    Really understood evertthing because of your nice and Simple explanation. Thank You so Much.
    God bless You

  • @abhishekbhardwaj3177
    @abhishekbhardwaj3177 3 ปีที่แล้ว

    You are a super hero. Your video helps a lot to developers also. Superb Sir.

  • @priyankahegde6441
    @priyankahegde6441 5 ปีที่แล้ว +1

    I feel it is better to sit and watch your tutorial rather than attending college class.... Such a good explanation 👏thank you so much sir🙏

  • @_PramodHatpaki
    @_PramodHatpaki 2 ปีที่แล้ว

    U give directly practical knowledge

  • @khushbootripathi9889
    @khushbootripathi9889 5 ปีที่แล้ว

    Sab kuch samjh aata h Sir apki videos me...thnkuu so mch for uploading vdeos and explaining evry thng so clearly ❤😄

  • @hassanjaveed2168
    @hassanjaveed2168 ปีที่แล้ว

    Sir your learning way is outstanding. I am confused about this topic but I saw your video and clear up all confusion. ❤ from Pakistan.

  • @sratnamanjari244
    @sratnamanjari244 4 ปีที่แล้ว

    Superb SIMPLY Superb SIR...Explanation..wow

  • @gsgameworld224
    @gsgameworld224 6 หลายเดือนก่อน

    Main diploma cse kar raha hoon dbms mein aapki video bahut bahut helpful hain sir....
    Bahut bahut thank u sir...

  • @deepaktrivedi8977
    @deepaktrivedi8977 8 หลายเดือนก่อน

    Beautifully Explained. Whan an amazing Teacher

  • @surajitdas94
    @surajitdas94 5 ปีที่แล้ว +2

    So far so good. Nice explanation. Thanks a lot for your time. Really appreciate it.

  • @raginisingh8000
    @raginisingh8000 3 ปีที่แล้ว +1

    Such a beautiful explanation. your teaching skills are awsm.

  • @kanavghai887
    @kanavghai887 4 ปีที่แล้ว +40

    16:36 punjabi maxx "two taa" XD

  • @abhishekbobade2366
    @abhishekbobade2366 2 ปีที่แล้ว +1

    explained in very easy way..........thanks sir

  • @princemehndiratta3193
    @princemehndiratta3193 2 ปีที่แล้ว

    seriously very useful concept to keep in mind .. thank u for such good explanation

  • @vaijanti2192
    @vaijanti2192 4 ปีที่แล้ว +1

    Finally aaj concept clear ho gye ..thnku so much sir😊

  • @vikasvarshney1681
    @vikasvarshney1681 2 ปีที่แล้ว +1

    Thanks a lot sir for making these great explaination videos..!!!
    Very useful videos for me.

  • @bhishamlalmandle5390
    @bhishamlalmandle5390 5 หลายเดือนก่อน

    Very important topic aur aap ise simple language me teach kiya thank you sir

  • @anishchar4282
    @anishchar4282 2 ปีที่แล้ว

    One of the best teacher as I have seen Before
    Thanks sir 🙏🏻

  • @onetirtha
    @onetirtha 3 ปีที่แล้ว

    Lots of love and respect for You Varun Sir. Aap kitne wonderful padhate ho.. ♥️

  • @kiranjeetish
    @kiranjeetish 3 ปีที่แล้ว

    I love your channel. So easy for teaching sql. Thanks

  • @rockeykumar3348
    @rockeykumar3348 2 ปีที่แล้ว +1

    College teacher and other teachers need to learn from this lecture and teaching style of sir amazing 😘❤️❤️🙏

  • @jyotsnakumari3330
    @jyotsnakumari3330 3 ปีที่แล้ว

    AWESOME!!!!!!! LOVED IT!!
    THE CONCEPT WAS SO BEAUTIFULLY EXPLAINED.

  • @14shahinsiddiki31
    @14shahinsiddiki31 4 ปีที่แล้ว

    Sir your teaching way is absolutely unique and wonderful

  • @deepa8177
    @deepa8177 2 ปีที่แล้ว +1

    got clarity in depth.

  • @alauddinpatoary8349
    @alauddinpatoary8349 4 ปีที่แล้ว

    simple and very easy explanation even though I am Bangladeshi but your explanation is very easy to understand for me.Thanks, a lot

  • @_its_adi_baba_2
    @_its_adi_baba_2 2 ปีที่แล้ว

    Sir aapke padhane ka tarika MASAALLAH 🥰

  • @MaanVihaan
    @MaanVihaan ปีที่แล้ว

    Supper! maine aisa explanation kahi nahi suni thanks sir

  • @manpreetsaini8547
    @manpreetsaini8547 4 ปีที่แล้ว +1

    U r d bst sir...... U r my fav. Tutor on u tube. Mind blowing explanation nd u take examples are fabulous.... I wish dat u became my tution teacher😅❤❤

  • @beginnerbuddy498
    @beginnerbuddy498 4 ปีที่แล้ว +2

    you are a GEM sir. Thank u so much. You Deserve More heights. Not only gate aspirants but many other students like me also take advantage of it. Thank U.

  • @iraxyt
    @iraxyt 2 ปีที่แล้ว +1

    5/5, The way how you teaching is awesome Sir.

  • @rohandubey1722
    @rohandubey1722 5 ปีที่แล้ว

    Bhot sahi awesome very nice ......clearly clear all doubts related to foreign key , primary key - integrity kab loss hogi ek dum jhakkassss

  • @KingKhan-ne6ew
    @KingKhan-ne6ew 4 ปีที่แล้ว +1

    outstanding teaching sir ......................................................................................

  • @ginadekeana
    @ginadekeana 5 ปีที่แล้ว +2

    I think you are really good. cheers and thanks i'm praying with your lectures I answer well in my university exams approaching next month

  • @AI-zw1rz
    @AI-zw1rz 5 ปีที่แล้ว +5

    brother you are best and literally i have become your fan and you got one more subscriber love you 3000

  • @shashwatdhingra3580
    @shashwatdhingra3580 2 ปีที่แล้ว +1

    GLAD TO SAY THAT, EVERYTHING'S CLEAR. THANKS SIR!! 🙏

  • @aniketnangare904
    @aniketnangare904 ปีที่แล้ว

    Such a simple and concise explanation thank you very much sir

  • @itsolutionseducation6551
    @itsolutionseducation6551 2 ปีที่แล้ว +1

    This lecture=100 times of college lecture very very thankful sir🙏🙏🥺

  • @sairariaz491
    @sairariaz491 3 ปีที่แล้ว

    Your teaching method is very unique
    Thanks a lot for your effort and such unique lectures😊
    Stay blessed
    Stay healthy
    May GOD Bless you more success

  • @fatimagee4850
    @fatimagee4850 3 ปีที่แล้ว

    Just fabulous info. A well teaching method

  • @ashutoshsingh4932
    @ashutoshsingh4932 2 ปีที่แล้ว

    Thank you so much sir for this video. I was very confused about this topic but after watching this video, everything is crystal clear!!

  • @pradeeppatwal6564
    @pradeeppatwal6564 3 ปีที่แล้ว

    Awsome presentation of primary key and foreign key

  • @adarshgautam101
    @adarshgautam101 2 ปีที่แล้ว

    every time whenever i watched this video it helps me to improve my self