Hey, I am digging your videos! I love the focus on particular companies SQL questions.
@stratascratch
3 жыл бұрын
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
3 жыл бұрын
@@stratascratch Awesome!
@chaos8514
2 жыл бұрын
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
@gotchihaeyo1825
Жыл бұрын
Can I use (Select User_ID, MIN( session_start) From twitch Where session_type = ' viewer ') As a sub query instead of rank( )????
Ай бұрын
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
@ahyoungkim8256
3 жыл бұрын
hope that i can get any technical interview test soon so that i can apply what i learn from you :)
@stratascratch
3 жыл бұрын
I think this video will certainly help! Good luck
@Innovade
3 жыл бұрын
Nate, thank you for these videos. Extremely helpful.
@its_me7363
3 жыл бұрын
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
3 жыл бұрын
Yup! That's coming out soon. It's taking a while to create it ... sorry!
@monagulapa3022
3 жыл бұрын
I shared your youtube channel on my Facebook. Your tutorials are great! Will share it also on my Linkedin.
@stratascratch
3 жыл бұрын
Thanks so much! Hope your network enjoys the videos on this channel.
@christiankuntz2150
Жыл бұрын
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
Жыл бұрын
Yes it would work but rank() is more appropriate and more explicit.
@djjiang3718
Жыл бұрын
Thank you Nate! And love your content and love your web site!
@stratascratch
Жыл бұрын
Glad you enjoy it!
@iitian2012
3 жыл бұрын
You are awsome sir....Keep posting such a great sql videos....
@curio_cureator
2 жыл бұрын
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
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.
@PATRICKCHUAD
3 жыл бұрын
Thanks Nate! As always very clear explanation.
@stratascratch
3 жыл бұрын
Thanks! Always appreciate your comments on my videos!
@prashanthigupta
2 жыл бұрын
Thank you so much for your videos. I learned a lot 👍🏻👍🏻👍🏻
@InYourHorror
3 жыл бұрын
Thanks for putting out all of this great content.
@stratascratch
3 жыл бұрын
Thanks for watching the videos! More to come
@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
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.
@yuthpatirathi2719
2 жыл бұрын
Thank you Nate
@BirSozben
2 жыл бұрын
Thank you!
@kapuriaritik
3 жыл бұрын
Great video!
@stratascratch
3 жыл бұрын
Thanks for watching!
@rakibraihan1572
3 жыл бұрын
thanks
@lizard_sinno
3 жыл бұрын
Great!
@stratascratch
3 жыл бұрын
Thanks man =)
@SuperLOLABC
3 жыл бұрын
Will there be a collection of SQL and Python questions asked in PayPal?
@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!
@anuragsingh4766
3 жыл бұрын
👌👌👍
@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
Жыл бұрын
Why not just run the code and manually check the output?
@ozan4702
Жыл бұрын
@@stratascratch That wont check for edge cases.
@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
2 жыл бұрын
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?
Пікірлер: 44