Database Design 41 - Introduction to Joins

Start your software dev career - calcur.tech/de... 💯 FREE Courses (100+ hours) - calcur.tech/al...
🐍 Python Course - calcur.tech/py...
✅ Data Structures & Algorithms - calcur.tech/ds...
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/ne...
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/sub...
👨🏻‍🎓 Courses - www.codebreakt...
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com...
🅿 Patreon - calcur.tech/pat...
🅖 GitHub Sponsors - github.com/spo...
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/cr...
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/cr...

[@eboxwilson99]

Stepping up to the White board game lets goo!!

[@zaijienantao_jiege]

"Skipping class, now need help", yeh, that's me!LOL

[@wisdom-for-life]

"grandma readable table" That's awesome - I will be using this myself.. lol

[@smoothbeak]

Caleb getting nervous because he's about to write the devils number ;)

[@saramassoud9434]

so, i have a final exam in 4 hours and you're my slacker-ass' hero vallah. here, have my heart 😭💖💖💖💖💖💖

[@dereknelson3802]

Thank you so much for this series of vids. I'm in an online class that does not have a formal lecture and having a real person explain everything helps tremendously.

[@Priyanka-hk8wl]

The introduction "hey you slackers you skipping classes" Hahaha .... so true :P Anyways, your videos are really great ! Now i don't find DBMS boring! Good job :)

[@kennielarsen940]

Sir, you're a champ in databases! Your videos really help me understand the material covered in my course - 10x better than what my lecturer or curriculum book for that matter can do it! :-)

[@mingoflomingo8101]

HEY YOU SLACKER! HAHAHA!!!!! Best start ever!

[@maliraza3696]

Wao, what a new white board.

[@ahmadrezaazimi5739]

hey Caleb! brother your awesome ,Iam always watching your videos . God bless you make a video on natural join . I ve stuck thier.

[@ahmadrezaazimi5739]

there.

[@kushagrasharma6897]

thanks for such good explanation

[@mjshaheed]

Thank you, Caleb. You are awesome!

[@titorojas7703]

THUMBS UP FOR CALEB !

[@dannylopez8734]

Thanks you! You are covering the advanced SQL chapter in my DB class.

[@KingOfCorinth]

Yes, syntatical is a word

[@coyfrisk5834]

That intro was too real.

[@ellieworsley8680]

I love your videos Caleb! They've helped me so much with my Database Techniques, exam and coursework! I was wondering if you're going to cover any of the stuff about Relational Algebra and Relational Calculus at all? In my Database Techniques module we cover all of the Relational Algebra and Relational Calculus stuff with all of their Joins and all their operations (Selection, Projection, Union, etc.) the sort of joins we do is: Theta Join, Equijoin, Natural Join, Outer Join, Semi Join and Division. I'm really struggling to get my head around them, but I'm sure your videos would be a massive help. Thank you so much!

[@codebreakthrough]

Ellie Worsley Hi Ellie, To be honest, some of these I have not heard of. I'd love to hear more about the ones I don't know, though. Because I wouldn't mind maybe making videos over them. An equijoin is based on an equality. So for the examples I gave in these videos I had an ON table.column_id = table.column_id. That makes it an equijoin! I have a video over outer joins. In fact, I have a good amount on inner and outer joins and doing them across 2 or 3 tables. I will hopefully be making a video on Union within the next few weeks (probably not in time for when you need it haha). A natural join works the same way as an inner join or outer join or whatever, the only difference is that it will try to figure out what columns to join automatically by itself. So rather than saying user_id = user_id for example, it will figure that out automatically because it's the only column that is in both tables. Don't think that each join is its own thing. An inner join can be a natural join, or an inner join can be an equijoin. natural join and equijoins are a different thing than outer and inner joins. natural and equijoins refer to how you join data while inner and outer refers to what data to return... if that makes sense. Probably not though because I'm awful at explaining things through comments. So just check out the rest of this series :)

[@ellieworsley8680]

CalebTheVideoMaker2 Hey Caleb, I see the EQUijoin now, EQUals... Lol, thank you! With my course we study Relational Algebra and Relational Calculs like I mentioned before, this means that we study the Relational Algebra Operations, one of them being the Cartesian Product. The Cartesian Product defines a relation that is the concatenation of every tuple of realtion R with every tuple of relation S, e.g. relation R, has column a and column b and Relation S has column 1 column 2 and column 3. Therefore to carry out the cartesian product you would times the number of columns by each other; 2 x 3 would give our new relation 6 tuples: a1 a2 a3 b1 b2 b3 Therefore because we do this we use the Cartesian Product in our joins meaning we only use two relations (probably for the simpler lol). I have looked at your join videos and they have actually been a big help so thank you! And thank you for getting back to me! :) Take Care, Ellie.

[@CandiceMacDonnell]

Thanks for this series!

[@codehelmet5173]

You are the best

[@AjayKumar-dv4pq]

Analization?! I think you meant Analysis (1:52). But loved the way you said it boldly, without batting an eyelid !

[@codebreakthrough]

Sorry I meant analyticalizationalysis!

[@AjayKumar-dv4pq]

@@codebreakthrough : )

[@samuelschwartz6222]

Syntactical and analyzation are words. But 100%, analization is not a word. And analyticalizationalysis, well... Please get on it Merriam-Webster!

[@tzezc]

666...hahahah thanks a lot!

[@Mattmath]

Thie is great video! Thank you sir.

[@abrorakhmedov7389]

if we make join tables doesn't it take more resources?

[@katezhang4376]

Good job!

[@JIMMI_CANADA101]

You aer a smart S.OB

[@ayasswain]

Ha..Ha..The way you started..Hey you ...skipping classes.... You are cute and funny. Your classes are so nice and easy to understand.

[@mlgquickscoper8122]

no classes skipped here pal

[@saywhat4229]

ya u did

[@TheJaygregory]

WHITEBOARD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Shocked lol

[@beinganoopsethu]

Informative!

[@yusufzaidi]

Awesome :)

[@JohnSmith-hn6kv]

The number of the beast haha.

[@ericdean72]

A marker board!?!?!?

[@mishajacobs6748]

Lol I’m a grandma :( but also a programmer

[@jonathanmaner1157]

No chalkboard! Nooooooooooooooooooooooo

[@data_dave]

get an eraser lol

[@icecoolguita]

"dude dawg my application aint working righttt"

[@aminasadaat7559]

Pooopooooopooooppooooopop

[@MikeKenning]

Wow, Lame! ~ Caleb

[@TheSkepticSkwerl]

wow, lame! -Caleb

[@irreman3361]

you are not for it and you wasted my time