Summary
Keywords
Full Transcript
In this video, we will learn Joins in MySQL with real-life examples! We will cover Inner Join, Left Join, and Right Join step by step. We will also create a students and courses database, insert data, and run queries to see how joins actually work in the real world. Watch till the end for hidden secrets about joins and how to switch between Left and Right Joins! 💡 📌 What You’ll Learn: ✔️ What are Joins in MySQL? ✔️ How Inner, Left, and Right Joins work with real examples ✔️ Creating tables and inserting data for Joins ✔️ Turning Left Join into Right Join ✔️ Best practices for using Joins in SQL 🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2024/11/introduction-to-nodejs.html ------------------------------------------------------------------------ 🚀 Boost Your Skills with these Pre-Requisite Videos: 🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE 🔗 Best CSS Course - https://youtu.be/MSICFljRcb4 🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8 🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8 ------------------------------------------------------------------------ 💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html ------------------------------------------------------------------------ ✌️ Join Us! 🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join 📷 Connect on Instagram: https://www.instagram.com/thapatechnical 🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6 ------------------------------------------------------------------------ ⌛TIMELINE⏳ 0:00 🔹 Intro to Joins in MySQL 0:12 🔹 What are Joins in MySQL (Explained in Hindi) 3:35 🔹 What is INNER JOIN with example 6:40 🔹 What is LEFT JOIN with example 9:50 🔹 What is RIGHT JOIN with example 12:30 🔹 Hidden secrets about Joins 14:22 🔹 Creating database for real-life Joins demo 15:00 🔹 Creating students & courses tables 16:05 🔹 Inserting data into tables 17:00 🔹 INNER JOIN real-life example 19:25 🔹 LEFT JOIN real-life example 20:40 🔹 RIGHT JOIN real-life example 22:18 🔹 How to turn LEFT JOIN into RIGHT JOIN 24:30 🔹 Next video update 25:20 🔹 Get FREE source code
