Description
Coding
SQL & Databases
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.
- 1
Common table expressions
Name an intermediate query to make a report easier to read.
18 min
- 2
Bounded recursive queries
Use a recursive CTE with an explicit stopping condition.
18 min
- 3
Ranking rows within groups
Use window functions while preserving individual rows.
18 min
- 4
Running totals and window frames
State which rows contribute to each window aggregate.
18 min
- 5
Comparing neighboring rows
Use LAG to compare a row with an earlier row in its partition.
18 min
- 6
Conditional aggregation
Compute several filtered measures in one grouped query.
18 min
- 7
Indexes and stable pages
Match an index to a filter and use a key-based page boundary.
18 min
- 8
Reading query plans
Inspect whether SQLite scans a table or searches an index.
18 min
- 9
Views and query boundaries
Name reusable queries and keep application input separate from SQL.
18 min
- 10
Project: a ranked learning report
Build a complete report with aggregation, inactive members, and ranking.
18 min