Correlated and uncorrelated subqueries Subqueries in SELECT, FROM, and WHERE Multiple table joins Performance considerations

INNER JOIN LEFT/RIGHT OUTER JOIN FULL OUTER JOIN CROSS JOIN Self-joins

Types of relationships (one-to-one, one-to-many, many-to-many) Referential integrity Key constraints Database normalization introduction

Advanced filtering workshop Aggregation techniques demonstration Common pitfalls and solutions Project presentations

Aggregate functions (COUNT, SUM, AVG, MIN, MAX) GROUP BY clause HAVING clause Complex aggregation scenarios

INSERT operations UPDATE statements DELETE commands Transaction basics

Complex WHERE clauses LIKE, IN, BETWEEN operators NULL value handling Pattern matching techniques

Interactive SQL environment setup Live query demonstrations Troubleshooting common issues Project review and feedback