Resources Education Jobs Schools directory News Magazine Courses Log out Help
Home feed
My list
Courses My Jobs Job alerts My application profile Career preferences Resources Author dashboard
Settings
Edit account Log out
Home Resources Jobs Schools directory News Magazine Courses Register for free Log in Help

Home feed Edit account About us My products Tes for schools Work for Tes Log out
IB Computer Science 2027 – A3.3.3 Updating Data with SQL – Lesson & Worksheet

IB Computer Science 2027 – A3.3.3 Updating Data with SQL – Lesson & Worksheet

Subject: Computing

Age range: 16+

Resource type: Lesson (complete)

Last updated

9 September 2026

pptx, 319.93 KB
pptx, 319.93 KB
docx, 14.87 KB
docx, 14.87 KB
docx, 14.19 KB
docx, 14.19 KB
IB Computer Science 2027 – A3.3.3 Updating Data with SQL – Lesson & Worksheet

IB DP Computer Science 2027 A3.3.3 Updating Data with SQL lesson and worksheet for the new 2027 syllabus.

A classroom-ready resource designed to help students use SQL to insert, modify and delete records in a relational database.

What’s Included
  • Lesson presentation
  • Student worksheet
  • Classroom activities
  • Student tasks
  • SQL update exercises
  • Before-and-after database examples
  • Questions to check understanding
  • Mark scheme / answers
Syllabus Coverage

A3.3.3 – Explain how SQL can be used to update data in a database

Students explore:

  • Inserting new records using INSERT INTO
  • Modifying existing records using UPDATE SET
  • Removing records using DELETE
  • Using WHERE clauses to identify specific records
  • The risks of updating or deleting records without a WHERE clause
  • Updating data in indexed columns
  • The performance implications of modifying indexed data
  • Why indexes may need to be rebuilt or reorganised following significant data modifications
Suitable For
  • IB Diploma Programme Computer Science
  • Standard Level (SL) and Higher Level (HL)
  • New 2027 Computer Science syllabus
  • First assessment: May 2027
  • Secondary students aged 16–18
Resource Type

Lesson (complete)

A ready-to-use lesson resource including presentation, student worksheet and mark scheme.

This is an original teaching resource and is not affiliated with, endorsed by, or produced by the International Baccalaureate Organization (IBO).

Get this resource as part of a bundle and save up to 50%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

IB Computer Science 2027 – A3 Databases Complete Bundle

# IB Computer Science 2027 – A3 Databases Complete Bundle A complete teaching resource bundle covering Topic A3: Databases for the new IB Computer Science 2027 syllabus. This bundle includes 18 classroom-ready lessons covering database fundamentals, relational database design, SQL programming and alternative database systems. Each lesson includes a presentation, student worksheet and mark scheme. ## What's Included - 18 lesson presentations - 18 student worksheets - 18 mark schemes / answer documents - Classroom activities - Student tasks - Real-world database scenarios - SQL practice and database design exercises - Exam-focused questions - Resources for both SL and HL ## Syllabus Coverage ### A3.1 – Database Fundamentals - A3.1.1 Relational Databases - A3.1.2 Database Schemas - A3.1.3 Entity Relationship Diagrams - A3.1.4 Data Types - A3.1.5 Constructing Tables ### A3.2 – Database Design - A3.2.1 Normal Forms - A3.2.2 Database Scenarios - A3.2.3 Denormalizing Databases ### A3.3 – Database Programming - A3.3.1 Data Language Types - A3.3.2 Constructing Queries in SQL - A3.3.3 Updating Data with SQL - A3.3.4 SQL Aggregate Functions - A3.3.5 Database Views - A3.3.6 Database Transactions ### A3.4 – Alternative Databases - A3.4.1 Different Types of Databases - A3.4.2 Data Warehouses - A3.4.3 OLAP and Data Mining - A3.4.4 Distributed Databases ## Suitable For - IB Diploma Programme Computer Science - Standard Level (SL) and Higher Level (HL) - New 2027 Computer Science syllabus - First assessment: May 2027 - Secondary students aged 16–18 ## Resource Type **Complete Bundle** A comprehensive, ready-to-use resource for teaching Topic A3: Databases, with presentations, worksheets and mark schemes for every lesson. The new IB Computer Science course is first assessed in May 2027. :contentReference[oaicite:0]{index=0} *These are original teaching resources and are not affiliated with, endorsed by, or produced by the International Baccalaureate Organization (IBO).*

£44.99

Reviews

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.

£4.99
(no rating)0 reviews

Not quite what you were looking for?Search by keyword to find the right resource: