Subquery

·       Introduction to Subqueries

·       Definition and Purpose of Subqueries

·       Types of Subqueries

·       Single-Row Subquery

·       Multiple-Row Subquery

·       Multiple-Column Subquery

·       Correlated Subquery

·       Non-Correlated Subquery

·       Subquery in SELECT Clause

·       Subquery in FROM Clause

·       Subquery in WHERE Clause

·       Subquery in HAVING Clause

·       Subquery in INSERT Statement

·       Subquery in UPDATE Statement

·       Subquery in DELETE Statement

·       EXISTS Subquery

·       NOT EXISTS Subquery

·       IN Subquery

·       NOT IN Subquery

·       ANY / SOME Subquery

·       ALL Subquery

·       Scalar Subquery

·       Subquery with JOIN

·       Nested Subqueries

·       Subquery with Aggregate Functions

·       Subquery with GROUP BY

·       Subquery with ORDER BY

·       Performance Considerations with Subqueries

·       Rewriting Subqueries as Joins

·       Best Practices for Using Subqueries