Databases

8 min · 10 quiz questions

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.

In this lesson

  • What is a database?
  • Data types
  • The primary key
  • Why use a database?
  • SQL queries
  • Conditions
  • A database in Python
  • Shortcuts to know
  • Real mission: your own database
  • Revision checklist