Intro

Objectives

• Be able to create a single-table database including:
  • Fields, Records and Validation.
• Suggest suitable data types for fields, including:
  • Text/Alphanumeric;
  • Boolean, Character, Integer and Real;
  • Date/Time.
• Understand the purpose of primary keys.
• Read, understand and complete SQL including:
  • SELECT, FROM, WHERE, ORDER BY, SUM and COUNT.

Resources

Video

[4:19]

[6:43]

Slides

Main activity

Extension activity