MODULE 04 / LESSON 19● READY TO LEARN

Constraints

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore constraints. 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 grades(id INTEGER PRIMARY KEY, score INTEGER CHECK(score BETWEEN 0 AND 100));

03 / KNOWLEDGE CHECK

Which statement best describes constraints?

◈

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