• ▹ DDL Commands: CREATE, ALTER, DROP, TRUNCATE
• ▹ DML Commands: INSERT, UPDATE, DELETE
• ▹ Data Types & Constraints
• ▹ SELECT, DISTINCT, WHERE, LIKE
• ▹ ORDER BY, LIMIT, TOP
• ▹ Logical Operators: AND, OR, NOT, IN, BETWEEN

• ▹ MIN, MAX Functions
• ▹ COUNT, AVG, SUM
• ▹ GROUP BY Clause
• ▹ HAVING Clause
• ▹ Combining Aggregates

• ▹ INNER JOIN
• ▹ LEFT JOIN / RIGHT JOIN
• ▹ FULL OUTER JOIN
• ▹ CROSS JOIN
• ▹ SELF JOIN
• ▹ Multiple Joins

• ▹ EXISTS Operator
• ▹ UNION, UNION ALL
• ▹ DATE & TIME Functions
• ▹ Common Table Expressions (CTE)
• ▹ Subqueries (Nested Queries)
• ▹ Correlated Subqueries

• ▹ CASE WHEN Statements
• ▹ Nested CASE Expressions
• ▹ ROW_NUMBER(), RANK(), DENSE_RANK()
• ▹ LEAD(), LAG() Functions
• ▹ Window Functions with Partitions

• ▹ Aggregate Functions as Window Functions
• ▹ SUM() OVER(), AVG() OVER()
• ▹ Running Totals
• ▹ Moving Averages
• ▹ PARTITION BY with Aggregates

• ▹ Data Cleaning: Remove Duplicates, Text to Columns, Data Validation
• ▹ Functions: SUM, COUNT, AVERAGE, SUMIFS, COUNTIFS, AVERAGEIFS
• ▹ Lookup Functions: VLOOKUP, XLOOKUP, INDEX & MATCH
• ▹ Logical Functions: IF, AND, OR, NOT, Nested Functions
• ▹ Pivot Tables & Pivot Charts
• ▹ Conditional Formatting & Advanced Charting
• ▹ Creating Dynamic Dashboards

• ▹ Syntax, Variables & Data Types (int, float, string, boolean)
• ▹ Control Flow: if-else, Loops (for, while)
• ▹ Data Structures: Lists, Dictionaries, Sets, Tuples
• ▹ Functions & Lambda Functions
• ▹ Error Handling: try-except
• ▹ Modules & Packages; Libraries: Pandas, NumPy, Matplotlib

• ▹ Dashboard Fundamentals
• ▹ Data Connections & Transformations
• ▹ Creating Visualizations
• ▹ DAX Functions / Calculated Fields
• ▹ Interactive Dashboards, Publishing & Sharing