SQL Nulls - NVL NVL2 Coalesce | IS NULL | Working Session

What is Null - NVL, NVL2. Coalesce - SQL Interview Question
#null #nvl#nvl2 #what is null in sql
#coalesce #is null #is not null #nullsnowflake

Topics Covered:
What is NULL
How Nulls will be populated
Why to Handle Nulls
How to Handle Nulls - NVL NVL2 COALESCE
How to Extract Nulls
How to Extract Not Nulls

What is Null:
Nothing
No Value
Undefined or unassigned

How Nulls are populated in the db table:
a)adding a new column
b)explicilty mentioning null
c)ignroing the column
d)upating column data to null

Why we want to handle nulls:
Data Quality
If any operation perfomed with null, it will give null value

How can we handle nulls:
NVL
NVL2
COALESCE

How can extract Null Values:
is null

How can we extract not Null Values:
is not null