Loading...
Loading...
Coding
Learn to query and organize data with 32 practical SQL lessons, from your first SELECT to joins, transactions, and analytical reports.
Read, filter, summarize, and update sample tables.
Return values with SELECT and name the result columns.
12 min
Read selected fields from a table and identify rows with keys.
12 min
Use comparisons to select rows that meet a condition.
12 min
Combine filters with AND, OR, NOT, and parentheses.
12 min
Choose a deterministic order before taking a subset.
12 min
Test for missing values with IS NULL instead of equality.
12 min
Use IN, BETWEEN, and DISTINCT for common filters.
12 min
Find simple text patterns and understand wildcard matching.
12 min
Calculate readable results while controlling numeric division.
12 min
Summarize rows with COUNT, SUM, and AVG.
12 min
Produce one aggregate result per group.
12 min
Insert, update, and delete rows in an isolated database.
12 min