166. AQA A Level SLR23 SQL
About this video
AQA Specification Reference
A Level 4.10.4
The Structured Query Language (SQL) is the language used to interact with relationship databases. In this video we take a look at how to write, interpret and modify simple SQL statements.
Key question:
- How do you use the main SQL keywords to create return and delete data in a database?
00:00 SQL
00:12 Intro
00:17 Structured Query Language (SQL)
01:10 Using records stored in a database
01:15 Accessing records stored in SQLite (using Python)
02:04 Selecting data
06:26 Inserting data
07:53 Deleting data
08:40 Updating data
09:43 Cross table queries
10:05 WHERE
11:24 INNER JOIN
12:20 Deleting a table
12:53 Defining a database table
13:05 Altering the structure of a table definition
13:15 Defining a relational database table
13:24 Key question
13:35 Outro
Last updated: 06.11.25
