SQL

What you'll achieve

• Write efficient SQL queries to extract and filter large datasets
• Combine data across multiple tables using INNER, LEFT, RIGHT, and FULL JOINs
• Perform aggregations and group-level calculations with GROUP BY and HAVING
• Use subqueries, CTEs (Common Table Expressions), and window functions

Curriculum

1. 1SQL syntax, SELECT, column aliases & basic expressions
2. 2Filtering data: WHERE, AND, OR, IN, BETWEEN, LIKE & NULL handling
3. 3Sorting & limiting results (ORDER BY, LIMIT, OFFSET)
4. 4Multi-table JOINs: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
5. 5Aggregation functions (COUNT, SUM, AVG, MIN, MAX) & GROUP BY / HAVING
6. 6Subqueries (correlated and non-correlated) & CTEs (WITH clause)
7. 7Data manipulation: INSERT, UPDATE, DELETE & transactions
8. 8Project: End-to-end SQL analysis on a multi-table business sales dataset