- Filtering Data with WHERE
- Conditions and logical operators (AND, OR, NOT)
- Comparison operators (=, <, >, <=, >=, <>)
- Sorting and Limiting Data
- Using ORDER BY for sorting results
- Using LIMIT to restrict the number of results
- Functions in SQL
- Aggregate functions: COUNT(), SUM(), AVG(), MIN(), MAX()
- String functions: CONCAT(), LENGTH(), UPPER(), LOWER()
- Working with NULL Values
- Understanding NULL
- IS NULL and IS NOT NULL
- Joins in SQL
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN