Test yourself on SQL with exam style questions, marked instantly.
Flashcards that come back just before you would forget them.
A revision plan that remembers what you know and shows what to do next.
See which topics you have nailed and which need another look.
Quiz yourself on SQLGet your flashcardsBuild my revision planTrack my progressSQL Commands Reference
The commands run in order on one table, so each table is the result of the command above it. SELECT, FROM and WHERE are on AQA and OCR. INSERT, UPDATE and DELETE are on AQA only. Edexcel has no SQL.
Warning: if you leave out WHERE, the command changes every row. UPDATE Students SET grade = 9 sets every grade to 9, and DELETE FROM Students removes every row. The WHERE line picks out only the rows you mean.
Make this stick
Signing in gives access to all PrepWise features.