SQL Joins Examples |¦| Joins in SQL |¦| SQL Tutorial
Vložit
- čas přidán 6. 08. 2024
- A SQL JOIN lets you retrieve data from 2 or more tables in your database. In this video we give examples of 4 kinds of joins: INNER Joins, LEFT Joins, RIGHT Joins, and FULL Joins (also known as FULL OUTER Joins).
If you are just learning about SQL Joins, we would recommend you watch our first video: “SQL Joins Explained.” • SQL Joins Explained |...
Our SQL playlist starts here:
↪bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : / socratica
► Make a one-time PayPal donation: www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: / socraticastudios
Instagram: / socraticastudios
Twitter: / socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦
It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉
still waiting...
あっくぇえええt387っq0っっっっくぁぱー⁰あpーああ⁰⁰あーーーあー1っq3q5い0
I love this woman's attitude and sense of humor and the content is also well taught... This channel definitely deserves more likes and subscribes
She's an sql master.
4 dislikes? I think they are from Mercury
16 at the moment, we got some extra-galactic activity from Andromeda
🤣🤣
Surely, they have a right and liberty to dislike? As for me, I like!
Lol na they some dirty belters!! Mercurians are hot!! Leave them alone!! Lol. I watch too much tv. Lol
😭😭
i love when someone teaches me like im the dumbest person on earth,like this :d
You joke, but that's the best way to drive home the fundamentals - the most important part
On Mars.
Such innovative style of teaching....I was scared of SQL joins till date...then I found Socratica!!
I like her doing these videos.
Second that
9:38 convert NULL quantity to ZERO. Here is the full code:
SELECT s.supply_id, ISNULL(i.quantity,0) AS quantity, s.name, s.description
FROM (SELECT * FROM inventory WHERE base_id = 1 ) AS i
RIGHT JOIN supply AS s
ON i.supply_id = s.supply_id
ORDER BY s.supply_id
;
YA'LL ARE KILLING ME WITH THE HUMOR, I am seriously 10 seconds in and cracking up looking forward to learning the way yall deliver this information. THANKS A BILLION
Christ, this is some of the best tutorials I've seen. Thank you for sharing, keep up with the excellent work!
Educational AND highly entertaining. Love her sense of humor and smile! Never have I clicked so fast for the next tutorial video. Great work Socratica and team!
The supply descriptions are hilarious 😂 and the graphics & sound effects throughout the vid are superb!
You are my hero!!! Never change your instructions methods, please. People like myself need you.
Easily the best video concerning SQL that I have watched. Not sure what else can be done any better.
THANK YOU for this awesome video series on SQL and especially JOINS! I've never had so much fun watching..........any coding video and this is such a blast. You guys rock for this.
the amount of effort and great sense of humor this lady has put in , so much appreciated.
I love the way they teach while having fun at the same time. In a short video, they explained all the three joins and sub-query, Alias as well. Thanks for this video.
Very insightful video I was searching for. For years I could not understand joins and related syntaxes but now finally I got it! Thank you a lot!
SQL is very important... thank god u have got this tutoring recorded. The best way for me to learn to learn is to watch this first.
Wow! This Playlist is the best I've ever seen! Thanks so much! It's unbelievable how well this is done! Are you just geniuses or do you have a ridiculously high Budget? Amazing… really… absolutely amazing...
One of the best learning video series for SQL! Kudos to your creativity and execution :)💕
Great video, and entertaining too - now I understand how to use the JOIN functions in SQL much better, thank you!
Idk what it is that makes these tutorials better than all the others. I think it’s her way of communication
this is one of the best tutorials i have ever
seen......thank you
Hats off to your creative ways to teaching. keep moving forward >>>
You are just what I needed! I feel much more confident that I'll pass my test! Thank You!
I love the nerd humor too!
Thank you for the videos! Hope you will keep publishing more videos on SQL.
I really enjoy this SQL series, very helpful. Thank you for making it so fun !
Wow. I never imagined joins were so entertaining... thanks a lot. Finally after 12 years of completing btech I now understand how joins work.
Absolutely in love with the videos!! Thanks a lot!! Did not expect all the fun in these videos :')))
Maybe I should comment more, this an incredible futuristic professionalism that is completely amazing. Beyond compare!
The best SQL tutorials ever...damn! I love this and thanks a million
watching these to prepare for a job interview. The cuteness factor is really helping put me in the right mindset. I appreciate this so much!!
GOOD LUCK in your interview!! 💜🦉
Seriously stellar! Humor and information are 100% Thanks for this!
thank you thank you that'll you had an exam and was so worried about joins. your an amazing teacher!!!
Cool vid! Your work deserves to be more known
What a goofy, loony chick. I love it! And funny too. Makes it such a relaxed learning environment. The voice... the hypnotic, expressive eyes... the ease with which I've learned things thru these videos. What a great presentation. What a great teacher!
Instead of just poking my way thru a basic 'How To' type of book until my very simple SQL usage does what I hope it to do, I'm actually learning stuff on how to do things correctly & efficiently.
You, madam, are brilliant in your technique!
this the first SQL video I have watched that is not boring. this video just motivates me!!!
You saved me, my exam is in a few days and I didn´t undertand the subject until now. Thanks a lot!
Amazing content, thank you so much for helping me understand the basics of SQL!!
Thank you for these videos, they are most helpful! Looking forward to more SQL videos! :)
The way this was put together was perfect. I get so f-ing bored in class and have a hard time paying attention. THIS taught me more than in 1 hour of lecture. THANK YOU!
Congratulations on your tutorials. Really helpful, on point, entertaining.
I cant believe how informative and fun this is!!
Actually you're helping me getting prepared for my exam next week. Great clips with really good examples.
Excellent and Ha ! Ha !
Extremely well done. It is a little over the top but honestly you are explaining things none of the other vids have so far which were all the difference to me in understanding this concept. Thank you!!
I love these videos so much! Thank you for making studying easier for me!
Perfect explanation and also enjoyable ! Keep it up!
Wow, I was lost in sql till I clicked on these videos. Superb job
This was the best explanation, I have seen so far!
Heyy!! This was a really nice video!
Great discovery for me. GOOD JOB!
Great video, learning SQL quick for an interview and this video (with the previous part) helped a lot in visualizing and understanding joins...thanks a lot!
i am a fan of this channel by now. this soundtrack, the william gibson -vibes, your acting!
10/10
Unbelievable videos! Great format. Please make many more!
Amazing! Just found your channel and it's amazing, thank you!
Socratica, you are one of the best humans this side of Mars.
This video was posted in my SQL class and so far it has been the thing that helps most in my lab assignment. Thank you!
This is wonderful to hear - we're so glad you're watching! Please say thanks to your instructor for us!! It helps us so much to get the word out.💜🦉
Hello Ms Socratica, I am not kidding.. Even though I'm proficient in all computer science-related concepts, I am always confused with SQL Joins. You have explained things with soo much ease, I literally fell in love with you and your approach. I'm more confident with joins now in just 11 mins. Thank you soo much.
Awesome work. I wish I had found this channel before.
She is a Fantastic teacher. Top work on the editing guys, I am a visual person and concepts are better understood visually.
I would be glad if you guys can share the csv files for the martian course as well for us to practice.
i havent see many of your videos yet, but i have already started loving them
We're so glad you've found us! Thanks for your nice comment!! 💜🦉
I used to hate building databases.... Boring... Socratica makes it enjoyable! Thank you Socratica!
Thank you for the SQL video! It was incredibly informative. 😊🙏🎥💻
You just Nailed it!🔥. I've joined socratica from today!
Keep it up.
This channel is awesome. I am liking SQL again.
education is supposed to be entertaining. Bang on Socratica !! learnt and laughed . cheers
Haven't found any better video on SQL than this.
very clear and easy to understand, love the analogies used here! this video helped me greatly!
One of the best methods for teaching. Examples are easy to understand and interesting. Even a child will love and learn these clips. Please continue what you're doing. Thank you.
such a creative way to teach, great video!
Love how you explain!
This helps so much. Joins were killing me this made it simple. love it thanks.
Appreciate the wonderful illustration.
Thanks ! This is so well explained !
truly, a video of the year
I love the way you explain this!
Replace NULL with zero:
SELECT ISNULL(myColumn, 0 ) FROM myTable
You really should have used IFNULL(i.quantity, 0) rather than the ISNULL.
SELECT COALESCE(myColumn , 0) FROM myTable;
It was incredible. Thanks Socratica.
Need more of SQL content like these
Am I the only one in love with this cyborg? great videos. I just have to keep up a bit faster than usual. Which is a good and bad thing.
loved the way you have taught SQL. Really Really AMAZING. Fun learning
I really really like you. I'm definitely going to study these for my new job. Thank you so much! you really explain this beautifully! You got yourself a subscriber!
0:16 seconds in and smashed like, love the star wars reference!
Wow! This is a great explanation and not boring lol. Thank you!
This is taught so well. Easier than a book
This lady is the best!
You made it so easy mam, I request you to please make more videos like this, I will definitely contribute on patreon once I have a job.☺
I wish I could Cite to a youtube links in scientific papers.
You made my data analysis really fas...
Thank you....
i like the teaching method of socratica . thank you
Thanks indeed the best video for explaining sql joins ever
I can't believe it goes in details for all the concepts in less than a 12 minutes ❤️❤️😍
these vids are so fun to watch!
This is the best video ever!I love all your videos ❤
YOU ARE A LIFE SAVIOR QUEEN!!!!!
Great video you make it so much fun and entertaining.
Very informative and very funny. These videos are amazing!
She and/or the person that wrote the script has a great sense of humor
Loving these, thanks a lot
I freaking love this channel. Thank you!
Waiting for Socratica's NoSql DB tutorial. I have subscribed, liked and commented and many will follow if you make a NoSQL DB tutorial.
Yeah. I hope she fulfills our request for NOSQL tutorials.
I love your content!!!
Outstanding way to teach a subject. I have never seen anything close to this. There are many good videos all around but the vídeos of this young lady are really from another world.
Thank you, Mario!!
its wonderful presentation that you are really really doing .. very easy to understand and you voice keeping us with the lesson in perfect manner. good luck mam...
Great Presentation thank you.