# Cambridge IGCSE™ Computer Science (0478 / 0984): Section 9: Relational Databases & SQL

> Single-table database entities, fields, records, validation, primary keys, and SQL queries (SELECT, FROM, WHERE, ORDER BY ASC/DESC, SUM, COUNT, AND, OR).

- **Track:** [Cambridge IGCSE™ Computer Science (0478 / 0984)](https://csmasters.dev/tracks/igcse-0478.md) (CAMBRIDGE IGCSE 0478)
- **Module:** Section 9: Relational Databases & SQL
- **Total Lessons:** 6
- **URL:** https://csmasters.dev/tracks/igcse-0478/course_modules/9-databases

---

## Module Lessons

### Lesson 1: [9.0 Module Overview: Relational Databases and SQL](https://csmasters.dev/learn/igcse-0478/00-databases-overview.md)
- **Estimated Duration:** 5 mins
- **XP Reward:** 5 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/00-databases-overview

### Lesson 2: [Database Terminology: Tables, Records & Field Data Types](https://csmasters.dev/learn/igcse-0478/database-fields-and-records.md)
- **Estimated Duration:** 10 mins
- **XP Reward:** 90 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/database-fields-and-records

### Lesson 3: [Primary Keys, Foreign Keys & Data Integrity](https://csmasters.dev/learn/igcse-0478/primary-keys-and-validation.md)
- **Estimated Duration:** 10 mins
- **XP Reward:** 90 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/primary-keys-and-validation

### Lesson 4: [Structured Query Language (SELECT, FROM, WHERE)](https://csmasters.dev/learn/igcse-0478/sql-select-queries.md)
- **Estimated Duration:** 15 mins
- **XP Reward:** 160 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/sql-select-queries

### Lesson 5: [SQL Ordering & Aggregate Functions (ORDER BY, SUM, COUNT)](https://csmasters.dev/learn/igcse-0478/sql-ordering-and-aggregates.md)
- **Estimated Duration:** 10 mins
- **XP Reward:** 115 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/sql-ordering-and-aggregates

### Lesson 6: [Mixed Practice: Databases](https://csmasters.dev/learn/igcse-0478/database-review.md)
- **Estimated Duration:** 20 mins
- **XP Reward:** 30 XP
- **Access Level:** Open Theory (All-Access Practice)
- **HTML Link:** https://csmasters.dev/learn/igcse-0478/database-review