MODULE 01 / LESSON 04● READY TO LEARN

Keys and Relationships

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore keys and relationships. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

02 / SQL EXAMPLE

◉ example.sqlSQL

CREATE TABLE courses(id INTEGER PRIMARY KEY, title TEXT NOT NULL);

Try in SQL Lab ↗

03 / KNOWLEDGE CHECK

Check your understanding

Which statement best describes keys and relationships?

◈

Enjoying the lesson?

Create a free account to take the quiz and save your progress.

Create account ↗