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

Published: 23 July 2024
on channel: Data with Baraa

52,873

1.9k

Visually explained how SQL NULL functions handle missing data using COALESCE, ISNULL, NULLIF, and IS (NOT) NULL.
👉 Subscribe, Like, and Comment If you want more FREE Courses ❤️   / @datawithbaraa

━━━━━

MY COURSES
To get certified, better clean structure & progress, support me:
🏅SQL https://www.datawithbaraa.com/course/...
🏅Tableau https://www.datawithbaraa.com/course/...
🏅Udemy SQL: https://bit.ly/4hH947P
🏅Udemy Tableau: https://bit.ly/3xFiDDk

━━━━━

CONNECT WITH ME
📬 Newsletter https://www.blog.datawithbaraa.com/su...
👨‍💻 LinkedIn   / baraa-khatib-salkini
📸 Instagram   / datawithbaraa
🎥 TikTok   / datawithbaraa
🌍 Website https://www.datawithbaraa.com/
💬 Discord   / discord
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.sit...
📩 Sponsorships baraa@datawithbaraa.com

━━━━━

Get 25% OFF DataCamp's Here
https://www.datacamp.com/coupon/membe...

━━━━━

MY FREE COURSES
SQL    • SQL Full Course for Beginners (30 Hours) –...
Python    • Python Ultimate Course
Tableau    • Complete HR Tableau Project End-to-End | L...
Real World Data Projects    • Data Analyst Portfolio Projects
Data Career Roadmaps    • Data Career Roadmaps

━━━━━

🎁 FREE DOWNLOADS & MATERIALS
https://www.datawithbaraa.com/wiki/sq...

📖 Table of Content
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

This course is perfect for data analysts, data engineers, data scientists, software developers, and students—covering everything from the basics to advanced SQL topics.
#sql #sqlserver #data #analytics #dataanalysis #datascience

On this page of the site you can watch the video online SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | with a duration of hours minute second in good quality, which was uploaded by the user Data with Baraa 23 July 2024, share the link with friends and acquaintances, this video has already been watched 52,873 times on youtube and it was liked by 1.9 thousand viewers. Enjoy your viewing!

13,324

276