Lesson 6 of 20

Handle missing values with NULL and COALESCE

Detect missing information and replace it with a context-appropriate presentation value.

19 minDiscovery access

By the end of this lesson

  • Correctly interpret NULL
  • Filter with IS NULL and IS NOT NULL
  • Providing a replacement value with COALESCE

Free Discovery access

Create your space to open this lesson.

Handle missing values with NULL and COALESCE is one of 8 lessons and 15 free exercises linked to an account. No card is required.

30 free days of SQL Pro on registration, subject to the 34 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.