Synopsis: Fear of the Unknown

Let’s get introduced to the antipattern that arises because of considering the NULL value as an ordinary value.

In our example bugs database, the Accounts table has columns first_name and last_name. We can use an expression to format the user’s full name as a single column using the string concatenation operator:

Get hands-on with 1200+ tech skills courses.