Computer Science

Structured Query Language: declarative language designed for managing data held in a relational database management system

an SQL INSERT statement allows you to add data into pre-existing tables

an SQL UPDATE statement allows you to modify records

SQL fundamentals

Database fundamentals

Database design

SQL searches

Data management with SQL statements

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

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

What is the main purpose of the SQL UPDATE statement?

Why should you be careful when deleting data using SQL?

Match the example to the SQL statement used:

You might break relationships with other tables

What might happen if you delete a record without checking for links?

Which of the following best describes an entity in a database context?

Which role is responsible for maintaining databases using a DBMS?

Drawing entity-relationship diagrams automatically

Which of these is NOT a function of a DBMS?

Arrange these from most general to most specific:

A collection of related data stored together, made up of tables

A set of data arranged in rows and columns within a database

A request to search for or retrieve specific information from data

A single category of data within a table, such as “Name”

Match each database term to its correct description:

SQL fundamentals

Lesson outcome