Computer Science

allows you to create a new table in a database

Data management with SQL statements

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data protection, copyright and the law

Data and privacy

Big data

The environmental impact of data systems

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

Data management with SQL statements

Lesson outcome