Skip to content
Oak National Academy
Oak National Academy
View my library
0
Teachers
Pupils
New
New
Year 11
AQA

Data management with SQL statements

I can use SQL statements to manage data in a database, including inserting, updating, and deleting records.

Download all resources
Share activities with pupils
New
New
Year 11
AQA

Data management with SQL statements

I can use SQL statements to manage data in a database, including inserting, updating, and deleting records.

Download all resources
Share activities with pupils

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

These resources were created for remote use during the pandemic and are not designed for classroom teaching.

View new resources

Lesson details

Key learning points

  1. SQL is used to manage data within relational databases.
  2. SQL allows users to interact with and interrogate data through standardised commands.
  3. The SQL CREATE command can be used to create a new table.
  4. SQL statements must follow specific syntax rules to execute correctly.

Keywords

  • CREATE - An SQL CREATE statement allows you to create a new table in a database.

Common misconception

SQL statements can only be used with exisiting tables.

SQL statements can be used to perform other actions on a databse such as creating new tables.


To help you plan your year 11 computer science lesson on: Data management with SQL statements, download all teaching resources for free and adapt to suit your pupils' needs...

This lesson can be completed without using a DBMS, but pupils could complete the activities practically using MySQL.
Teacher tip

Equipment

Licence

This content is © Oak National Academy Limited (2025), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).

Lesson video

Skip lesson video

Loading...

Prior knowledge starter quiz

Download quiz pdf

6 Questions

Q1.
Which SQL statement is used to retrieve all columns from a table?
Correct Answer: SELECT *
Q2.
Which SQL keyword is used to add new data to a table?
Correct Answer: INSERT
Q3.
What is a primary key in a database table?
a column that stores images
a field that can be left empty
a label for the table
Correct answer: a unique identifier for each record
Q4.
What does the WHERE clause do in an SQL statement?
Correct answer: limits which records are affected
specifies which columns to display
renames the table
adds new columns
Q5.
What is a foreign key?
a key that is always unique
Correct answer: a field linking to a primary key in another table
a field that stores passwords
a key used for sorting
Q6.
Match each SQL keyword to its function:
Correct Answer:SELECT,retrieve data

retrieve data

Correct Answer:INSERT,add new data

add new data

Correct Answer:DELETE,remove data

remove data

Correct Answer:UPDATE,change existing data

change existing data

Assessment exit quiz

Download quiz pdf

6 Questions

Q1.
Which of these is True about SQL?
It is only used for searching data.
It cannot delete records.
It is not used with databases.
Correct answer: It can manage, create, and change data.
Q2.
What does the SQL CREATE command do?
updates data in a table
Correct answer: creates a new table in the database
deletes a table
searches for records
Q3.
What must you always follow when writing SQL statements?
Correct answer: syntax rules
colour coding
file size limits
font choices
Q4.
Which command would you use to change data in an existing record?
Correct Answer: UPDATE
Q5.
Put these steps in order to create and fill a new table in SQL:
1 - Write the CREATE statement.
2 - Execute the statement.
3 - Use INSERT to add data.
4 - Check the table with SELECT.
Q6.
Which SQL command correctly creates a table called tblStudents?
Correct answer: CREATE TABLE tblStudents;
CREATE tblStudents TABLE;
TABLE CREATE tblStudents;
CREATE TABLE: tblStudents;