Introductory course · beginner

SQL

Ask clear questions of organised records.

Use SQL to inspect and summarise relational data, with SQLite examples. This introductory course covers query foundations and safe data habits, not database administration.

Course outcomes

• Choose columns and read a small result set from a SQLite table.
• Filter rows with WHERE and sort the remaining results with ORDER BY.
• Use an aggregate function and GROUP BY to compare counts or totals for each category.
• Join two small tables on a matching key and select only the fields needed for a report.
• Use explicit columns and a narrow WHERE condition to change a synthetic SQLite record safely.
• Combine filters, joins and aggregation to answer a clear stock question from synthetic tables.

Published lessons

1. Read rows with SELECT
2. Filter and sort results
3. Combine and summarize records
4. Relate tables with keys
5. Add, update and delete safely
6. Build a small SQLite inventory report