SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #sql Course 15
Visually explained how SQL date and time functions like DATEPART, DATENAME, DATETRUNC, and EOMONTH manage and format dates.
👉 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:22 What is Date, Time, Timestamp?
03:57 Date & Time Values
06:28 Overview Date & Time Functions
09:07 DAY(), MONTH(), YEAR()
12:07 DATEPART()
18:00 DATENAME()
22:34 DATETRUNC()
30:45 EOMONTH()
34:16 Use Case: Data Aggregation
37:36 Use Case: Filtering Data
39:20 Functions Comparison
41:11 All Date Parts
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
-
Kategorie
Keine Kommentare gefunden