Loading...
Loading...
Coding
Learn to query and organize data with 32 practical SQL lessons, from your first SELECT to joins, transactions, and analytical reports.
Connect tables, validate data, use transactions, and build reports.
Connect records through primary and foreign keys.
18 min
Use LEFT JOIN to retain members with no matching activity.
18 min
Follow a relationship chain without multiplying unrelated rows.
18 min
Separate row filters from aggregate filters.
18 min
Use a query result inside another query.
18 min
Ask whether a related row exists without duplicating outer rows.
18 min
Build conditional result values without changing stored data.
18 min
Enforce required values, unique identifiers, and valid relationships.
18 min
Group changes and undo a transaction when it should not be kept.
18 min
Combine joins, aggregates, and fallbacks into a complete report.
18 min