Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #SQL Course 15
Play lesson

SQL Ultimate Course - SQL Date & Time Functions | DATEPART, DATENAME, DATETRUNC, EOMONTH | #SQL Course 15

Unlock the Power of SQL: From Basics to Mastery with Visual Clarity!

5.0 (4)
36 learners

What you'll learn

Understand and use essential SQL SELECT queries and clauses.
Install and configure SQL Server for data management.
Implement various SQL join techniques for efficient data querying.
Utilize SQL functions and operators for data manipulation and analysis.

This course includes

  • 60.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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-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 [email protected] ━━━━━ *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: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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere