QCE Digital Solutions Unit 2: Testing SQL, algorithms and code
Students plan and run tests with test tables and test data, check queries and stored data changes, and use assert, tracing and retesting to find and fix faults.
One content description from the full QCE Digital Solutions Unit 2 — Prototype Data Solutions journey. All 14 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (14)
1
Test table layout
2
Choosing a range of test data
3
Constructing test data for validation checks
4
Recording actual results and a pass or fail verdict
5
Testing that invalid input is rejected
6
Testing a query against the data
7
Working out the output of an SQL statement
8
Common mistakes in SQL scripts
9
Testing that stored data changed correctly
10
Testing a function with assert
11
Testing one module in isolation
12
Test coverage of branches and loops
13
Debugging a program with print() and trace tables
14
Retesting everything after a fix
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 →