Common Date Manipulations on Data Science SQL Interviews
Date and datetime manipulations are really common and necessary to do data science work. The skill and concepts are often tested on data science interviews. Extracting components from the date field like year, day, month is super common in analytics. Often times you’re given a date field and asked to calculate or count some metric over years or months. Let's go over these concepts in this video.
Link to the question: http://bit.ly/3jmkH7x
______________________________________________________________________
👉 Subscribe to my channel: https://bit.ly/2GsFxmA
👉 Playlist for more data science interview questions and answers: https://bit.ly/3jifw81
👉 Playlist for data science interview tips: https://bit.ly/2G5hNoJ
👉 Practice more real data science interview questions: https://bit.ly/2QhnNMh
About The Platform:
I'm using StrataScratch, a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit https://platform.stratascratch.com. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
-
7:17
Pharos Technology
1 year agoBecome a Time Lord: Mastering Date Functions in Microsoft Access
6 -
21:57
Joram Mutenge
7 months agoPython Polars Tutorial (Part 10): Working with Dates and Time Series Data
19 -
49:35
IT MADE SIMPLE
11 months agoMaster SQL Date Functions: Beginner's Guide
30 -
3:32
Learn and Grow
1 year agoSQL Server Date and Time Functions Tutorial (Part 2)
-
2:37
Learn and Grow
1 year agoSQL Server Date and Time Functions Tutorial (Part 1)
-
6:46
Learn and Grow
1 year agoSQL Server Date and Time Functions (DATEADD AND DATEDIFF) Tutorial (Part 3)
2 -
12:24
Dexcelo
1 year agoCalculate dates difference in Excel | Excel Practice Case #17
7 -
8:32
Computergaga
11 months agoWorking Days Between Two Dates in Power BI (NETWORKDAYS 🗓️)
5 -
1:49
Snapshot Systems
10 months agoIntroduction to Date Runner
14 -
3:08
sober71pk2004
10 months agoHow to Calculate Age Using a Date of Birth in Excel