Year 9 · Chapter 15 Databases · Lesson 1. This lesson goes with level 10 of the Byte Lab Year 9 game. Play the level first, then use this page to revise.
Learning objectives. By the end of this lesson you should be able to name the parts of a database table; choose a data type for each field; choose a primary key; and write SQL queries with SELECT, FROM, WHERE, ORDER BY, AND and OR.