Mastering MySQL Subqueries: Real-World Online Store Database Tutorial

🟢 Description: Learn how to effectively use MySQL subqueries in this comprehensive tutorial. We'll create an online store database from scratch, populate it with realistic sample data, and demonstrate various subqueries—including correlated subqueries, EXISTS clauses, JOIN vs Subquery comparisons, and GROUP BY with HAVING clauses. Whether you're new to MySQL or looking to sharpen your skills, this hands-on guide will take your SQL abilities to the next level.
Topics Covered:
- Creating MySQL databases and tables
- Inserting and managing realistic data
- Basic and complex subqueries
- Correlated subqueries and EXISTS statements
- Practical comparisons of JOIN and subquery performance

🟢 Timestamps

[kamleshsonej]

Loving content!! Following all the playlists. Best content for beginners, intermediate!

[HitRespawn]

thank you for teaching subqueries in MySQL.

[miyondev]

Bro si vas a seguir con el curso de Spring Boot, la verdad que es uno de los mejores, no lo abandones por favor

[swapnilnale]

Thank you sir fir explaining self join inner join

[yuvrajverma]

Thank uhh sir ji bahot sahi explain kiya

[MohammadArbazhusain]

make some more videos in spring boot playlist please

[ashutoshmishra]

Thanks For Subqueries Share your Knowledge also about Sharding, Partitioning, Indexing along with real examples .

[cse-vikasrajpoot]

this subquery clear all the main query 😊

[Vurnhazeth]

very complicated... haath chalaye bina nahi samajhne aane wali ye video, mai to khali movie ki tarah dekh raha tha

[umndrk]

Thank you so much for the valuable lesson.

[anuragaggarwal]

Need a video on partition & rank also

[inzii-]

Make a video on mviews, synonyms, partitions, and procedures also

[ashwanitiwari]

Thankyou so much sir much awaited lecture ❤

[anuragaggarwal]

Question : shouldn't the below be > instead of = :
SELECT c.email
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
JOIN order_items oi ON o.order_id = oi.order_id
JOIN products p ON oi.product_id = p.product_id
WHERE p.category = "Electronics"
GROUP BY c.customer_id
HAVING COUNT(DISTINCT p.product_id) > (SELECT COUNT(*) FROM products WHERE category="Electronics");

[jariabbas]

Sir, will you consider starting a course on Quarkus? Quarkus is much better than Spring Boot for microservices and cloud-native environments. Please, sir, start a Quarkus course ❤️🥹