SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course 18
75.6K views on YouTube
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 β€οΈhttps://www.youtube.com/@UC8_RSKwbU1OmZWNEoLV1tQg
βββββ
*MY COURSES*
To get certified, better clean structure & progress, support me:
π
SQL https://www.datawithbaraa.com/course/sql-full-course-for-beginners
π
Tableau https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners
π
Udemy SQL: https://bit.ly/4hH947P
π
Udemy Tableau: https://bit.ly/3xFiDDk
βββββ
*CONNECT WITH ME*
π¬ Newsletter https://www.blog.datawithbaraa.com/subscribe
π¨βπ» LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/
πΈ Instagram https://www.instagram.com/datawithbaraa/
π₯ TikTok https://www.tiktok.com/@datawithbaraa
π Website https://www.datawithbaraa.com/
π¬ Discord https://discord.gg/gsVJbMxKcA
π§ Notion Roadmaps https://www.notion.com/@datawithbaraa
β Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link
π© Sponsorships baraa@datawithbaraa.com
βββββ
*Get 25%* OFF DataCamp’s Here
https://www.datacamp.com/coupon/membership-2Fcheckout-3Fcoupon-DATAWITHBARAA25ALE25
βββββ
*MY FREE COURSES*
*SQL* https://youtu.be/SSKVgrwhzus
*Python* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZGfFl2ANI_zISzNp257Lwn
*Tableau* https://youtu.be/UcGF09Awm4Y
*Real World Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7
*Data Career Roadmaps* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd
βββββ
π *FREE DOWNLOADS & MATERIALS*
https://www.datawithbaraa.com/wiki/sql#sql-welcome
π *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