SQL Tutorial for Data Analysis 22: NULL Related Functions

In this SQL tutorial we're going to learn how to use NULL related functions

Key concepts to remember -
Remember that NULL indicates an empty, unavailable or unassigned value. NULL value does not equal to zero (0), or space (‘ ‘). Null simply means a field with no value.

Course Examples -

ACDB Database -

Written SQL tutorials including exercises -

About Myself -

My Linkedin Page -

My Facebook Page -

SQL Platform Differences (comparing MySQL & Oracle) -

MySQL
* The MySQL equivalent of ISNULL() is - IFNULL()
* IFNULL() can accept two different types of values without the need of CAST()

Oracle
* The Oracle equivalent of ISNULL() is - NVL():