SQL: NULL Values & CASE Expressions

Wishlist Share

About Course

Understand one of the most common sources of wrong answers in SQL: NULL. This course explains what NULL means, why comparisons with NULL behave unexpectedly, how NULLs affect counts, sums and joins, and how to handle them with IS NULL, COALESCE, NULLIF and CASE expressions.

Tutwoo is an independent learning provider. This course is general skills training based on official documentation. It is not an accredited qualification. Software behaviour can change between versions, so check the official documentation for the version you use.

What Will You Learn?

  • Explain what NULL means and why = NULL never matches Predict how NULL affects COUNT, SUM, AVG and filters Replace or create NULLs deliberately with COALESCE and NULLIF Write CASE expressions to categorise and clean data

Course Content

Course Lessons

  • What NULL means
  • NULL in calculations, aggregates and joins
  • COALESCE and NULLIF
  • CASE expressions

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕