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.

  • Resume progress from your account
  • Exercises with expected results and explanations
  • Guided Sales Analysis project
Create my Discovery spaceI already have an account
Free permanent access.
Handle missing values with NULL and COALESCE — SQL lesson — SQL.tn