Talking to Databases
Talking to Databases
SQL (Structured Query Language) is how we communicate with databases. Think of a database as a massive, organised filing cabinet. SQL is the language you use to ask questions: "Give me all customers from London" or "Show products under £50 sorted by price." SELECT retrieves data, FROM specifies the table, WHERE filters results. It's like Google for databases!
Now try it yourself
Quiz · Question 1 of 19
Which SQL keyword is used to choose which columns to retrieve from a database table?
Tap an answer to check it
This topic in real past papers
Every real exam question we've found on sql, with a full worked answer.
AQA Paper 2
Both sittings we have full papers for test the benefit of relational databases and ask you to identify a foreign key from given table data.
AQA Paper 2
Both sittings we have full papers for include a 6-mark SQL SELECT query joining two tables with a WHERE condition and an ORDER BY clause, plus a separate 2-mark question completing SQL to edit a record.
OCR Paper 2
All three sittings we have full papers for include a genuine SQL question against a given database table, worth 3 to 4 marks.