Step-by-step Approach to Solving Any Data Science SQL Interview Question (Twitch)

Here's a step-by-step framework to solve any data science SQL interview question. We'll cover a brand new data science interview question from Twitch where I'll walk you through the steps on how to solve the problem and communicate with the interviewer.

______________________________________________________________________

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.

______________________________________________________________________

Timeline:

Intro: (0:00​​​)
Interview Question: (1:16​​​)
Explore data schema: (2:20​​​)
First assumption: (2:38​​​)
Second assumption: (3:15​​​)
Third assumption: (3:40​​​)
Walk through the logic before coding: (5:15​​​)
Coding: (7:35​​​)
Answering follow up questions: (12:08​​​)
Collapsing or combining CTEs and subqueries for optimization: (13:03​​​)
Offering ways to optimize code to show off your knowledge: (14:22​​​)
Conclusion: (15:00​​​)
______________________________________________________________________

About The Platform:

______________________________________________________________________

Contact:

If you have any questions, comments, or feedback, please leave them here!
______________________________________________________________________

#SQL​​InterviewQuestions

[Innovade]

Nate, thank you for these videos. Extremely helpful.

[iitian]

You are awsome sir....Keep posting such a great sql videos....

[prashanthigupta]

Thank you so much for your videos. I learned a lot 👍🏻👍🏻👍🏻

[InYourHorror]

Thanks for putting out all of this great content.

[chaos]

When i first saw it 6-7 months ago got scared and demotivated to shift job. But recently i started practicing sql basics and now Alhamdulillah this video does not look that hard. It gave me great confidence thanks for great video. And can you share your insta id please

[SeattleDataGuy]

Hey, I am digging your videos! I love the focus on particular companies SQL questions.

[PATRICKCHUAD]

Thanks Nate! As always very clear explanation.

[monagulapa]

I shared your youtube channel on my Facebook. Your tutorials are great! Will share it also on my Linkedin.

[djjiang]

Thank you Nate! And love your content and love your web site!

[its_me]

Hey Nate, Your videos really helped me learning SQL...Can you make videos on how to use API for data and then saving it in some database as you told in one of your video that it is important part in data science process and it is widely used in professional data scientist projects?

[ahyoungkim]

hope that i can get any technical interview test soon so that i can apply what i learn from you :)

[curio_cureator]

Great video, and your content has been a huge help preparing for my BIE interview.

Quick question, let's say there was more than one session created at the same time due to dirty data. My intuition is to use ROW_NUMBER() then to get a single first session no matter what, ordering by another column to break weird ties based on assumptions about which session id tends to be the "right" one when duplicated. Am I in the right ballpark here, or am I thinking about this wrong?

[christiankuntz]

Nate, would it also work to select user_id, session_type, MIN(session_start) to identify each users first session type instead of using the rank window function?

[diaconescutiberiu]

Is there a video with this question solved using CTEs and temp tables? I've just started SQL and for now it's not clear to me when to use subqueries, cte or temp tables. Would love to see the same problem solved in 3 ways. It will help with improving the logic as well

[SuperLOLABC]

Will there be a collection of SQL and Python questions asked in PayPal?

[gotchihaeyo]

Can I use
(Select User_ID, MIN( session_start)
From twitch
Where session_type = ' viewer ')
As a sub query instead of rank( )????

[ozan]

I cant even check solution without premium. Checking solution requires premium. Are you for real guys? If I cant check solution why am i wasting my time.

[teddy]

this coding format is so hard to read, don't just some how indent the line as you feel like it, looks terrible guys