PostgreSQL Foundations·Practice drills 3

Drill 8: Make it smaller — Creating tables and relationships

Write a smaller version of the example that keeps the core idea.

Intermediate 5 min read Lesson 82 of 300 Challenge included

What you will be able to do

Write a smaller version of the example that keeps the core idea.

Practice task

Write a smaller version of the example that keeps the core idea.

schema.sqlSQL

create table courses (
  id integer generated always as identity primary key,
  slug text not null unique,
  title text not null
);

create table lessons (
  id integer generated always as identity primary key,
  course_id integer not null references courses(id) on delete cascade,
  title text not null,
  minutes integer not null
);

Your turn

Write your answer

Easy

Write a smaller version of the example that keeps the core idea.

TEXT · starter

Your answer…

Study tools

Make it yours.

Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.

Sign in to save notes and flashcards.Both are private to your account and stay with your progress.

Finished reading?

Lock in what you just learned.

Mark this lesson complete to save your place and move one step closer to the certificate.

Next: Drill 8: Improve it — Writing data in transactions

Lesson 82 of 300 · 0% of course