Database Design 50 - Self Join

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 61

  • @cylemmulo
    @cylemmulo 5 років тому +41

    Better finale than Game of Thrones

  • @osamaahmed9230
    @osamaahmed9230 2 роки тому +6

    Jazak Allah Brother!!!❤
    This series is really helpful, this is my first time undertaking your course. It was worth the time and effort. Helped too much in my internship Bro!👍

  • @srichmon
    @srichmon 4 роки тому +6

    Watched the whole series in one day at 2x, great content!

  • @aeromina
    @aeromina 9 років тому +23

    Caleb thank you so much for all what you did. Without you I would've been lost in loads of documentation to understand all that. Are you planning to proceed with this series ?? Greetings from Egypt!!

  • @sarbenjckanu3726
    @sarbenjckanu3726 8 років тому +6

    Man i like your video series and they are all nice and helpful. i want you to know that you are God sent, because i was once a chorister, but because i was able to go through your musical theory videos, now i am been appointed as the church assistant choir master. One thing that makes me able to go through these video was the fun on the 57 video series

  • @SimpleJLee
    @SimpleJLee 5 років тому

    Caleb, just want to echo what everyone has said and say thank you! I’ve tried watching database videos from other sources and was so dry I could not endure. I stumbled upon your video and praise God for it! You have a gift and have a very easy and humorous way of explaining concepts- keep it up!

  • @Iffe4
    @Iffe4 5 років тому +3

    Thanks man, the whole series was very informative and the way you taught is amazing.

  • @rolinejohnaguilar7819
    @rolinejohnaguilar7819 3 роки тому +4

    2020 and still helpful

  • @fa1th492
    @fa1th492 4 роки тому

    All the last nine episodes have been absolutely great, you sir are not only funny, but you help quite a bit with concept visualisation and well thought examples.

  • @thun-55
    @thun-55 4 роки тому

    Hey Caleb, i dont know how to say how lucky i am to came across your tutorial! Million thanks to make Database design becoming so much fun and simple to understand for me. I like all your vdo it’s so genuine and fun to follow. Keep going, you are the BEST!! Also, i just click fo donate for your amazing work!

  • @jackyzhang7988
    @jackyzhang7988 8 років тому +1

    Excellent courses. Especially the last one "Self Join" resolved my problems. Thank buddy!

  • @chelsearosalie6581
    @chelsearosalie6581 8 років тому

    I had been working on a problem for my class with a self join and having so much difficulty. This tutorial was so helpful, thank you so so much!

  • @mohamedtaha2014
    @mohamedtaha2014 5 років тому +1

    If I try to thank you for all the time and efforts you gave in to present this great content, it wouldn't be enough, Now I can say I have more conceptual understanding of how the Database works, you have a great way of teaching and you also make it fun, thank you and keep going!

  • @brandonbischof2479
    @brandonbischof2479 5 років тому

    By far the best informative overview of a course I have ever watched. Your videos had me laughing all of the way through, as I learned so much about database. I hope to pass my test tomorrow thanks to you! Keep up the good work, if you where my teacher I never miss a class.

  • @desisto007
    @desisto007 5 років тому +1

    I love the way you explain things, thank you so much for doing this useful videos!

  • @krappr
    @krappr 2 роки тому

    after hours and hours, i finally finished it. its a nice course

  • @rogersourm4650
    @rogersourm4650 5 років тому +1

    Great series. You made it very easy to follow along. Thank you!!!

  • @JosephKalarickal
    @JosephKalarickal 2 роки тому

    Hilarious! I had to stop to show my brother this wonderful resource too - thank you!!

  • @joshmorgan7406
    @joshmorgan7406 5 років тому +1

    Thank you very much Caleb! You're an excellent teacher!

  • @Andrey-ny2dv
    @Andrey-ny2dv 6 місяців тому

    Thanks, man, for the awesome series! I have learned a lot!

  • @someone4860
    @someone4860 3 роки тому

    I am from the future 2021 Caleb. was looking for relationship Tips, and end up finishing Data Base Design😁.

  • @Roshan-Dube
    @Roshan-Dube 6 років тому +1

    I watched full course of database design...It is actually very good contents you have explained..
    but I think you should at least add two more videos in this series about
    1) how to design schema
    2) nested tables

  • @nikhilasree1404
    @nikhilasree1404 4 роки тому

    Completed the series successfully

  • @AmbesiweMajavu
    @AmbesiweMajavu Рік тому

    thank you so much Caleb!

  • @incomingtide9549
    @incomingtide9549 2 роки тому

    hey @Caleb STILL waiting for the sequel of this wonderful playlist

  • @narenlal6614
    @narenlal6614 7 років тому +1

    You are awe inspiring man! Keep going!

  • @bhavanakumar5434
    @bhavanakumar5434 9 років тому +1

    what about the full outer join that u had mentioned in your previous video?
    thank you for the series:)

  • @abdulhadialarbid5060
    @abdulhadialarbid5060 3 роки тому

    Thank you so much.. Impressive work

  • @lydiamiller7910
    @lydiamiller7910 Рік тому

    This is so helpful! Thank you :D

  • @Diegoo1997
    @Diegoo1997 8 років тому +1

    You've saved my life! Thanks man :)

  • @edwardoakley8659
    @edwardoakley8659 3 роки тому

    Awesome stuff. Much easier to digest than documentation :)

  • @deannaarrants9713
    @deannaarrants9713 7 років тому

    Brilliant Explanation. Thank you very much Caleb.

  • @timjamesd
    @timjamesd 4 роки тому

    Thanks for the video Caleb. Let's say I have John (the first user) who referred Mike, and then Mike referred Suzy, and then Suzy referred Dan. Using self-joins, how can I link Dan back to John? How can I find the "original" referee for any given user i.e. the user at the end of the chain. Thanks!

  • @Github_tech_with_ty
    @Github_tech_with_ty 2 роки тому

    Great series

  • @elsonlleshi7718
    @elsonlleshi7718 5 років тому

    Just eded all series i learned more than in my school thank u.

  • @brianmurphy8092
    @brianmurphy8092 8 років тому

    Thanks man. Excellent course for a beginner

  • @pramodar6437
    @pramodar6437 6 років тому

    Couldn't be better. Thanks Man.

  • @pamount
    @pamount 6 років тому

    Can you link to examples of full database designs that use these tables and how they relate to other tables in one to many as well as many to many relationships (i.e. with join tables)?

  • @victort.223
    @victort.223 3 роки тому

    I don't understand how ahhhpphfff matched the id with Samuel- is ahhhpphff doing ok during covid?

  • @santhu4444
    @santhu4444 7 років тому

    great video series and great skills and hold on the topic.... thanks a lot Caleb for this vieos.... :)

  • @shivaprasadbk2027
    @shivaprasadbk2027 5 років тому

    Cool! awesomely explained, thanks.

  • @danilloluiz
    @danilloluiz 5 років тому

    Thanks so much, man! Very good!

  • @LoveIndia3
    @LoveIndia3 8 років тому

    Really a good video.. i can proudly say now.. i know Self join very well :) Thankkkkkk youuuuuu so much :)

  • @jetpaq
    @jetpaq 9 років тому +3

    I watched all of these in two days,,"Keanu Reeves voice" I KNOW KUNG FU!!! LOL this series is great..! starting from the beginning again. Is there an SQL playlist to bro?

  • @dalerpulatov616
    @dalerpulatov616 5 років тому

    Outstanding!

  • @zedhane7815
    @zedhane7815 8 років тому

    Caleb...I hate your videos ...that's what I felt initially .:P Man love your videos and I watched all the videos from this series within less than a week and I learnt a lot about databases. A week back I knew nothing about databases and now I know how it works and a lot more. Really appreciate your work. Thanks a ton. Am learning a lot through your videos. Please continue making valuable content.
    P.S- I wish I could support you on patreon. But wait-for-it I will definitely sponsor you soon once I get a job.

  • @NicolaeCristian175
    @NicolaeCristian175 5 років тому

    Very good tutorial. thanks

  • @admiralrohan
    @admiralrohan 5 років тому

    What would happen if you didn't assign any alias to v2.email as there is another field named v1.email?

  • @nefertalakkad
    @nefertalakkad 7 років тому

    Is there a way to do a self join without aliases?
    P.S. Thank you for all your videos Caleb! ^_^

  • @CondeNastCruiser
    @CondeNastCruiser 4 роки тому

    Thanks for the help :)

  • @shumandaniele
    @shumandaniele 4 роки тому

    Could you please spell the name at 8:54? Thank you.

  • @wurzelwerk7370
    @wurzelwerk7370 9 років тому +1

    peace on earth !

  • @laissezfairez
    @laissezfairez 7 років тому

    Caleb, Thanks so much for the video.. Can I get some help from you, doing SQL Re-Factoring? I cannot find any video about this on youtube. Thanks in advance.

  • @parvizhagverdiyev5232
    @parvizhagverdiyev5232 4 роки тому

    man, i just liked your video for calling the second guy like. xD

  • @andrew5407
    @andrew5407 6 років тому

    wonderful

  • @abdulrahmansalah34
    @abdulrahmansalah34 9 років тому

    keeping the good work :)

  • @cholowao
    @cholowao 9 років тому

    So when it ends

  • @imcracked4045
    @imcracked4045 6 років тому

    Shouldn't these dependencies be removed via normalization and thus, self-joins being deemed useless?

    • @jbeadle6
      @jbeadle6 6 років тому

      I was thinking the same thing

  • @annachan6706
    @annachan6706 4 роки тому

    skip the first 45 seconds

  • @Joshnpk
    @Joshnpk 6 років тому

    Great Series