Personal notes and practice materials built while developing SQL skills for data analysis.
| area | topics |
|---|---|
| querying | select, where, regex, join, union |
| aggregation | aggregating, group & order |
| data manipulation | modification, view, DDL, transaction |
| advanced | subqueries, window functions, CTEs, index |
| functions | string, datetime, numeric, null handling, conversion |
| programmability | constraints, procedures |