Files and databases

Reading and writing files, relational databases and SQL: logging the robot's runs and asking questions of the log.

Module F7GCSE5 lessons

Start in the simulator
  1. F7.1 Reading and writing files Open, read, write, append and close: a run log in a CSV file.
  2. F7.2 Relational databases Tables, records, fields, primary and foreign keys, and avoiding redundancy.
  3. F7.3 SQL: SELECT SELECT, FROM, WHERE and ORDER BY on the class's robot runs.
  4. F7.4 SQL: two tables and changing data Queries across two tables; INSERT, UPDATE and DELETE, and the robot logging its own runs.
  5. F7.5 Project: the logbook Log every run to a file, load the file into a table, and find the best run with SQL.