Databases and SQL resources
Computer Science, grade 11. Notes, worksheets, videos, interactive tools and revision materials for this chapter.
Notes
Study notes
The chapter's lessons are the notes — read them in order, then use the resources below.
01Tables and KeysDesign tables with primary keys that uniquely identify each row.Read lesson →02Table RelationshipsLink tables with foreign keys in one-to-many relationships.Read lesson →03SELECT QueriesRetrieve exactly the data you need with SELECT, WHERE and ORDER BY.Read lesson →04Changing DataAdd, update and delete rows safely with INSERT, UPDATE and DELETE.Read lesson →
Worksheets
Practice worksheet
Attempt every question before revealing the answer — that struggle is where learning happens.
Practice questions live inside each lesson — work through them there, then return for revision.
Videos
Watch and learn
Hand-picked searches to find a clear video explanation of each lesson.
Revision
Revision checklist
Can you explain each of these out loud, without looking? If not, re-read that lesson.
- Tables and Keys: Design tables with primary keys that uniquely identify each row.
- Table Relationships: Link tables with foreign keys in one-to-many relationships.
- SELECT Queries: Retrieve exactly the data you need with SELECT, WHERE and ORDER BY.
- Changing Data: Add, update and delete rows safely with INSERT, UPDATE and DELETE.
- Read each lesson's summary and re-do its practice questions from memory.