Computer Science

An SQL SELECT statement allows you to retrieve data from a database.

The SQL SELECT * allows you to return all the columns from a database table.

SQL searches

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