QCE Digital Solutions Unit 4: SQL queries and data changes
Students change data with UPDATE and DELETE and write SELECT queries using WHERE, ORDER BY, GROUP BY, HAVING, inner joins and sub-selects.
One content description from the full QCE Digital Solutions Unit 4 — Prototype Digital Data Exchanges journey. All 12 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (12)
1
SQL UPDATE and DELETE
2
SQL SELECT and FROM
3
SQL WHERE conditions
4
SQL ORDER BY
5
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
6
SQL GROUP BY
7
SQL HAVING
8
Why a query over two tables needs a join
9
Writing the ON condition: foreign key equals primary key
10
Table-qualified field names in a join
11
A join with WHERE and ORDER BY
12
SQL sub-select (subquery)
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 →