HelpContactFor teachers and institutes
>_StemPy Lab
Mock TestsClasses

>_StemPy Lab

Learn. Solve. Code the solutions. Test yourself.

Live examsFree mock exams, timed and rankedEveryone starts together, and your score and rank come the moment it ends.See the exams →

Learn

  • Physics
  • Chemistry
  • Mathematics
  • Biology
  • Python Programming
  • Statistics & Data Science
  • Computer Science
  • Classes
  • Groups

Practice

  • Problems
  • Quizzes
  • Mock Tests
  • Prepare for an Exam
  • Question Sets
  • Exams
  • Certificates
  • Python Labs
  • AI Practice Generator
  • Student-Created Tests

Community

  • Discussions
  • Resources
  • Notes
  • Glossary
  • Blog

Account

  • Log in
© 2026 senLearn. All rights reserved.HelpFor SchoolsAboutContactPrivacy PolicyTerms of UseRefund Policy

Learning Paths

Each learning path is one chapter: a guided route through a topic, one small course at a time. Pick a class to see its chapters in order.

All CoursesLearning Paths
ChaptersStudent playlists

Computer Science · IGCSE (9–10)

by StemPy Lab
Chapter 9
Databases and SQL
Databases and SQL

A school keeps a list of every student, a library keeps a list of every book, and a shop keeps a list of everything it sells. Each list is a table in a database. In this chapter you design a table: you choose its fields, a data type for each field, a primary key and the validation the data needs. Then you write SQL scripts that pick out records, sort them, count them and add them up, and you work out exactly what a script will output. Every query runs in Python on the page, so you can check each answer yourself.

3 courses
StemPy LabStemPy Lab