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 !
@relaxationecho3244Ай бұрын
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.
@DataWithBaraaАй бұрын
I am really glad you liked it, thanks for the nice feedback ❤️
@MarcosMartínezGascón16 күн бұрын
Best SQL tutorial series ever. Thanks Baraa, you're the MAN.
@vamc43752 ай бұрын
POWER BI like button👍
@letsdomistakesАй бұрын
Thank you Baraa for making such amazing content, Today I have completed this tutorial with practice and notes making.
@DataWithBaraaАй бұрын
Wonderful!
@OJASIYER2 ай бұрын
Best videos on SQL I have come across! Thank you so much Baraa!
@DataWithBaraa2 ай бұрын
Thanks dear, glad to hear that !
@govardhanreddy6904 күн бұрын
thank you Sir
@pavansaibhyri4122 ай бұрын
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!
@guiltycrown60242 ай бұрын
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..
@Musical_Island3910 күн бұрын
I feel the same way. Thanks for expressing my feelings so well.
@RohitKumar-kd5fj2 ай бұрын
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!
@joyotiegbe1549Ай бұрын
Thanks Baraa.
@reemkhaled13342 ай бұрын
great content thank you very much
@imamkhan95642 ай бұрын
Brother, thankyou lot but please, upload cte and subquries quickly.
@DataWithBaraa2 ай бұрын
In the next chapters, i am doing my best :)
@gauravbharti96762 ай бұрын
@@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..
@imamkhan95642 ай бұрын
❤@@DataWithBaraa
@nitinrawat-g6t2 ай бұрын
thanks
@ofuezuemlynus29652 ай бұрын
Baraa the Data Guru. Thanks a lots
@DataWithBaraa2 ай бұрын
You are welcome :)
@omkale92 ай бұрын
Grand level editing
@DataWithBaraa2 ай бұрын
😏
@CuocSongQuanhTa2042 ай бұрын
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
@user-wc1wu3ls9d2 ай бұрын
Thankyou so much sir
@nitinrawat-g6t2 ай бұрын
thanks baraa
@DataWithBaraa2 ай бұрын
You are welcome !
@kumargupta71492 ай бұрын
Great❤
@DataWithBaraa2 ай бұрын
@@kumargupta7149 ❤️
@poddytalksАй бұрын
nice
@DataWithBaraaАй бұрын
Thanks
@micaelzekarias15372 ай бұрын
Wooow thanks
@DataWithBaraa2 ай бұрын
Welcome !
@rajshekar13622 ай бұрын
THANQ FOR THIS VIDEO💓💓
@rajshekar13622 ай бұрын
Hi Baraa ,please make video on CTE AND ADVANCE JOINS TOPICS
@WrestleLane2 ай бұрын
Please make power bi videos like this
@alieut.k.wolobah25152 ай бұрын
❤❤❤❤
@DataWithBaraa2 ай бұрын
❤️❤️❤️❤️❤️
@AmitYadav-vb5bs2 ай бұрын
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.
@DataWithBaraa2 ай бұрын
Hi, CTE are coming in the next chapters, working on it !
@makarsh292 ай бұрын
hey baraa , what is alternative of datetrunc() and EOMONTH() in mysql ???
@DataWithBaraa2 ай бұрын
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()
@GOLIBHAGYALAKSHMIBhagi2 ай бұрын
Sir If you possible please Mack Power BI Classes like Tableau Desktop ........I will wait to Learn power BI Full Course
@Toyahan4321 күн бұрын
Hey Baraa, are the notes going to be available for these tutorials?
@gauravbharti96762 ай бұрын
Which software do you use to record your webcam and screen simultaneously.
@1wasim.akram22 ай бұрын
Please make it on Power bi
@yashsojitra26532 ай бұрын
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.
@DataWithBaraa2 ай бұрын
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.
@yashsojitra26532 ай бұрын
@@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
@GOLIBHAGYALAKSHMIBhagi2 ай бұрын
Sir please mack SQL sub query,CTE, View's,Temp Table Clases
@bashadude2 ай бұрын
How will round timestamp nearest 5 minutes interval, and aggregate data accordingly. Expected 5 minutes data instead of every minute
@frederickagbenohevi11437 күн бұрын
I keep getting an error with the DATENAME & DATEPART function. What am I doing wrong?
@GOLIBHAGYALAKSHMIBhagi2 ай бұрын
I am Waiting for remaining SQl Classes
@asrithagudla4865Ай бұрын
thank you
@asrithagudla4865Ай бұрын
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?