SQL aggregate functions – IB Computer Science lesson

Databases – IB Computer Science (18 lessons)

18 ready-to-teach lessons for IB Diploma Computer Science (first assessment 2027): Databases. Every lesson has editable PowerPoint slides, a student worksheet and full answers, and the bundle costs less than buying the lessons one by one. A complete, ready-to-teach bundle for IB Computer Science (first assessment 2027): Databases, in 18 bespoke lessons written for the new syllabus. Every lesson comes with: - **Editable PowerPoint slides** – goals, starter, explanations, worked examples, a task and an exit ticket, with teacher notes - **Student worksheet (Word)** – structured questions that build from recall to exam-style application - **Answer sheet (Word)** – full model answers for quick marking or self-assessment Worth £89.82 if bought lesson by lesson. ## What's inside **A3.1 Database fundamentals** - A3.1.1 Relational databases **A3.2 Database design** - A3.2.1 Database schemas - A3.2.2 Entity relationship diagrams - A3.2.3 Datatypes - A3.2.4 Constructing tables - A3.2.5 Normal forms: 1NF, 2NF and 3NF - A3.2.6 Normalising a scenario to 3NF - A3.2.7 Denormalising databases **A3.3 Database programming** - A3.3.1 Data language types: DDL and DML - A3.3.2 Constructing queries in SQL - A3.3.3 Updating data with SQL - A3.3.4 SQL aggregate functions *(HL)* - A3.3.5 Database views *(HL)* - A3.3.6 Database transactions *(HL)* **A3.4 Alternative databases and data warehouses** *(HL only)* - A3.4.1 Different types of database - A3.4.2 Data warehouses - A3.4.3 OLAP and data mining - A3.4.4 Distributed databases ## Why teachers use it - Mapped code by code to the 2027 IB CS guide, so coverage is easy to track - SL and HL content clearly labelled - Fully editable – adapt to your class, timings and school template - Works for teaching, revision, cover lessons and homework Last updated: November 2026.