Loading...
Loading...
Coding
Learn to query and organize data with 32 practical SQL lessons, from your first SELECT to joins, transactions, and analytical reports.
Use CTEs, window functions, indexes, and reusable analytical queries.
Name an intermediate query to make a report easier to read.
18 min
Use a recursive CTE with an explicit stopping condition.
18 min
Use window functions while preserving individual rows.
18 min
State which rows contribute to each window aggregate.
18 min
Use LAG to compare a row with an earlier row in its partition.
18 min
Compute several filtered measures in one grouped query.
18 min
Match an index to a filter and use a key-based page boundary.
18 min
Inspect whether SQLite scans a table or searches an index.
18 min
Name reusable queries and keep application input separate from SQL.
18 min
Build a complete report with aggregation, inactive members, and ranking.
18 min