🎬 Full Advanced Course: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
A comprehensive SQL subquery tutorial that provides a complete understanding of subqueries in SQL and their use cases. We will cover everything about how to use it in SELECT, FROM, JOIN, WHERE, IN, EXISTS, ANY, ALL, and more..
⬇️ Free Materials (Downloads): https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join
📚 Free Courses
✅ Tableau: https://youtu.be/UcGF09Awm4Y
✅ Tableau Project: https://www.youtube.com/watch?v=UcGF09Awm4Y
✅ SQL Basics: https://youtu.be/NTgejLheGeU?si=2-m6dgYPRvoFUSgS
✅ SQL Advanced: https://www.youtube.com/watch?v=ELdz0dXzWGM&list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
✅ ChatGPT: https://youtu.be/LJLNfei4i-c?si=EhUNYN38dkswAvZH
🎓Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare
⭐ My favorite books: https://kit.co/DataWithBaraa/my-favorite-books
💻 My gear: https://kit.co/DataWithBaraa/my-desktop-gear
⏱️ Timestamp
00:00 Intro
00:26 What is Subquery?
03:40 Why Subquery?
05:45 Categories of Subquery
07:52 Subquery Result Types
10:23 FROM Clause Subquery
21:15 How DB Executes Subquery
22:51 SELECT Clause Subquery
29:54 JOIN Clause Subquery
34:57 WHERE Clause Subquery
41:41 IN Operator Subquery
50:11 ANY, ALL Operators Subquery
56:25 Correlated Vs Non-Correlated Subqueries
01:07:11 Exists Operator Subquery
01:19:11 Subquery Summary
#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**