3.7 Relational Databases and SQLVery High Exam FrequencyOCR

SQL

Revise SQL in 3.7 Relational Databases and SQL for GCSE Computer Science with 19 exam-style questions and 10 flashcards. This is a very high-frequency exam topic, so it is worth revising until the core ideas feel automatic.

Study this topic

Video Lesson

Notes 2

Talking to Databases

Introduction 3

SQL Commands Reference

Diagram 4

SQL Commands

Notes 5

Deep Dive: Complete SQL Examples

Notes 6

Practical SQL Query Examples

Notes 7

Memory Trick

Notes 8

Exam Tips

Notes 9

Knowledge Organiser: SQL

Summary

Sample Flashcards

What does WHERE do?

Filters rows based on conditions

What does SELECT do?

Chooses which columns to display

Exam questions for SQL

Which SQL keyword is used to choose which columns to retrieve from a database table?

A. FROM
B. WHERE
C. SELECT
D. ORDER BY

1 markfoundation

Explain the difference between using AND and OR to combine conditions in an SQL WHERE clause. Give an example of when each would be used.

3 marksstandard

exam-style questions

revision flashcards

Ready to revise SQL?

Get personalised daily study plans, adaptive quizzes, and spaced repetition flashcards.

Start revising free

Previous topic

Technical Attacks

Next topic

Cultural & Privacy Issues