Tables and records
Tables and records organise data into rows and columns with declared types, so the database itself rejects nonsense before it is stored.
Python for Kids · Class 9 · Module 6 of 9
Databases with Python
Files are fine for a hundred records. Databases are built for a million.
8 sessionsSessions 41–48
4 weeksTypical pace
Intermediate to AppliedLevel
Class 9Python & Coding
The big idea
Students design tables, insert and query records, and learn why a database enforces structure. The four operations — create, read, update, delete — cover the data layer of virtually every application ever built.
Why it matters
Every app a student uses is backed by a database. Understanding tables and queries demystifies an enormous amount of technology at once.
Unpacked
What you will actually learn
Three core ideas, each taught with worked examples and then practised until it feels obvious.
CRUD concepts
CRUD is the complete set: create, read, update, delete. Every data feature in every app is some combination of those four.
Safe queries
Safe queries use parameters rather than glued-together strings — the habit that prevents SQL injection, one of the oldest attacks on the web.
Did you know?
SQLite, the database in this module, is the most widely deployed database engine on earth — it runs inside phones, browsers, cars and aircraft.
Common mix-up
“A database is just a spreadsheet.” A spreadsheet stores values; a database enforces rules, relationships and integrity across millions of rows.
Session by session
Your 8-session journey
Sessions 41–48 of the 72-session year, at two one-hour sessions per week.
- 1
Warm-up and big picture
Where this module fits, what you will build, and a hands-on starter that gets everyone curious about tables and records.
- 2
Tables and records
Guided teaching on tables and records, worked through together with the teacher.
- 3
Tables and records — practice lab
Independent practice, small challenges and one deliberate mistake to diagnose.
- 4
CRUD concepts
Guided teaching on crud concepts, building directly on the previous two sessions.
- 5
CRUD concepts — practice lab
Applied tasks that combine tables and records and crud concepts in one piece of work.
- 6
Safe queries
Safe queries introduced and practised, completing the toolkit needed for the project.
- 7
Project build
Guided build session for the module project: Personal reading database.
- 8
Test, present and reflect
Finish, test against the checklist, present the work and explain the decisions behind it.
Project lab
Personal reading database
Every module ends with something the student built themselves and can demonstrate. This is the piece that goes into their portfolio and gets explained out loud at the end of session 48.
Try this at home
Build a reading database, add twenty real books, then answer with queries: most-read author, average pages, and which month you read most.
It is finished when
- It works from start to finish without breaking
- You can explain every part of it in your own words
- You tested it and improved at least one thing afterwards
- Someone else used or understood it without your help
By the end of this module
Students finishing Module 6 can:
- Explain and use tables and records without prompting
- Explain and use crud concepts without prompting
- Explain and use safe queries without prompting
- Build and finish personal reading database
- Test your own work and correct what you find
- Talk an adult through what you made and why
Word bank
The vocabulary introduced here, in plain language:
- table
- A structured set of rows and columns in a database.
- query
- A request for specific data from a database.
- CRUD
- Create, read, update, delete.
Module challenge
Think you have got this?
0 XPLevel 1 · Curious Beginner
6 quick questions drawn from this module — vocabulary, the project you build, and a myth-or-fact round. Every wrong answer explains itself, so a mistake still teaches you something.
Your child's free trial is one message away.
Tell us your child’s class and what they enjoy. We will suggest the closest program fit—no pressure and no upfront payment.