New

Year 11

OCR

Databases and SQL

Lessons (8)

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

These resources were created for remote use during the pandemic and are not designed for classroom teaching.

View new resources

Database fundamentals

I can describe the difference between a flat file and relational database.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Database design

I can design a relational database structure for a given scenario.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

SQL fundamentals

I can create SQL queries to insert and update data stored in a database.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

SQL searches

I can use SQL to retrieve data from a relational database.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Data protection, copyright and the law

I can describe key UK computer laws and explain how they protect data, creative work and software use.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Data and privacy

I can explain how data privacy is maintained in databases and identify regulations that protect personal information.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Big data

I can explain what big data is and describe the challenges it creates for processing and storage.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

The environmental impact of data systems

I can identify the environmental impacts of data systems, discuss sustainability and propose reduction strategies.

1 Slide deck

1 Worksheet

2 Quizzes

1 Video

Can't find what you need?

Create a tailor-made lesson plan and resources on any topic with Aila, our free AI-powered lesson assistant. Entirely adaptable to your class and context.

Create a lesson with AI