Use this file to track your learning journey. Mark topics as you complete them.
-
SELECT— Retrieving data from tables -
WHERE— Filtering rows -
ORDER BY— Sorting results -
LIMIT— Restricting number of rows -
DISTINCT— Removing duplicates
-
LIKE— Pattern matching -
BETWEEN— Range filtering -
IN— Matching a set of values -
NULL— Handling null values
-
GROUP BY— Grouping rows -
HAVING— Filtering groups - Aggregate Functions —
COUNT,SUM,AVG,MIN,MAX
-
INNER JOIN -
LEFT JOIN -
RIGHT JOIN -
FULL JOIN -
SELF JOIN
- Subqueries
- CTEs (Common Table Expressions)
- Window Functions
-
CASEExpressions - Views
- Practice problems
| Date | Topic | Notes |
|---|---|---|