- Combine tables using inner, left, right, cross, and self joins.
- Apply aggregate functions: SUM, AVG, COUNT, GROUP BY, HAVING.
- Use scalar functions for strings, dates, and type conversions.
- Perform filtered and grouped queries for analysis.
- Hands-on exercises to reinforce multi-table query skills.
