Database Design 50 - Self Join

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

КОМЕНТАРІ • 64

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

    Better finale than Game of Thrones

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

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

  • @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!👍

  • @sarbenjckanu3726
    @sarbenjckanu3726 9 років тому +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

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

  • @jstnflnt
    @jstnflnt 10 днів тому

    Just finished the series, it was amazing. Thank you for taking the time to create something so helpful

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

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

    2020 and still helpful

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

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

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

  • @ajaysan2765
    @ajaysan2765 24 дні тому

    Just completed the series, thank you so much Caleb!

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

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

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

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

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

    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.

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

  • @shannonrenee5449
    @shannonrenee5449 2 місяці тому

    Thanks! I watched your whole video series and it was very helpful.

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

    Completed the series successfully

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    thank you so much Caleb!

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

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

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

    You are awe inspiring man! Keep going!

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

    Awesome stuff. Much easier to digest than documentation :)

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

    You've saved my life! Thanks man :)

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

    Brilliant Explanation. Thank you very much Caleb.

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

    Couldn't be better. Thanks Man.

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

    Thank you so much.. Impressive work

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

    This is so helpful! Thank you :D

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

    Thanks man. Excellent course for a beginner

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

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

  • @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)?

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

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

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

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

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

    Thanks so much, man! Very good!

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

    Cool! awesomely explained, thanks.

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

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

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

    Outstanding!

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

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

    Thanks for the help :)

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

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

    Very good tutorial. thanks

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

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

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

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

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

    Great Series

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

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

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

    So when it ends

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

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

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

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

    peace on earth !

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

    wonderful

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

    keeping the good work :)

  • @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 5 років тому

    skip the first 45 seconds

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

    Great series