QCE Digital Solutions Unit 3: SQL for data definition, manipulation and querying
Students use SQL to create, alter and drop tables, insert, update and delete records, and query data with WHERE, GROUP BY, HAVING, ORDER BY, sub-selections and inner joins.
One content description from the full QCE Digital Solutions Unit 3 — Innovative Digital Solutions journey. All 20 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (20)
1
What SQL is
2
SQL column data types and sizes
3
CREATE TABLE and INSERT INTO
4
Foreign key and table relationships
5
FOREIGN KEY ... REFERENCES in CREATE TABLE
6
SQL UPDATE and DELETE
7
SQL ALTER TABLE
8
SQL DROP TABLE
9
SQL SELECT and FROM
10
SQL WHERE conditions
11
Boolean operators AND, OR and NOT in a WHERE clause
12
SQL ORDER BY
13
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
14
SQL GROUP BY
15
SQL HAVING
16
SQL sub-selection (subquery)
17
Why a query over two tables needs a join
18
Writing the ON condition: foreign key equals primary key
19
Table-qualified field names in a join
20
A join with WHERE and ORDER BY
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 →