Series 9
Databases
Flat-file vs relational databases, entity-relationship diagrams, SQL queries, and SQL injection - everything you need for databases questions on all three boards.
Lessons in this series
1
Database Concepts
What databases are for, the difference between flat-file and relational databases, tables, records, fields, data types and primary keys.
Flat-file vs relational
Primary key
Data redundancy
All boards
2
Relational Design and ER Diagrams
Foreign keys, one-to-one, one-to-many and many-to-many relationships, entity-relationship diagrams and how to draw and interpret them.
Foreign key
Relationships
ER diagrams
All boards
3
SQL - Querying Data
Writing SELECT queries with FROM, WHERE, AND/OR, ORDER BY and LIKE. Worked examples with real tables. All three boards require this content.
SELECT / FROM / WHERE
ORDER BY
LIKE / wildcards
All boards
4
SQL Data Manipulation and SQL Injection
INSERT, UPDATE and DELETE commands, querying multiple tables, SQL injection attacks and parameterised queries as a defence. SQL injection is examinable on all boards.
INSERT / UPDATE / DELETE
SQL injection
Parameterised queries
All boards (injection)
Databases Unit Exam
Exam-style questions covering all four lessons. Includes SQL writing questions, truth tables, relationship diagrams and 1-mark / 4-mark / 6-mark style questions from all boards.
Interactive tools for this series