CAMBRIDGE IGCSE 0478
Module 9
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).
6 lessons
•
70 mins total
Module Lessons
6 lessons
0
9.0 Module Overview: Relational Databases and SQL
5 mins
•
Open Theory
1
Database Terminology: Tables, Records & Field Data Types
10 mins
•
Open Theory
2
Primary Keys, Foreign Keys & Data Integrity
10 mins
•
Open Theory
3
Structured Query Language (SELECT, FROM, WHERE)
15 mins
•
Open Theory
4
SQL Ordering & Aggregate Functions (ORDER BY, SUM, COUNT)
10 mins
•
Open Theory
5
Mixed Practice: Databases
20 mins
•
Open Theory