– WHERE, ORDER BY, GROUP BY clauses
– Aggregate functions like COUNT, SUM, AVG

– INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
– Combining data from multiple sources

– Using subqueries in SELECT, WHERE, and FROM
– Common Table Expressions (CTEs)

– INSERT, UPDATE, DELETE statements
– Transactions and data integrity

– Using built-in functions
– Creating and using views for simplified queries

– Solve a real-world business problem
– Write optimized queries and present findings
– Final presentation + certificate award