VCE Applied Computing U1O1: Querying data with SQL
Students write and test SQL queries to select, filter, sort, group, join and update data.
One content description from the full VCE Applied Computing - U1O1 - Data analysis 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
SQL SELECT and FROM
3
SQL WHERE conditions
4
Combining query criteria with AND and OR
5
Matching part of a text value with wildcards
6
SQL ORDER BY
7
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
8
SQL GROUP BY
9
SQL JOIN across two tables
10
SQL UPDATE and DELETE
11
Testing a query against the data
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 →