Brainlag Learn / GCSE Computer Science

Databases and SQL

Tables, records and fields, primary and foreign keys, why linked tables beat one big table, SQL queries over one or two tables, changing data with INSERT, UPDATE and DELETE, and reading and writing CSV files.

Lessons

Relational databases and recordsTables, records and fields, data types, primary and foreign keys, why linked tables beat one big table, and how a program holds records in a 2D array. 25 min, free
SQL queriesSELECT, FROM and WHERE, AND and OR, LIKE with wildcards, ORDER BY ASC and DESC, and queries that use two linked tables. 25 min, free
Changing data and filesINSERT INTO, UPDATE and DELETE, then storing data in text and CSV files: open, read, write, append and close. 25 min, Plus

Practise and test

Question bank47 exam-style question types with mark schemes and worked solutions. 12 are free.
Topic test12 questions, 25 marks, 25 minutes, marked with a grade estimate. Plus.

AQA, Pearson Edexcel and OCR are registered trade marks of their owners. Brainlag Learn is independent: it is not affiliated with or endorsed by any exam board, and every question on it is original.