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

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024

ความคิดเห็น • 42

  • @SeattleDataGuy
    @SeattleDataGuy 3 ปีที่แล้ว +1

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

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว +1

      Thanks so much man! I also got your message on Mediu and emailed you. But if you don't get my email feel free to reach out at nate@stratascratch.com

    • @SeattleDataGuy
      @SeattleDataGuy 3 ปีที่แล้ว

      @@stratascratch Awesome!

  • @Innovade
    @Innovade 3 ปีที่แล้ว +1

    Nate, thank you for these videos. Extremely helpful.

  • @djjiang3718
    @djjiang3718 ปีที่แล้ว

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

  • @iitian2012
    @iitian2012 3 ปีที่แล้ว

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

  • @yuthpatirathi2719
    @yuthpatirathi2719 2 ปีที่แล้ว

    Thank you Nate

  • @InYourHorror
    @InYourHorror 3 ปีที่แล้ว

    Thanks for putting out all of this great content.

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว

      Thanks for watching the videos! More to come

  • @christiankuntz2150
    @christiankuntz2150 ปีที่แล้ว +1

    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?

    • @stratascratch
      @stratascratch  ปีที่แล้ว

      Yes it would work but rank() is more appropriate and more explicit.

  • @PATRICKCHUAD
    @PATRICKCHUAD 3 ปีที่แล้ว

    Thanks Nate! As always very clear explanation.

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว

      Thanks! Always appreciate your comments on my videos!

  • @prashanthigupta
    @prashanthigupta 2 ปีที่แล้ว

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

  • @gotchihaeyo1825
    @gotchihaeyo1825 2 ปีที่แล้ว +1

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

    •  4 หลายเดือนก่อน

      Just found out his video and for sure you can do that in a CTE, I was going. to comment it. I personally think that the solution here is an overkill and that not go that well with the person interviewing you, it shows skill, for sure, but at the cost of over complicating things

  • @its_me7363
    @its_me7363 3 ปีที่แล้ว +1

    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?

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว +1

      Yup! That's coming out soon. It's taking a while to create it ... sorry!

  • @BirSozben
    @BirSozben 2 ปีที่แล้ว

    Thank you!

  • @ahyoungkim8256
    @ahyoungkim8256 3 ปีที่แล้ว +2

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

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว

      I think this video will certainly help! Good luck

  • @curio_cureator
    @curio_cureator 2 ปีที่แล้ว +1

    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?

    • @stratascratch
      @stratascratch  2 ปีที่แล้ว +2

      You're on the right track. There's no right answer on how to process dirty data. It's more of an agreement with the interviewer. Once you both agree then start solving the question.

  • @diaconescutiberiu7535
    @diaconescutiberiu7535 2 ปีที่แล้ว

    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

    • @stratascratch
      @stratascratch  2 ปีที่แล้ว

      There isn't a video specifically that uses CTEs and temp tables to answer this question. But you can use them for sure to do so. I would go on the platform and try to solve this question using CTEs. To address your last comment, you can use subqueries, ctes, and temp tables interchangeably. It really just depends on the use case and how much data is in our tables that will dictate what you choose.

  • @chaos8514
    @chaos8514 2 ปีที่แล้ว +1

    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

  • @kapuriaritik
    @kapuriaritik 3 ปีที่แล้ว

    Great video!

  • @rakibraihan1572
    @rakibraihan1572 3 ปีที่แล้ว

    thanks

  • @SuperLOLABC
    @SuperLOLABC 3 ปีที่แล้ว

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

    • @stratascratch
      @stratascratch  3 ปีที่แล้ว

      I haven't found any so far but I do continue to look out for Paypal interview questions. They'll definitely be on the monthly releases if I find any. Thanks for following!

  • @lizard_sinno
    @lizard_sinno 3 ปีที่แล้ว

    Great!

  • @anuragsingh4766
    @anuragsingh4766 3 ปีที่แล้ว +1

    👌👌👍

  • @ozan4702
    @ozan4702 ปีที่แล้ว

    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.

    • @stratascratch
      @stratascratch  ปีที่แล้ว

      Why not just run the code and manually check the output?

    • @ozan4702
      @ozan4702 ปีที่แล้ว

      @@stratascratch That wont check for edge cases.

  • @teddy911
    @teddy911 2 ปีที่แล้ว

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

    • @stratascratch
      @stratascratch  2 ปีที่แล้ว +1

      We typically put 4 spaces for indentations. This code was actually copied from a site that helps format code. It looks like code I've seen in industry and follows best practices. Although, I see 1-2 lines that have too much spacing, all the other lines look okay to me. Maybe there's just too many nested parts that could be refactored into CTEs?