GCSE SQL Command Cheat Sheet for KS4 students studying AQA databases / structured query language

This SQL cheat sheet is designed to providing pupils with examples for a number of common relational database tasks. Was originally designed to aid KS4 (Year 10 or 11) students studying AQA GCSE Computer Science, topic 3.7 Relational databases and structured query language.

Sample data is also provided thanks to an .sql import file that allows you and your students create the sample schema and data using SQL Statements using an application like DB Browser for SQLite .

SQL (Structured Query Language) is a very popular and powerful tool that enables users to interact with databases by using commands such as SELECT to retrieve data, INSERT to add records, UPDATE to modify existing data, and DELETE to remove records.

All examples use a common set of sample data to aid students.

Sections include:

• Sample Data
• Recommended tips and conventions
• SELECT - Querying data from a single table
• SELECT - Filtering data using numeric fields
• SELECT - Filtering data using text fields
• SELECT - Filtering data using multiple fields
• SELECT - Querying data from multiple tables
• INSERT - Inserting data into a table
• UPDATE - Updating data in a table
• DELETE - Removing data from a table
• ERD diagram illustrating the Sample Data

If your students need some independent practice, why not check out my companion [SQL worksheetsheet] (https://www.tes.com/teaching-resource/resource-12919007)