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.
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.