Computer Science

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

Data management with SQL statements

This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.

Databases and SQL

What must you always follow when writing SQL statements?

Which command would you use to change data in an existing record?

Put these steps in order to create and fill a new table in SQL:

Which SQL command correctly creates a table called tblStudents?

Which SQL statement is used to retrieve all columns from a table?

Which SQL keyword is used to add new data to a table?

What is a primary key in a database table?

What does the WHERE clause do in an SQL statement?

a field linking to a primary key in another table

This lesson will be removed by end of Summer Term 2025.

Data management with SQL statements

Lesson outcome

This lesson will be removed by end of Summer Term 2025.