ACARA 7-8 Digital Technologies: Asking questions with SQL queries
Students learn what a query is and use SQL SELECT, FROM and WHERE, with criteria, to choose the fields and records a query returns.
One content description (AC9TDI8P03) from the full ACARA Digital Technologies Years 7–8 — Structured Data and Queries journey. All 11 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (11)
1
What a database query is
2
What SQL is
3
SQL SELECT and FROM
4
Choosing which fields a query shows
5
Field order in the output of a SELECT
6
Running an SQL query in a database tool
7
SQL WHERE conditions
8
Query criteria with comparison operators
9
WHERE on text, Boolean, character and date fields
10
Combining query criteria with AND and OR
11
SQL LIKE with the % wildcard
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 →