SQL JOINS Explained - SQL Tutorial for Beginners with Examples - Inner, Left, Right, Full

Data with Baraa January 19, 2023
Video Thumbnail
Data with Baraa Logo

Data with Baraa

@datawithbaraa

About

Hey, I'm Baraa, a Data Engineer with over 17 years experience, Ex-Mercedes Benz, where I led and built one of the biggest data platforms for analytics and AI. Now I’m here to share it all through visually explained courses, real-world projects, and the skills that will get you hired. I’ve helped millions of students transform their careers. If that sounds interesting, consider subscribing! See you in the next video

Video Description

🎬 *SQL Full (30-Hours) Course* https://youtu.be/SSKVgrwhzus 🎬 *SQL MySQL Course* https://youtu.be/NTgejLheGeU 🎁 *Free Downloads & Materials:* https://datawithbaraa.substack.com 👉 *Support & Subscribe* to Channel: http://bit.ly/3GiCVUE ☕ *Stay Connected* ► Subscribe: http://bit.ly/3GiCVUE ► Newsletter: https://bit.ly/BaraaNewsletter ► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/ ► Website: https://www.datawithbaraa.com ► PayPal: https://paypal.me/baraasalkini ► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join 📚 *Free Courses* ✅ *Tableau* : https://youtu.be/K3pXnbniUcM ✅ *SQL Playlist* : https://www.youtube.com/playlist?list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe ✅ *SQL Project1* : https://youtu.be/9GVqKuTVANE ✅ *SQL Project2* : https://youtu.be/2jGhQpbzHes ✅ *Tableau Project 1* : https://youtu.be/dahrmqT5GD4 ✅ *Tableau Project 2* : https://youtu.be/UcGF09Awm4Y ✅ *MySQL* :https://youtu.be/NTgejLheGeU 🎓 *If You Need Certifications* ► Udemy SQL: https://bit.ly/4hH947P ► Udemy Tableau: https://bit.ly/3xFiDDk ⭐ My favorite books: https://kit.co/DataWithBaraa/my-favorite-books 💻 My gear: https://kit.co/DataWithBaraa/my-desktop-gear 📖 *Table of Content* 00:00 The Concept of SQL Joins 02:15 What is INNER Join? 03:16 What is LEFT Join? 03:53 What is RIGHT Join? 04:22 What is FULL Join? 04:43 SQL Aliases 08:40 SQL INNER Join 17:00 SQL LEFT Join 20:06 SQL RIGHT Join 22:35 SQL FULL Join 26:42 SQL UNION #sql #sqlserver #data #analytics *Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!* *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

You May Also Like

Essential SQL Learning Kits

AI-recommended products based on this video

Loading...
Samsung Galaxy Tab A7 10.4" (32GB, 3GB) Ultra-Slim Wi-Fi Only Android 10 One UI Tablet, Snapdragon 662, 7040mAh Battery, SM-T503 (64GB SD Bundle) (Dark Gray)

Samsung Galaxy Tab A7 10.4" (32GB, 3GB) Ultra-Slim Wi-Fi Only Android 10 One UI Tablet, Snapdragon 662, 7040mAh Battery, SM-T503 (64GB SD Bundle) (Dark Gray)

(565)
$149.86
FREE delivery Wed, Aug 27
200+ bought in past month
Loading...
10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

10.1 Inch Touch Portable Monitor IPS Screen 1366x768P 60Hz 400 Brightness 99% sRGB HDMI USB-C Monitors Switch for Xbox PS3/4/5 Laptop Compatible with Raspberry Pi, Mini Touch Screen

(1)
$99.99
FREE delivery Mon, Aug 11
Loading...
ELECROW 8 Inch Portable Monitor, 1280x800 Mini HD Display with Built-in Speakers, USB Powered, Non-Touch LCD Screen for Raspberry Pi, PC, Laptop, Jetson Nano, Game Consoles

ELECROW 8 Inch Portable Monitor, 1280x800 Mini HD Display with Built-in Speakers, USB Powered, Non-Touch LCD Screen for Raspberry Pi, PC, Laptop, Jetson Nano, Game Consoles

(49)
$117.29$102.21
$6.86 delivery Thu, Aug 14
Loading...
7 Inch Portable Monitor Touchscreen HD 1024x600 LED Display Dual HDMI Port Small Monitor for PC Raspberry Pi Laptop Computer Xbox PS4/5 Switch Built-in Speakers

7 Inch Portable Monitor Touchscreen HD 1024x600 LED Display Dual HDMI Port Small Monitor for PC Raspberry Pi Laptop Computer Xbox PS4/5 Switch Built-in Speakers

(61)
$68.99
FREE delivery Tue, Aug 12
Loading...
BrosTrend 1800Mbps WiFi 6 Linux WiFi Adapter for PC and Raspberry Pi 2+, Long Range USB WiFi Dongle Linux for Ubuntu, Mint, Debian, Kubuntu, Lubuntu, Zorin, Windows 11/10, Dual Band Wireless Antenna

BrosTrend 1800Mbps WiFi 6 Linux WiFi Adapter for PC and Raspberry Pi 2+, Long Range USB WiFi Dongle Linux for Ubuntu, Mint, Debian, Kubuntu, Lubuntu, Zorin, Windows 11/10, Dual Band Wireless Antenna

(288)
$54.14
FREE delivery Sun, Jun 22
Loading...
Head Strap with Battery for Oculus Quest 2, 7500mAh Extend 4-5H Playtime, Adjustable Comfort Elite Head Strap Replacement, Lightweight Design and Enhanced Support in VR for Oculus/Meta Quest 2

Head Strap with Battery for Oculus Quest 2, 7500mAh Extend 4-5H Playtime, Adjustable Comfort Elite Head Strap Replacement, Lightweight Design and Enhanced Support in VR for Oculus/Meta Quest 2

(801)
$43.99
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
Charging Dock for Meta Quest 3S/Quest 3, YUANHOT Fast Charging Station with Color RGB Light for Oculus Quest 3S/3 Accessories, Magnetic Charger Stand for Headset/Controller with 2 Rechargeable Battery

Charging Dock for Meta Quest 3S/Quest 3, YUANHOT Fast Charging Station with Color RGB Light for Oculus Quest 3S/3 Accessories, Magnetic Charger Stand for Headset/Controller with 2 Rechargeable Battery

(183)
$39.99
FREE delivery Tue, Jun 17
Loading...
Joystick Replacement Kit for Oculus Quest 2/3 Controller, Repair Kit for Meta Quest 2/3 Controller, Include 2 Joysticks, T5 Screwdriver, Tweezer, Pry Tool, 4 Thumbstick Grips (Black-11-in one)

Joystick Replacement Kit for Oculus Quest 2/3 Controller, Repair Kit for Meta Quest 2/3 Controller, Include 2 Joysticks, T5 Screwdriver, Tweezer, Pry Tool, 4 Thumbstick Grips (Black-11-in one)

(1,736)
$11.63$11.53
FREE delivery Tue, Jun 17 on your first order
100+ bought in past month
Loading...
INIU 16FT Link Cable for Meta Oculus Quest 2/3/Pro and PC VR Gaming - USB 3.0 Type C Cable with Separate Charging Port for VR Headset Accessories
Best Seller

INIU 16FT Link Cable for Meta Oculus Quest 2/3/Pro and PC VR Gaming - USB 3.0 Type C Cable with Separate Charging Port for VR Headset Accessories

(3,575)
$29.69$23.74
FREE delivery Tue, Jun 17 on your first order
300+ bought in past month
Loading...
Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite
Best Seller

Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite

(49)
$19.99$18.59
FREE delivery Mon, Aug 18 on your first order
Loading...
Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black
Best Seller

Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black

(38,516)
$39.98$35.98
FREE delivery Thu, Sep 4
500+ bought in past month
Loading...
Ram Mount Pod HD Vehicle Mount with 18" Aluminum Rod and Round Plate RAM-316-HD-18-202U for Tablets and Small Laptops

Ram Mount Pod HD Vehicle Mount with 18" Aluminum Rod and Round Plate RAM-316-HD-18-202U for Tablets and Small Laptops

(9)
$494.95
$24.50 delivery Jul 18 - 25