If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ Timestamp 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 Enjoy !
Thank you Baraa for another excellent SQL tutorial! This entire Advanced SQL course has been the most comprehensive and easy to follow SQL teaching I've ever received!
I would like to thank you, Baraa, for this amazing course. I have been taking a lot of SQL courses for the past two years, but your curse is definitely the best one that I have watched.
You're making really great videos! Keep working hard on the concepts, and the views and subscribers will follow. Stay focused and keep up the good work!
Thank you so much for your exceptional SQL tutorials! Your clear explanations and well-organized presentation made complex topics easy to understand. I also appreciate your impressive video editing skills; the way you present the screen is very effective. If possible, I would love to see more content from you, especially tutorials on Python. Your teaching style would be incredibly helpful for learning Python as well. Thanks again for all your hard work!
i feel like your yt channel might go big in the future..there is no content like this on any platform afaik not udemy, not a website..this is too good.. if this was a stock id have invested huge in this.. i just hope more people come to appreciate your amazing work and as always Thank you..
Hello Baraa. I am enjoying every bit of learning on this channel. I love the presentations and the simplicity of concepts, which makes it very easy to learn. I work remotely, and at times, I do presentations. If you don't mind me asking, how do you make your presentations or what tools and software do you use? Thank you.
Thanks for your amazing video! Could you please share the way you approach a huge dataset? I am sometimes overwhelmed with it and got lost with a table with 60 columns or more. Thanks
Dear Baraa, First of all thanks for these amazing tutorials on Advanced SQL, your videos reflect how much heart you put into them. I have a small query related to DATETRUNC function, is it that DATETRUNC always returns DateTime2? Asking this because I executed the following query and the output is in date type not dateTime2: select DATETRUNC(year, OrderDate) from Sales.Orders Thanks :)
@@DataWithBaraa yes baraa, if you could upload the lessons in shorter span of time, it would be much beneficial. We know you might be busy with your job and then making and editing the content too takes time. However, we appreciate the way you teach. You'are one of the best teacher and your lessons are top notch. A big Thankyou..
I think the presentations and notes of advance sql are not availaible in your website. If I am clicking on it its showing to documentation of downloading sql server management. Pls look into this.
@@DataWithBaraa yes, definitely..but clicking on that only is showing up the 'download sql server management studios' . I am clicking on ch 4 - case statements > Presentation bur it's opening like I have mentioned above
In MySQL, there are no direct equivalents to DATETRUNC() but you can get the same effect if you use DATE_FORMAT(your_date_column, '%Y-%m-01'). And for the EOMONTH there is function in MYSQL called LAST_DAY()
When will you make the video CTE Topic please bring it fast I am waiting from many videos. I was following your all videos from the SQL playlist. Can you provide us Question bank which help us with interview preparation and when will you upload the SQL Project.
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
⏱ Timestamp
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
Enjoy !
Thank you Baraa for another excellent SQL tutorial! This entire Advanced SQL course has been the most comprehensive and easy to follow SQL teaching I've ever received!
very addictive content.
best part is > I do not have any problem with this addiction.
Love it.
Thank you sir.
You're rocking!!!
So nice of you
I would like to thank you, Baraa, for this amazing course. I have been taking a lot of SQL courses for the past two years, but your curse is definitely the best one that I have watched.
I am really glad you liked it, thanks for the nice feedback ❤️
Best videos on SQL I have come across! Thank you so much Baraa!
Thanks dear, glad to hear that !
Thanks a lot for your smart lessons!
POWER BI like button👍
Thank you, Baraa for teaching us
You're making really great videos! Keep working hard on the concepts, and the views and subscribers will follow. Stay focused and keep up the good work!
Thank you so much for your exceptional SQL tutorials!
Your clear explanations and well-organized presentation made complex topics easy to understand. I also appreciate your impressive video editing skills; the way you present the screen is very effective.
If possible, I would love to see more content from you, especially tutorials on Python. Your teaching style would be incredibly helpful for learning Python as well.
Thanks again for all your hard work!
Best SQL tutorial series ever. Thanks Baraa, you're the MAN.
i feel like your yt channel might go big in the future..there is no content like this on any platform afaik not udemy, not a website..this is too good..
if this was a stock id have invested huge in this..
i just hope more people come to appreciate your amazing work and as always Thank you..
I feel the same way. Thanks for expressing my feelings so well.
always love your contents :)
Thank you Baraa for making such amazing content, Today I have completed this tutorial with practice and notes making.
Wonderful!
Thankyou !!
great content thank you very much
Baraa the Data Guru. Thanks a lots
You are welcome :)
Thanks Baraa.
Hello Baraa. I am enjoying every bit of learning on this channel. I love the presentations and the simplicity of concepts, which makes it very easy to learn. I work remotely, and at times, I do presentations. If you don't mind me asking, how do you make your presentations or what tools and software do you use? Thank you.
Thankyou so much sir
Grand level editing
😏
Great❤
@@kumargupta7149 ❤️
thanks
Thanks for your amazing video! Could you please share the way you approach a huge dataset? I am sometimes overwhelmed with it and got lost with a table with 60 columns or more. Thanks
thanks baraa
You are welcome !
Thank you
welcome !
THANQ FOR THIS VIDEO💓💓
Dear Baraa,
First of all thanks for these amazing tutorials on Advanced SQL, your videos reflect how much heart you put into them.
I have a small query related to DATETRUNC function, is it that DATETRUNC always returns DateTime2?
Asking this because I executed the following query and the output is in date type not dateTime2:
select
DATETRUNC(year, OrderDate)
from Sales.Orders
Thanks :)
Wooow thanks
Welcome !
nice
Thanks
wait, you were recording at 20:40 and you still had natural light from your window? 🤔
Please make power bi videos like this
Brother, thankyou lot but please, upload cte and subquries quickly.
In the next chapters, i am doing my best :)
@@DataWithBaraa yes baraa, if you could upload the lessons in shorter span of time, it would be much beneficial. We know you might be busy with your job and then making and editing the content too takes time. However, we appreciate the way you teach. You'are one of the best teacher and your lessons are top notch. A big Thankyou..
❤@@DataWithBaraa
Which software do you use to record your webcam and screen simultaneously.
Hi Baraa ,please make video on CTE AND ADVANCE JOINS TOPICS
I think the presentations and notes of advance sql are not availaible in your website. If I am clicking on it its showing to documentation of downloading sql server management. Pls look into this.
If you scroll down in the same page you will find for each chapter there is like section, i have added for this chapter the SQL scripts.
@@DataWithBaraa yes, definitely..but clicking on that only is showing up the 'download sql server management studios' . I am clicking on ch 4 - case statements > Presentation bur it's opening like I have mentioned above
Hey Baraa, are the notes going to be available for these tutorials?
❤❤❤❤
❤️❤️❤️❤️❤️
hey baraa , what is alternative of datetrunc() and EOMONTH() in mysql ???
In MySQL, there are no direct equivalents to DATETRUNC() but you can get the same effect if you use DATE_FORMAT(your_date_column, '%Y-%m-01'). And for the EOMONTH there is function in MYSQL called LAST_DAY()
When will you make the video CTE Topic please bring it fast I am waiting from many videos. I was following your all videos from the SQL playlist. Can you provide us Question bank which help us with interview preparation and when will you upload the SQL Project.
Hi, CTE are coming in the next chapters, working on it !
Please make it on Power bi
How will round timestamp nearest 5 minutes interval, and aggregate data accordingly. Expected 5 minutes data instead of every minute
Sir If you possible please Mack Power BI Classes like Tableau Desktop ........I will wait to Learn power BI Full Course
Sir please mack SQL sub query,CTE, View's,Temp Table Clases
I keep getting an error with the DATENAME & DATEPART function. What am I doing wrong?
it depends on which database you're working on
I am Waiting for remaining SQl Classes
A Date is when you take her out 😂😂
😂😂😂😂😂😂😂😂
thank you Sir
thank you
hi bara i have a question when ever u are writing a subquery u are writing letter t after the closing bracket of select statement can i know why?
Thank you
Welcome!