SQL Tips and Tricks - Building Calendar Dimension Table from Scratch with SQL | SQL For Analytics

In this video we are going to create a calendar dimension table from scratch. It is a very important video as calendar table has many use cases and I will be using this table in many of my future videos. Here is the script to get very first row : select cast('2000-01-01' as date) as cal_date ,datepart(year,'2000-01-01') as cal_year ,datepart(dayofyear, '2000-01-01') as cal_year_day ,datepart(quarter, '2000-01-01') as cal_quarter ,datepart(month, '2000-01-01') as cal_month ,datename(month, '2000-01-01') as cal_month_name ,datepart(day, '2000-01-01') as cal_month_day ,datepart(week, '2000-01-01') as cal_week ,datepart(weekday, '2000-01-01') as cal_week_day ,datename(weekday, '2000-01-01') as cal_day_name Start your analytics journey : https://www.namastesql.com/ Zero to hero(Advance) SQL Aggregation: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk #sql #dataengineer #calendar