054. OCR A Level (H446) SLR10 – 1.3 SQL

About this video

OCR Specification Reference
A Level 1.3.2d

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 Structured Query Language (SQL)
00:06 Intro
00:11 Structured Query Language (SQL)
01:12 Using records stored in a database
01:21 Accessing records stored in SQLite (using Python)
01:56 Selecting data
06:49 Inserting data
08:09 Deleting data
09:04 Updating data
10:17 Using more than one table
11:58 Deleting a table
12:32 Key question
12:47 Going beyond the specification
13:02 Other SQL commands
14:23 Outro

Last updated: 20.05.26

Other videos on this course