Lesson 2 of 3 · 10 min

Relationships

Tables connect through foreign keys: an orders table references a customers table.

One-to-many is the workhorse: one customer, many orders.

Practice

Sketch students and courses tables and decide how enrollments connect them.

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Try table designs and queries with fictional sample data.

Browser SQL playground; never paste private or personal data.