Topic study hub
Structured Query Language (SQL)
Official AQA 7517 section 4.10.4.
0
Objectives
5
Flashcards
7
Questions
36 min
Study time
AqaA LevelComputer ScienceFundamentals of databases
Choose a revision tool
Start revising Structured Query Language (SQL)
Syllabus checklist
What you need to know
0 objective pages available
Structured Query Language (SQL)1 objectives
- Structured Query Language (SQL): Be able to use SQL to retrieve, update, insert and delete data from multiple tables of a relational database. Be able to use SQL to define a database table.
Key terms
JOINWHERE
Exam tips
- Check each SQL command's purpose: Before writing a statement, identify whether the task is retrieving, inserting, updating, deleting or defining a table.
Common mistakes
- Updating or deleting every row: Use WHERE to identify the intended row or rows, for example: DELETE FROM Customer WHERE CustomerID = 45;
Practice preview
Continue by objective
Objectives are grouped by subtopic so students can jump straight to the exact skill they want to revise.
Related topics