Book 8: Algorithms, Programming and Databases
Book 8 · Chapter 11
Databases and SQL
§11.1§11.2Exam craft
B8·11This chapter is being written.
Everything the site already has for it is below — each with the short code the book prints beside it.
For the whole chapter
- Topic pageDatabases and Structured Query Language (SQL) (2029–2031)
B8·11·T - QuizDatabases and Structured Query Language (SQL)
B8·11·Q1 - LabSQL Lab — the ZAK Academy database
B8·11·X1 - LabSQL example sql-select-all
B8·11·X2 - LabSQL example sql29-join-two-order
B8·11·X3 - LabSQL Lab
B8·11·X1 - LabSQL example sql-select-columns
B8·11·X5 - LabSQL example sql-where-text
B8·11·X6 - LabSQL example sql-where-and-or
B8·11·X7 - LabSQL example sql-order-asc
B8·11·X8 - LabSQL example sql-order-desc
B8·11·X9 - LabSQL example sql-count
B8·11·X10 - LabSQL example sql-sum
B8·11·X11 - LabSQL example sql-insert
B8·11·X12 - LabSQL example sql29-insert-into
B8·11·X13 - LabSQL example sql29-join-two-order
B8·11·X3 - LabSQL example sql29-join-count
B8·11·X15 - LabSQL example sql29-join-sum
B8·11·X16 - LabSQL example sql29-correct-me
B8·11·X17 - LabSQL example sql-exam-2210-1
B8·11·X18 - LabSQL example sql-exam-2210-2
B8·11·X19 - LabSQL example sql-exam-2210-3
B8·11·X20
§11.1 Databases
Short code B8·11·1
- FlashcardsFlashcards §11.1: Tables, fields, records & validation
B8·11·F1 - FlashcardsFlashcards §11.1: Data types, primary and foreign keys
B8·11·F2
Workbook: Databases and SQL
Short code W8·11 · Algorithms, Programming and Databases Workbook
The write-in workbook for this chapter — drills, exam-style practice, trace tables, fix-the-mistake and mark-it-yourself pages. Its full mark schemes and an interactive version arrive here with the chapter.
Starter files
Short code W8·11·K
Data files and skeleton code in Python for this chapter's tasks arrive here with the chapter.


