Thanks for all the hard work you put into your vids Tim! I finally landed a full time job, but it’s not related to data analytics at all :/. I’m still practicing my skills and applying everyday though and this video helped a lot. Keep it up! Hopefully we both land a role we want soon 🙏🏼🙏🏼
OOO YAYAY! congratulations so happy for you!! i’m so glad it helped a little bit at least :’) i know we’ll both be able to land that data job soon!! woohoo!!
Thanks for sharing your experience. In the Q3 query for Cancellation rate : count(T.status != 'completed') would count all the non-null values and would include both True and False rows. A case statement inside count would give accurate answer.
Thanks for this great explanation about the SQL questions! I will have an technical interview tomorrow. Your video gave me an ideas how tricky they can ask in the interview. Super useful! Thanks again 🙏
Great video. Took me a minute to get the point of the Driver question with the two separate joins. I'm assuming that role is either a mid or senior level, not entry level. I do dislike when questions seem to be irrelevant to real life. Does anyone really write department salary queries on the job? Isn't that like something HR would be doing? I'm still trying to wrap my head around how many queries you actually write on a daily basis and how complex they get. The job market for entry level still learning data analysts feels non-existent. You're very inspiring, and super helpful educating us.
these were all entry level questions (1-2 years of experience) which sort of blew my mind 😭 yeah no one is really writing department salary queries LOL but its just to test and see if you know things like GROUP BY / Ranking Functions for number of queries it depends... usually the goal is just to pull data in the most efficient way possible so maybe like 1-2 complex ones thank you for the kinds words! I always appreciate your support! :D
Hi Tim! Thanks for this amazing video! Really gave me some more insight. I have a Live SQL interview coming up for Amazon's BI Engineering role but its an Internship. Would you say that these kinds of questions would also be used for the internship roles?
Hi Tim, Great content! 🔥 May I ask are these recent interview questions? and may I know how many years of experience was being asked for this opportunity? Thanks man and keep up the good work!
Hey thanks so much for the video. Do you currently work at Amazon? Have you interviewed multiple times? Were you already employed there and had to do another interview for a different job? I'm just wondering how you've tested multiple times. Thanks again!
sadly not working at amazon at the moment! I was interviewed multiple times just throughout the past year or so! Some through applying, others with recruiters reaching out, most with contract roles! overall just a wide variety
Should I drop out of cs? I'm only one semester in and can easily switch to something else. I was thinking healthcare since there is low competition , high demand, no outsourcing possibilities, and hard for ai to replace
i wouldnt worry too much about AI replacing tbh, thats far from actually happening and not entirely realistic either! I wouldnt drop CS, thats a great major and devs are always gonna be needed
@@TimothyJoo Thanks. I think I will be doing ee major + cs minor. Since there is overlap in skills and courses. This will also open more doors, and the ee is less likely to be outsourced. I can also move back into tech if I want to in the future. What are your thoughts?
Yo these are so clutch for future interviews! Thanks for sharing bro
thank you for always supporting bro, you da best 🫶🏼
Thanks for all the hard work you put into your vids Tim! I finally landed a full time job, but it’s not related to data analytics at all :/. I’m still practicing my skills and applying everyday though and this video helped a lot. Keep it up! Hopefully we both land a role we want soon 🙏🏼🙏🏼
OOO YAYAY! congratulations so happy for you!!
i’m so glad it helped a little bit at least :’) i know we’ll both be able to land that data job soon!! woohoo!!
Thanks for sharing your experience.
In the Q3 query for Cancellation rate : count(T.status != 'completed') would count all the non-null values and would include both True and False rows. A case statement inside count would give accurate answer.
ooooo wait that’s right and good to know! thank you for sharing that with me! i learned something new 😌
Thanks for this great explanation about the SQL questions! I will have an technical interview tomorrow. Your video gave me an ideas how tricky they can ask in the interview. Super useful! Thanks again 🙏
awww YAY im glad i could help 🥹 i hope you aced it and landed your next role!
Great video. Took me a minute to get the point of the Driver question with the two separate joins. I'm assuming that role is either a mid or senior level, not entry level. I do dislike when questions seem to be irrelevant to real life.
Does anyone really write department salary queries on the job? Isn't that like something HR would be doing?
I'm still trying to wrap my head around how many queries you actually write on a daily basis and how complex they get. The job market for entry level still learning data analysts feels non-existent.
You're very inspiring, and super helpful educating us.
these were all entry level questions (1-2 years of experience) which sort of blew my mind 😭
yeah no one is really writing department salary queries LOL but its just to test and see if you know things like GROUP BY / Ranking Functions
for number of queries it depends... usually the goal is just to pull data in the most efficient way possible so maybe like 1-2 complex ones
thank you for the kinds words! I always appreciate your support! :D
Hi Tim! Thanks for this amazing video! Really gave me some more insight. I have a Live SQL interview coming up for Amazon's BI Engineering role but its an Internship. Would you say that these kinds of questions would also be used for the internship roles?
yes! they use the same question pool so they should be synonymous!
Hi Tim,
Great content! 🔥
May I ask are these recent interview questions? and may I know how many years of experience was being asked for this opportunity?
Thanks man and keep up the good work!
awww thank you so much! they were in this last year and for roles ranging from 1-4 years of experience!
Hey thanks so much for the video. Do you currently work at Amazon? Have you interviewed multiple times? Were you already employed there and had to do another interview for a different job? I'm just wondering how you've tested multiple times. Thanks again!
sadly not working at amazon at the moment! I was interviewed multiple times just throughout the past year or so! Some through applying, others with recruiters reaching out, most with contract roles! overall just a wide variety
Should I drop out of cs? I'm only one semester in and can easily switch to something else. I was thinking healthcare since there is low competition , high demand, no outsourcing possibilities, and hard for ai to replace
i wouldnt worry too much about AI replacing tbh, thats far from actually happening and not entirely realistic either! I wouldnt drop CS, thats a great major and devs are always gonna be needed
@@TimothyJoo Thanks. I think I will be doing ee major + cs minor. Since there is overlap in skills and courses. This will also open more doors, and the ee is less likely to be outsourced. I can also move back into tech if I want to in the future. What are your thoughts?
@@ripsky7586 that sounds like an amazing idea!! both are really important and powerful skill sets that companies would def love to have!! great idea