Working with SQL NULL values | Null Handling Functions

In this video we will be talking about SQL NULL values. Following aspects will be covered :
1- How to filter null values
2- How to handle null values
3- ISNULL and COALESCE functions
4- How aggregate functions handle nulls
5- how to insert nulls into a table.

[@denizcantasdelen9755]

It is a tradition on youtube that many channels do not get number of subscribers and views that they actually deserve. Your sql videos are among the best ones in terms of their quality and hardness

[@ankitbansal6]

Thank you 😊

[@tupaiadhikari]

On this auspicious event of Teachers Day, I would like to wish you Happy Teachers Day. Your Videos are invaluable and thanks to your You Tube channel, that many like me are feeling confident with SQL since the last 3-4 months.

[@ankitbansal6]

Thank you so much 💗

[@kanchankumar3355]

Helpful, thanks for putting it up !!

[@ankitbansal6]

Glad it was helpful!

[@pradeep09ca04]

Yours Video, Certainly attracts the audience 👍as well as proven to be the KEY to understand the conecpts from "0 to strong exception" handilng data, to helped many of Data Professionals like me.
Thanks for putting efforts to create this Video

[@ankitbansal6]

Thank you 😊

[@abhishek_grd]

Thanks !!

[@lokeshvaishnav218]

Your videos are amazing 🤩 , Extremely sleek and explanation is very clear

[@ankitbansal6]

Happy to hear that!

[@deeptidogra7948]

Very Informative ..Thanks

[@ankitbansal6]

Glad it was helpful!

[@priyankas-ov6kk]

Thank you for this video. Supreb

[@ankitbansal6]

You are welcome

[@nihal2725]

good stuff

[@djjiang3718]

Thank you and good share!

[@ankitbansal6]

Glad you enjoyed it

[@guddu11000]

Hello Ankit jee, i have scenerio that i have forex data table where i have some missing dates in a week and missing data for complete whole week in a month. I want to find all the missing dates in fact table and generate the data and fill the data from previous filled value. how can i achive

[@nipunshetty9640]

How to handle null values if it's present in 1 million number of records of data?.

[@gobindaroy7811]

amazing explanation Sir

[@ankitbansal6]

Keep watching

[@mahesh6701]

Ankit, could you please put a video on Index, Cluster index and Non-Cluster Index with real time example questions for better understanding. Thanks.

[@ankitbansal6]

Sure

[@agrim8863]

Hi, I have been following your videos for quite a long time. Need some advice from you I come from a non IT background thus a novice programmer want to get into field of data analytics and data science. Please guide me.

[@ankitbansal6]

You can start learning basics of SQL and Excel first. Once you are comfortable with basics practice questions from my channel. Later you can learn one BI tool like tableau or power BI.

[@parthchadha9676]

Hello ankit,
I tried adding more rows will null values in them and then run the coalesce function but is returns only the first value in all 3 nulls instead of different values.
Am I understanding it wrong?
Here is my code :
Select *, isnull(age,8), coalesce(age,9,10)
from customer

[@mayurkanth6987]

Of course it will show the first value provided first value should be NOT NULL.
Put First value as NULL and then see it will return 2nd value in coalesce

[@prabhavpushkar3869]

will these expressions be same for oracle pl/sql or specifically only for t-sql

[@ankitbansal6]

Yes

[@hanson4christ496]

When I use ISNULL(salary,0)
It's not passing the value 0 to my empty fields 😊

[@Subo64]

Toomuch background noise

[@praveenbhandari2516]

The content is too good but there is a lot of background noise also in between the video

[@ankitbansal6]

Sorry about it. Only in a few videos that is the case. Most others are good.

[@praveenbhandari2516]

@@ankitbansal6 yeah no worries but your video is totally worth for me and it's incredible they way to teach. Please upload this kind of video .I have a request if you will make a video data analyst to data engineering how we can change the job