sql-notes

Personal notes and practice materials built while developing SQL skills for data analysis.

topics covered

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