QCE Digital Solutions Unit 2: SQL joins and sub-queries
Students retrieve data across related tables using inner joins and sub-queries, and turn requirements into complete SQL queries.
One content description from the full QCE Digital Solutions Unit 2 — Prototype Data Solutions 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
Why a query over two tables needs a join
2
Writing the ON condition: foreign key equals primary key
3
Table-qualified field names in a join
4
Table aliases in a join
5
A join with WHERE and ORDER BY
6
Joining three tables
7
A join that forgets the ON condition
8
Sub-query in a WHERE clause with IN
9
Sub-query returning a single value
10
Writing an SQL query from a requirement
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 →