SQL Ultimate Course
🎬 Full SQL Course: https://youtu.be/SSKVgrwhzus
🔻 *Free Downloads & Materials:* https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
Welcome to your ultimate *high-quality SQL course* ! This is designed to take you from the basics of SQL to advanced database management skills.
☕ *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 1* : https://youtu.be/dahrmqT5GD4
✅ *Tableau Project 2* : https://youtu.be/UcGF09Awm4Y
✅ *SQL Playlist* : https://youtu.be/UcGF09Awm4Y
✅ *SQL Project1* : https://youtu.be/9GVqKuTVANE
✅ *SQL Project2* : https://youtu.be/2jGhQpbzHes
✅ *MySQL* :https://youtu.be/NTgejLheGeU
Curated by: Data with Baraa (56 videos)
Currently Playing: SQL Subquery (Visually Explained) | Complete Guide with Correlated Subquery | #SQL Course 27
Visually explained how SQL subqueries and correlated subqueries work step by step with practical examples.
- *SQL Full Package* https://www.datawithbaraa.com/course/sql-full-course-for-beginners
- *SQL Handbook* https://academy.datawithbaraa.com/l/digital_download/1087406/the-sql-handbook
- *Free SQL materials* https://www.datawithbaraa.com/wiki/sql
- *Full free SQL course* https://youtu.be/SSKVgrwhzus
━━━━━━━━━━━━━━━━━━━━
*🏆 My Academy (recommended)*
- *Python* https://www.datawithbaraa.com/course/the-ultimate-python-mastery
- *Python Handbook* https://academy.datawithbaraa.com/l/digital_download/998313/the-python-handbook
- *Tableau* https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners
*🎓 Udemy*
- *SQL* https://www.udemy.com/course/the-complete-sql-bootcamp-30-hours-go-from-zero-to-hero/?referralCode=D20781228C2EB8B98339
- *Python* https://www.udemy.com/course/the-complete-python-bootcamp-13hours-go-from-zero-to-hero/?referralCode=776491A4119FF8AF41CA
- *Tableau* https://www.udemy.com/course/the-tableau-ultimate-course-from-zero-to-hero/?referralCode=6544726FDC491A6B25EC
*💼 LinkedIn Learning*
- *Databricks for Data Analysts* https://www.linkedin.com/learning/databricks-for-data-analysts
- *Claude Code for Data Analysis* https://www.linkedin.com/learning/claude-code-for-data-analysis-build-repeatable-reliable-workflows
📬 *Newsletter for data friends*
https://www.blog.datawithbaraa.com
*Get 25% OFF DataCamp's Here*
https://datacamp.pxf.io/bOEe66
━━━━━━━━━━━━━━━━━━━━
📖 *Table of Content*
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
━━━━━━━━━━━━━━━━━━━━
*CONNECT WITH ME*
💬 Discord https://discord.gg/gsVJbMxKcA
👨💻 LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/
📸 Instagram https://www.instagram.com/datawithbaraa/
🎥 TikTok https://www.tiktok.com/@datawithbaraa
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
Note: some links above are affiliates. I may earn a small commission
if you enroll. Thank you for supporting the channel.
#sql #sqlserver #data #analytics #dataanalysis #datascience
Tracks in this Playlist
- SQL Full Course for Beginners (30 Hours) – From Zero to Hero
- How I Would Learn SQL (If I Could Start Over in 2025) | #SQL Course 1
- What is SQL (Visually Explained) | #SQL Course 2
- Install SQL Server & SSMS 2026 | Create Your First Database (Beginner Guide) | #SQL Course 3
- SQL SELECT Queries (Visually Explained) for Beginners | All Essential Clauses | #SQL Course 4
- SQL DDL Commands (Visually Explained) | CREATE, ALTER, DROP | #SQL Course 5
- SQL DML Commands (Visually Explained) | INSERT, UPDATE, DELETE | #SQL Course 6
- SQL WHERE Conditions (Visually Explained) | AND, OR, NOT, LIKE, BETWEEN, IN | #SQL Course 7
- SQL Joins Basics (Visually Explained) | INNER, LEFT, RIGHT, FULL | #SQL Course 8
- Advanced SQL Joins (Visually Explained) | ANTI, CROSS | #SQL Course 9
- Joining Multiple Tables in SQL (Visually Explained) | 3+ Table Joins | #SQL Course 10
- SQL SET Operators (Visually Explained) | UNION, UNION ALL, EXCEPT, INTERSECT | #SQL Course 11
- SQL Functions (Visually Explained) | In 5 Minutes | #SQL Course 12
- SQL String Functions (Visually Explained) | A Detailed Guide | #SQL Course 13
- SQL Number Functions (Visually Explained) | ROUND, ABS | #SQL Course 14
- SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #SQL Course 15
- SQL Date & Time Functions (Visually Explained) | FORMAT, CONVERT, CAST | #SQL Course 16
- SQL Date & Time Functions (Visually Explained) | DATEADD, DATEDIFF, ISDATE | #SQL Course 17
- SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course 18
- SQL NULL vs Empty String vs Blank Space (Visually Explained) | #SQL Course 19
- SQL CASE WHEN Statement (Visually Explained) | #SQL Course 20
- SQL Aggregate Functions | COUNT, SUM, AVG, MAX, MIN | #SQL Course 21
- SQL Window Functions Basics (Visually Explained) | PARTITION BY, ORDER BY, FRAME | #SQL Course 22
- SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course 23
- SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE | #SQL Course 24
- SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course 25
- 5 SQL Techniques You Need in Every Project (Visually Explained) | #SQL Course 26
- SQL Subquery (Visually Explained) | Complete Guide with Correlated Subquery | #SQL Course 27
- SQL CTE (Common Table Expression) Visually Explained | Full Guide WITH Clause | #SQL Course 28
- SQL Views (Visually Explained) | 6 Top Use Cases | #SQL Course 29
- SQL CTAS | How to Create SQL Tables From a Query | #SQL Course 30
- SQL Temp Tables (Visually Explained) | #SQL Course 31
- SQL Subquery vs CTE vs Views vs CTAS vs TEMP | #SQL Course 32
- SQL Indexes (Visually Explained) | Clustered vs Nonclustered | #SQL Course 35
- SQL Columnstore Index (Visually Explained) | Columnstore vs Rowstore | #SQL Course 36
- SQL Unique & Filtered Indexes (Visually Explained) | #SQL Course 37
- How to Choose the Right Index (Visually Explained) | #SQL Course 38
- SQL Index Maintenance | 5 Things to Do after Creating Indexes | SQL Statistics | #SQL Course 39
- SQL Execution Plans (Visually Explained) | SQL Hints | #SQL Course 40
- My Indexing Strategy for Every SQL Project | Indexing Best Practices | #SQL Course 41
- SQL Table Partitioning (Visually Explained) | Optimize Big Table Performance | #SQL Course 42
- 30 SQL Tips and Tricks From 18 Years of Experience | #SQL Course 43
- SQL Stored Procedure (Visually Explained) | Comprehensive Guide | #SQL Course 33
- SQL Triggers (Visually Explained) | Audit Logs Use Case | #SQL Course 34
- How I Use ChatGPT & GitHub Copilot in My Projects | #SQL Course 44
- Intro To SQL Project | Data Engineer Portfolio Project | #SQL Project 1
- Data Warehouse Basics Visually Explained | Data Engineer Portfolio Project | #SQL Project 2
- ETL Process Visually Explained | Data Engineer Portfolio Project | #SQL Project 3
- Notion Project Plan & Set Up Your Environment | Data Engineer Portfolio Project | #SQL Project 4
- Design Data Architecture for Your Data Warehouse | Data Engineer Portfolio Project | #SQL Project 5
- Project Setup: Git, Naming & Database Creation | Data Engineer Portfolio Project | #SQL Project 6
- Build The Bronze Layer: Data Ingestion | Data Engineer Portfolio Project | #SQL Project 7
- Build The Silver Layer: Cleanse & Transform Data | Data Engineer Portfolio Project | #SQL Project 8
- Building The Gold Layer: Star Schema Modeling | Data Engineer Portfolio Project | #SQL Project 9
- SQL Exploratory Data Analysis (EDA) Project | Full Hands-On Portfolio Project
- SQL Data Analyst Portfolio Project | Like I Do in My Real Projects