SQL Bronze: Lesson Plan

horizontal line

In this unit, pupils will be introduced to SQL. They will explore basic SQL commands while also completing a series of activities that require them to apply the knowledge they have gained throughout this unit.

NOTE - Although a large amount of slides the way they are set up means you go through quickly.

Overview of slides and activities: SQL Bronze

Slides/Activities

Brief overview

Learning objectives

Activity 1

Database and SQL

Slide 2 - 10


Type of activities

- Class discussion

- Videos

- Discussion task in pairs/small groups

Most people interact with databases every day without realising it. These sets of slides introduce pupils to a very basic understanding of what data and information is and raises awareness of the power of data. This also highlights some personal data that is generated and gathered by popular devices they may use.

●        Understanding the difference between data and information and give an example of each.

●        Give examples of websites/apps/companies/organisations etc that stored data.

●        Have an awareness of personal data that may be gathered about them through some apps or websites they use.

Activity 3

SQL

Slide 11 - 28


Type of activities

- Class discussions

- Discussion and unplugged tasks in pairs/small groups

- Individual practical task

- Demos with live coding

Pupils will be introduced to what SQL is and the basic commands; SELECT/FROM/WHERE and have practical tasks to explore using these commands.


They will be given a database about sports stars. In this activity they will be given a set of queries that they need to write SQL statements to find the correct answers to. To do this they will apply the knowledge of the SELECT/FROM/WHERE commands they have learnt in the previous slides.

●        Understand what a query is.

●        Understand and familiarise themselves that SQL statement SELECT * means select all columns.

●        Awareness that SQL can display specific columns and multiple columns from a database.

●        Apply knowledge of the SELECT/FROM/WHERE commands to run queries on a database.