Computer Science

allows you to retrieve data from a database

allows you to return all the columns from a database table

SQL searches

Database fundamentals

Database design

SQL fundamentals

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

What SQL command would you use to return every field and all data from a table at once?

retrieve all columns and rows from a table

Match each SQL keyword or clause to its function:

Arrange these actions for using SELECT * in a database:

list only the fields you need after SELECT

Which of these is the best practice when you only need a few fields from a table?

Which SQL statement is used to retrieve data from more than one table?

Arrange these actions for adding data to a table:

Introduction

What will you need for this lesson?

Are you ready to learn?

File you will need for this lesson

Equipment

Worksheet