
SQLite: joining tables lesson for Pearson Edexcel International A Level Computer Science, with editable PowerPoint slides, a student worksheet and full answers. Students use SQL JOIN in Python to combine data from linked SQLite tables using primary and foreign keys.
Written for Unit 2 Practical Programming, topic 8 Organising and handling data (specification 8.3.4). Everything is editable, so you can adapt it to your class.
What’s included- PowerPoint lesson (16 slides) with teacher notes on every slide
- Student worksheet (Word), ready to print or edit
- Answer sheet (Word) with mark-scheme style answers for every question
By the end of the lesson students can:
- Combine related tables with INNER JOIN … ON, including three-table joins
- Use LEFT JOIN to keep unmatched rows and find missing data
- Combine the results of two queries with UNION
Worksheet sections: A. Recall; B. Predict; C. Write the query; D. Exam-style questions; E. Challenge
Every lesson includes- Learning goals and a starter question
- Clear explanations, diagrams and worked examples (Python 3 throughout, as the specification requires)
- A quick check and a “your turn” task linked to the worksheet
- Exam-style questions with marks, and an exit ticket
- PowerPoint (.pptx) and Word (.docx), fully editable
- Works in PowerPoint and Google Slides
- Calm, muted sixth-form design, consistent across the whole course
These are independent resources written for the Pearson Edexcel International Advanced Level Computer Science specification (Issue 1, first teaching 2026; IAS XCP01, IAL YCP01). They are not produced or endorsed by Pearson.
More lessons in this series- Previous lesson: SQLite: select, filter and aggregate – Edexcel IAL CS lesson
- Next lesson: Designing programs – Edexcel IAL Computer Science lesson
- Save with the bundle: Organising and handling data – Edexcel IAL CS (11 lessons)
Last updated: November 2026.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.