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

3 Mga view
techcommercementor

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-cour
๐Ÿ…Tableau https://www.datawithbaraa.com/....course/tableau-ultim
๐Ÿ…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.not....ion.site/My-Favorite
๐Ÿ“ฉ Sponsorships baraa@datawithbaraa.com

โ”โ”โ”โ”โ”

*Get 25%* OFF DataCamp's Here
https://www.datacamp.com/coupo....n/membership-2Fcheck

โ”โ”โ”โ”โ”

*MY FREE COURSES*
*SQL* https://youtu.be/SSKVgrwhzus
*Python* https://www.youtube.com/playli....st?list=PLNcg_FV9n7q
*Tableau* https://youtu.be/UcGF09Awm4Y
*Real World Data Projects* https://www.youtube.com/playli....st?list=PLNcg_FV9n7q
*Data Career Roadmaps* https://www.youtube.com/playli....st?list=PLNcg_FV9n7q

โ”โ”โ”โ”โ”

๐ŸŽ *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

Magpakita ng higit pa

0 Mga komento Pagbukud-bukurin Ayon

Walang nakitang komento