ACARA 7-8 Digital Technologies: Sorting, writing and testing SQL queries
Students sort results with ORDER BY, combine clauses into full queries, then write, check and test single-table queries, including counting records.
One content description (AC9TDI8P03) from the full ACARA Digital Technologies Years 7–8 — Structured Data and Queries journey. All 10 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (10)
1
SQL ORDER BY
2
Sorting query results
3
How a field's data type changes sorting
4
Clause order in a full SQL query
5
Working out the output of an SQL statement
6
Describing what a query does in plain English
7
Writing an SQL query from a requirement
8
Common mistakes in SQL scripts
9
Testing a query against the data
10
SQL COUNT function
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 →