SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course #9

Показать описание

☕ Stay connected

📚 Free Courses

🎓Other Platforms (Certifications)

⏱️ Timestamp
00:00 Intro
00:25 What is NULL?
01:23 What are NULL Functions?
03:23 ISNULL
07:35 COALESCE
12:59 COALESCE vs ISNULL
14:33 Handle NULL - Data Aggregation
18:12 Handle NULL - Mathematical Operators
24:23 Handle NULL - Joining Tables
31:28 Handle NULL - Sorting Data
37:01 NULLIF
40:53 NULLIF - Division by Zero
42:58 IS NULL - IS NOT NULL
46:44 Left Anti Join - Right Anti Join

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**

Рекомендации по теме

Комментарии

This video is incredibly insightful, packed with so much knowledge and presented with exceptional clarity. The way you explain complex concepts in such an easy-to-understand manner is truly impressive. Thank you for dedicating your time and effort to create these videos. Your content stands out as some of the best I’ve come across. Keep up the fantastic work!

gurleenkaur

Started with this series today morning, preparing for a interview. Thank u so much Baraa. This helped me so much. was waiting for this part. thanks. Waiting for other parts as well. You don't know how much you have helped me. I am a visual learner and you explaining with all the animations makes this series the best we have on Youtube. Thank you mate🧡

sanjananayak

Hi baraa,
I'm currently upgrading my skills, and your tableau videos are really helping me
Thank you and keep up the good work 😊😊

gsakash

You are the besttt teacher on the entire Youtube!!

priyaljain

This is video has made me to understand how to make use Isnull, Coalesce, NullIF. However, i have been looking how to to apply Left and Right Anti Join in my SQL solution and i am so am i come across this video. Thank you Baraa for this.

donatusohiaeriaku

You have to teach in universities you are going to save lives, thank you again for over-delivering, I want to know how we can support you :)

khawla

Watching from Indonesia. you'r like a hero for me sir, you helped me a lot understanding all this, something i could't found in another channel. thankyou so much, god bless you

wcwulsd

Great!! Baraa. Like always you have made my concepts crystal clear. Awaiting for next video, Thank You so much and lots of love and respect!

ska

You're making really great videos! Keep working hard on the concepts, and the views and subscribers will follow. Stay focused and keep up the good work!

RohitKumar-kdfj

make a "python for data learners" course too, this sql course is top notch

JaspreetKaur-nfok

such high quality lectures with less views dont know why.
I have shared your playlist in my college placement group.
Thanks for such amazing quality lectures

DeepakTiwari-etbd

Just Baraa.
I am crystal clear about SQL concept watching your youtube videos.
keep posting more videos. I am

durgabudhathoki

Well Done, Another Awesome Tutorial Crystal Clear and Concise. Like you stressed right away from the beginning, Null is unknow or missing value, different from zero, I cant see any circumstances null should be replaced by zero except in the division in order to secure the operation validity and return Null. Fair enough. In other operations like aggregation if not replaced with the mean, mode, or some other imputation means, Nulls values are often ignored, I mean dropped at the time of calculations or simply all the records kicked out.
Again, it was an amazing tutorial, thank you a lot for the hard work. I hope to see you sooner on subqueries

osoriomatucurane

Hii sir,
Now i am pursuing data analytics, your tableau 20+hours video very helpful❤can you make video on power bi..please sir make a long video about power bi...
Take love from india ❤

tanmoychatterjee

Your video is amazing. I got so much help from this video a lot. Thank you for helping me out to understand the whole things about Null!!

koreanwoman

let me say this baraa!!
my friends and I are becoming data engineers and are currently studying computer science in London and all of us agree that there is no one better out there who teaches SQL like you do.
I would also love to hear from you what are your thoughts on data engineering, what technologies you would recommend and whether are you planning on any content related to DE.

TheJREshorts

bara waiting for you upload videos and complete this series

nitinrawat-gt

Thanks so much bro for everything u r doing.

micaelzekarias

Thanks for sharing your experience and knowledge, Sir

alieut.k.wolobah

Great work sharing awesome content. Looking forward to more.
Can we expect an end-to-end project data analysis video in the future? From SQL to Tableau? 🤞

strideredz

SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course #9

How to handle NULL values in SQL ? | SQL COALESCE Function with examples

Use of Coalesce and ISNULL in SQL Server | SQL Server Interview Question

SQL | Null Function in SQL | ISNULL | COALESCE | IFNULL | NVL

Coalesce function in sql server Part 16

SQL TUTORIAL - COALESCE, ISNULL

Difference between COALESCE and ISNULL? How are NULLs handled in SQL Server

Oracle interview question difference between null functions | NVL vs NVL2 vs NULLIF vs COALESCE

Working with SQL NULL values | Null Handling Functions

SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course #9

SQL Server - COALESCE and ISNULL

coalesce | isnull sql | sql is not null | isnull sql server | ISNULL | IS NULL

COALESCE and ISNULL In SQL Server

30. SQL Server NULL FUNCTIONS | ISNULL() & COALESCE() | T-SQL Demo

COALESCE() VS ISNULL() | SQL Server | SQL Tutorial

How to return the first non-NULL value in SQL | SQL coalesce() function | coalesce() With Example

ISNULL CASE COALESCE function in SQL

11. SQL NULL Functions - ISNULL(), COALESCE()

MS SQL tutorial on ISNULL and COALESCE

What are the differences between coalesce and isnull functions in SQL

sql server replace all null values in column table ISNULL, COALESCE

NVL, NVL2, NULL IF, COALESCE functions with examples

What is Null - NVL, NVL2. Coalesce - SQL Interview Question

Difference between ISNULL and COALESCE function SQL Server

IFNULL & COALESCE FUNCTIONS in MySQL