SQL Case Statements For Data Science Interviews in 2021

Опубликовано: 05 Ноябрь 2024
на канале: StrataScratch

45,309

1.4k

Let's cover 3 types of SQL case statements that show up on data science interviews and that you'd use daily as a data scientist. I'll cover 3 different use cases for SQL case statements, explain the nuances, and what goes on behind the scenes when you execute your SQL query. All of this hopefully to make you better on your data science interviews.

Follow along interactively by coding the solutions to the questions:
CASE statement for numerical values: https://platform.stratascratch.com/co...
CASE statement for text: https://platform.stratascratch.com/co...
The most popular CASE statement on SQL interviews: https://platform.stratascratch.com/co...

______________________________________________________________________

This series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in SQL. These are real data science interview questions. For some background context and an intro about what this series is about: https://bit.ly/36kKbxG

👉 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://platform.stratascratch.com/co...

______________________________________________________________________
Timestamps:

Intro: (0:00)
Categorizing based on numerical values: (1:13)
Case statement helpful tip #1: (3:33)
Case statement helpful tip #2: (5:30)
Categorizing based on text: (6:30)
SQL helpful tip #3: (8:41)
Quick & dirty Case statement: (9:52)
Case statement helpful tip #4: (11:46)
Outro: (14:00)

_____________________________________________________________________
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.

Head over to https://platform.stratascratch.com/co... to solve a data science coding question.
______________________________________________________________________
Contact:

If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at [email protected]
______________________________________________________________________

#sql #sqlinterviews #datascienceinterviews