ProgrammingMedium Exam FrequencyOCR

SQL

Revise SQL in Programming for GCSE Computer Science with 15 exam-style questions and 10 flashcards. This topic appears regularly enough that it should be part of a solid GCSE revision cycle.

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

Sample Flashcards

What does WHERE do?

Filters rows based on conditions

What does SELECT do?

Chooses which columns to display

Sample Questions

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.

Join Alpha

Previous topic

File Handling

Next topic

Variable Scope