🎬 *SQL Full (30-Hours) Course* https://youtu.be/SSKVgrwhzus
🎁 *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
⏱️ *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*