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

Starter Quiz