6.7 Union Intersection and Set Difference Operator Relational Algebra in DBMS

Поделиться
HTML-код
  • Опубликовано: 5 янв 2025

Комментарии • 106

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Год назад

    For complete DBMS, check out this video: ruclips.net/video/YRnjGeQbsHQ/видео.html

  • @sarthakdarji465
    @sarthakdarji465 5 лет назад +3

    Excellent explanation sir...I have now got interest in DBMS because of your lecture tutorials...big fan.

  • @anmolsahu3247
    @anmolsahu3247 4 года назад +19

    Gobar milega really cracked me 😂😂

  • @anusingla611
    @anusingla611 6 лет назад +45

    Sir I was soo busy in listening you..and suddenly you said.. "go*** milega"
    Sorry,but that was very funny 😂 and jokes crack krte rehna chahiye..students doesnt get bored.
    Thankuh soo much for all your help.😊

  • @raviraj8209
    @raviraj8209 6 лет назад +18

    " kisi tough topic pr aapka video available hai" bas itna bhi pata chal jaye to Jaan me jaan aajati hai. because then i know , i dont have to worry abt that topic :D . Thanks alot sir.. for being there. upar wala aapko hamesha salamat rakhe.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 лет назад +23

      bahut bahut shukriya Raviraj aapka.. Main try karta hu jitne difficult topics hain and jo bacho ko chahiye un par video bana kar daal du.. Acha hai aap log unse sikh rahe hain.. PAdhte aur sikhte rahiye..

    • @MagicMan-po5oq
      @MagicMan-po5oq 6 лет назад

      Hello Raviraj! I am in need of some help with my assignment this week. I need some help related to the matter of this video and I am willing to pay 2000 rupees for your help. Please let me know if that sounds like a fair deal to you!

    • @sasswithdivyanshi
      @sasswithdivyanshi 4 года назад

      @@KNOWLEDGEGATE_kg you are really awesome ....

  • @puju5085
    @puju5085 5 лет назад +2

    Great methods of teaching.....Sir.... thanks for providing such a informative videos

  • @ronaksoft.er.8758
    @ronaksoft.er.8758 2 года назад +3

    Gobar milega.... Very funny 🤣😝😜

  • @JayPatel-od4od
    @JayPatel-od4od 2 года назад +2

    6:30 pe sir majakiya mood me aa gaye

  • @dheerajtiwari9923
    @dheerajtiwari9923 6 лет назад +2

    Tnku sir for ur support.becouse teacher makes this subject boring.sir you have great knowledge really u don't have any idea about ur knowledge.again thank you sir

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 лет назад +5

      Hey, Thank you so much for appreciating our efforts in
      Knowledge Gate.
      As you know we are a non-profit organization and our
      services are free of cost, but to keep going we need your support in this
      mission of providing quality education to every computer science student in his
      or her home.
      We need your support as in 5 mins of your time can help us a
      lot in this mission. Your review/recommendation and some words can help
      validating our quality of content and work..
      so Please do the following: -
      1) Follow our facebook page and give us a 5 star review with
      comments
      facebook.com/pg/knowledgegate.in/reviews
      2) Give us a 5 star review with comment on Google
      goo.gl/maps/sLgzMX5oUZ82
      3) Follow us on Instagram
      instagram.com/mail.knowledgegate/
      4) Follow us on twitter
      twitter.com/knowledgegate3
      At last if you are able and want to make monetary
      contribution towards the mission to help more and more students, then you can
      Paytm Using
      p-y.tm/tn-DcCI
      Thank you so much for your time..
      Sanchit Jain

  • @manojji969
    @manojji969 6 лет назад +8

    I am eagerly wait for your videos ,everyday

  • @epicclips8881
    @epicclips8881 4 года назад +1

    Op Explanation Sir 👍👍👍👍👍

  • @Shinigami1209
    @Shinigami1209 5 лет назад +2

    you are such an adorable teacher..

  • @piyush-A.I.-IIT
    @piyush-A.I.-IIT 6 лет назад +4

    Thank u Sir. Sir, after completing this series, please upload videos on decideability undecidability NP hard NP problem.
    Sir this topic is tricky and my college teachers also dont have good knowledge on these topics. Only premium gate institution taught these topics clearly but they are paid. Sir please upload these topics next , before gate 2019. It will be really helpful.

    • @roselatte2625
      @roselatte2625 6 лет назад +1

      U r right. I also need help.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 лет назад

      i promise will complete it before gate 2019

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  6 лет назад +5

      Hey, Thank you so much for appreciating our efforts in
      Knowledge Gate.
      As you know we are a non-profit organization and our
      services are free of cost, but to keep going we need your support in this
      mission of providing quality education to every computer science student in his
      or her home.
      We need your support as in 5 mins of your time can help us a
      lot in this mission. Your review/recommendation and some words can help
      validating our quality of content and work..
      so Please do the following: -
      1) Follow our facebook page and give us a 5 star review with
      comments
      facebook.com/pg/knowledgegate.in/reviews
      2) Give us a 5 star review with comment on Google
      goo.gl/maps/sLgzMX5oUZ82
      3) Follow us on Instagram
      instagram.com/mail.knowledgegate/
      4) Follow us on twitter
      twitter.com/knowledgegate3
      At last if you are able and want to make monetary
      contribution towards the mission to help more and more students, then you can
      Paytm Using
      p-y.tm/tn-DcCI
      Thank you so much for your time..
      Sanchit Jain

    • @piyush-A.I.-IIT
      @piyush-A.I.-IIT 6 лет назад +1

      @@KNOWLEDGEGATE_kg Subscribed Liked Share Done. Facebook Done.

  • @sanchitjainfanclub3620
    @sanchitjainfanclub3620 6 лет назад +1

    Sir please keep doing this great work.

  • @gursidaksingh2407
    @gursidaksingh2407 4 года назад +5

    sir in Q3 can we do set difference(Costumer - account -borrower) instead of doing union of acc and borrower and then doing set difference

  • @kailasgode7313
    @kailasgode7313 6 лет назад +1

    hi great video pls explain correlated and nested queries also after this topic they r really confusing

  • @ash-xl3bb
    @ash-xl3bb 4 месяца назад

    Thankyou so much sir for all the content you are providing us for free. Sir I have exams in dbms and unable to find a good video for query optimization and processing. Could you please make videos on these topics. That would be really helpful 🙏

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  4 месяца назад

      Sure dear, will try to consider your suggestion, stay connected👍

  • @bichitraranjandas
    @bichitraranjandas 6 лет назад +1

    Everyday eagerly wait for your video .

  • @VideoLanxer
    @VideoLanxer 4 года назад

    very nice idea of teaching

  • @NehaKumari-ns5rq
    @NehaKumari-ns5rq 6 лет назад +1

    Thnkuuu sir...eagerly waiting for next video

  • @lalsingh3900
    @lalsingh3900 5 лет назад

    Thanq sir, sare doubts clear ho gaye....

  • @jnvprep.academy2605
    @jnvprep.academy2605 6 лет назад +2

    Thanku so much sir for such nice video

  • @AlokKumar-xv7lp
    @AlokKumar-xv7lp 4 года назад

    Gobber milega ... wo to hmare gao me milega 🤪 .... you are very funny but so interesting about learning and teaching ... thank a lot respected sir

  • @tanmaydubey3381
    @tanmaydubey3381 3 года назад +2

    6:32-->Gobar milega😂😂😂

  • @epicclips8881
    @epicclips8881 4 года назад

    Op Explanation Sir ❤️❤️❤️❤️❤️

  • @vaishali7538
    @vaishali7538 4 года назад

    Thanks sir🙏🔥

  • @dhruvpolara8487
    @dhruvpolara8487 2 года назад

    is this okay at last question??
    10:35
    { (pie) cust_name(customer) - (pie) cust_name(dipositor) } - {(pie) cust_name(borrwer)}

  • @ShreyaPatil1008..
    @ShreyaPatil1008.. 10 дней назад

    Thank you so much sir

  • @ashoksinghadia4819
    @ashoksinghadia4819 6 лет назад

    Thanks sir. Nice

  • @Talhatravel2
    @Talhatravel2 5 лет назад +11

    6:31 GOBAR MILEGA

  • @OmitA25
    @OmitA25 6 лет назад

    very nice......explanation.....

  • @anuragkroy_
    @anuragkroy_ 5 лет назад +1

    thankyou sir
    itna simple way me hamare college me b nahi padhaya jata

  • @khushindpatel
    @khushindpatel 4 года назад

    Thank you very much sir

  • @maazahmadsatti736
    @maazahmadsatti736 5 лет назад

    thanks

  • @paarthsoin3615
    @paarthsoin3615 6 лет назад +16

    gobar line was lit 🔥. XD

  • @hardikgarg3424
    @hardikgarg3424 6 лет назад +2

    sir please upload the video of b , b+ trees and joins sir please do it
    requesting from long time

  • @namratakhadanga6533
    @namratakhadanga6533 6 лет назад

    thank u so so much sir,SQL queries plz

  • @itsshadow619
    @itsshadow619 5 лет назад

    Please make videos on Compiler design and computer graphics

  • @narendraparmar1631
    @narendraparmar1631 6 лет назад

    Thanks sir ji 😆

  • @sheffalibarola4290
    @sheffalibarola4290 6 лет назад

    sir please videos for derived form ? ..eagerly waiing sir .....

  • @somyasingh4855
    @somyasingh4855 5 лет назад

    Gobar milega..Bhtt funny tha ye 😂😂😂

  • @pratapkumar3434
    @pratapkumar3434 4 года назад +4

    Nhi padhoge toh kya milega 6:31

  • @deepshikharajput5069
    @deepshikharajput5069 6 лет назад

    thanks u so much sir.

  • @tohidulislam4300
    @tohidulislam4300 6 лет назад

    Thanks sir

  • @codewithnofear
    @codewithnofear 3 года назад +2

    sir QNO.3 me 'nor' nahi hain aapne 'or' likha huwaa hain so according to question ans is PROJECTION FROM TABLE DEPOSITER CUS_NAME - PROJECTION FROM TABLE BORROWER CUS_NAME hoonaa chiyena sir .... i confusion in this part sir

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  3 года назад

      Drop your query in our discussion forum t.me/KGgatefreeclasses, KG mentos will help you out !!

  • @TechByte8
    @TechByte8 Год назад

    Thanks sir.

    • @KNOWLEDGEGATE_kg
      @KNOWLEDGEGATE_kg  Год назад +1

      Most welcome! Keep learning & supporting! You can also visit our website www.knowledgegate.in for more amazing videos & contents👍😊

  • @sumansoni4249
    @sumansoni4249 6 лет назад

    thank u sir

  • @RaviSingh-yf6jd
    @RaviSingh-yf6jd 5 лет назад

    Thanks sir but also upload computer graphics

  • @ankitrai4935
    @ankitrai4935 6 лет назад

    Tq sir

  • @AshishSingh-sy3gn
    @AshishSingh-sy3gn 4 года назад

    Sir, is union and intersection same as OR and AND?

  • @shubhangihatkar1347
    @shubhangihatkar1347 3 года назад

    👍🏻👍🏻👌🏻

  • @ShAerMusic
    @ShAerMusic Год назад +1

    6:30 😂😂😂😂

  • @sushmitha2468
    @sushmitha2468 4 года назад

    If the " set difference" of two relations will always give the fisrt relation. Then y should we use " set difference"
    Qno.6 fr example we can just take branch_name of Account table.

    • @gursidaksingh2407
      @gursidaksingh2407 4 года назад

      not first relation but first relation excluding some values in first relation which are also existing in second relation

  • @Nature-iw2ez
    @Nature-iw2ez 5 лет назад

    sir please division operator ki bhi video upload kardijiye

  • @Jonathan-ng4vw
    @Jonathan-ng4vw 2 года назад

    fan U tube_light = polycab wire

  • @raghavclasses4587
    @raghavclasses4587 6 лет назад

    Bhai main kya batau main library me baitha tha lekin apne apko hasne se rok nai paya jab Sir bole ki Union karne se kya milega... Gobar milega...maa kasam..

  • @Chunuthedhaba
    @Chunuthedhaba 5 лет назад

    mai lagtar es series ke bahut sari vedio dekh li...aur esme hang ho rhi thi...fir v trying to listen...jaba aapne achank se bola "gobar milega...."i was like ye kya tha...hahahhahhahhhahhahhhahhahhhahhahhhahhhahhahahhahahhahaha XDXD

  • @KNOWLEDGEGATE_kg
    @KNOWLEDGEGATE_kg  Год назад

    🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
    🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

  • @keshavnarayan4637
    @keshavnarayan4637 6 лет назад

    Sir i want to learn about DMA & DMA controller from whrere i found these videos

  • @shekharpatankar8208
    @shekharpatankar8208 6 лет назад

    Sir can you plz upload the video on b+ tree

    • @MagicMan-po5oq
      @MagicMan-po5oq 6 лет назад +1

      Hello Shekhar! I am in need of some help with my assignment this week. I need some help related to the matter of this video and I am willing to pay 2000 rupees for your help. Please let me know if that sounds like a fair deal to you!

  • @prateekdhingra7033
    @prateekdhingra7033 6 лет назад

    Sir relational calculus p video dedo mera Monday Ko exam hai please sir

  • @monikasahu4500
    @monikasahu4500 6 лет назад

    Sql par video banaye sir

    • @MagicMan-po5oq
      @MagicMan-po5oq 6 лет назад

      Hello Monika! I am in need of some help with my assignment this week. I need some help related to the matter of this video and I am willing to pay 2000 rupees for your help. Please let me know if that sounds like a fair deal to you!

  • @akshitarawat1970
    @akshitarawat1970 5 лет назад +1

    Sir ..hw can a customer be a customer without an account in the query in this lecture?

  • @muhammadosama5521
    @muhammadosama5521 5 лет назад +6

    did you see that gobar milega part coming? xD

  • @manavmalhotra8513
    @manavmalhotra8513 5 лет назад

    Why union in last query
    Not or?????

  • @Ujjwal_dreams
    @Ujjwal_dreams 5 лет назад

    Sir ,I m Not able to speed up the video to 1.5x ....please turn it on from ur side .....

  • @bidsouravbest
    @bidsouravbest 5 лет назад

    Sir you haven't told about foreign key!

  • @dond1014
    @dond1014 6 лет назад

    Gobar nahi milega paper mai aapki video dekh li sarri DBMS ki 80+ sarri dekh daali ek din mai

  • @shivangigupta6156
    @shivangigupta6156 6 лет назад

    Sir SQL ki video kha ha

  • @sarmisthasaha3009
    @sarmisthasaha3009 5 лет назад +5

    Sir meri exam hei tomorrow ..... R aap Ki baat sunke, "gobar milega "😂😂😂 meri hasi hi nehi ruk rehi !

  • @SureshNayak-bw4lq
    @SureshNayak-bw4lq 9 месяцев назад

    gober milega was thop

  • @raghavendrabhadauria5426
    @raghavendrabhadauria5426 5 лет назад

    Hamare clg mn toi ese nhi padate

  • @TheGheezoinky
    @TheGheezoinky 6 лет назад

    Gobar milay ga !!

  • @0_PeaceOfMind_0
    @0_PeaceOfMind_0 5 лет назад +1

    Gobar..... 😂😂😂😂

  • @ajitsafeway
    @ajitsafeway 5 лет назад

    Gobar 😂😂👏

  • @badanhembram
    @badanhembram 4 года назад

    kya milega ??? gobar milega supp sr

  • @dinu_04
    @dinu_04 5 лет назад

    Gobar Milega...hahahahah

  • @initiator0016
    @initiator0016 6 лет назад

    Gobar!! omg i literally can't stop laughing

  • @sanchitjainfanclub3620
    @sanchitjainfanclub3620 6 лет назад

    Sir monitise the video permanent

  • @sumeetkumar298
    @sumeetkumar298 4 года назад

    Thanks

  • @rishabhmathur6690
    @rishabhmathur6690 6 лет назад

    Thanks Sir

  • @NishaSharma-nd1dk
    @NishaSharma-nd1dk 3 года назад +2

    Thanks sir g