ACARA 9-10 Digital Technologies: Querying a single table with SQL
Students write and trace SELECT queries that filter with WHERE, LIKE, BETWEEN and IN, sort with ORDER BY, and summarise with aggregate functions.
One content description (AC9TDI10P03) from the full ACARA Digital Technologies Years 9–10 — Entities, Relationships and Queries journey. All 13 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (13)
1
What a database query is
2
SQL SELECT and FROM
3
Field order in the output of a SELECT
4
SQL WHERE conditions
5
WHERE on text, Boolean, character and date fields
6
Boolean operators AND, OR and NOT in a WHERE clause
7
Mixing AND and OR with brackets in a WHERE clause
8
Pattern matching with LIKE, % and _
9
BETWEEN and IN in a WHERE clause
10
SQL ORDER BY
11
Clause order in a full SQL query
12
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
13
Working out the output of an SQL statement
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →