← 🗃️ SQL Deep Dive9 / 25
Lesson 9 — NULL handling
Missing values
COALESCE picks the first non-null; NULLIF turns a value into NULL.
Why it matters: real data has gaps you must handle.
Task
Show 0 when amount is NULL.
Keep going with SQL Deep Dive
Ready for more? These paid resources pick up where this lesson leaves off.
UdemyBestsellers
Top-rated SQL Deep Dive courses
Project-based SQL Deep Dive video courses — the perfect paid next step after these free lessons.
Browse on Udemy →AmazonReader picks
Best SQL Deep Dive books
Hand-picked SQL Deep Dive books to master the fundamentals offline.
See on Amazon →Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.