SQL Interviews Be Like
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- SQL Interviews are always tricky.
There is always a better way to write a query and if you haven't spent time studying it can really bite you.
If you're looking to study for your SQL and data science interviews, then check out StrataScratch:
stratascratch....
A special thanks to StrataScratch for sponsoring this video!
StrataScratch is a data science interview platform that has over 1000+ real interview questions from top companies such as Meta, Google, Amazon, Twitch, AirBnB. New interview questions are released every month and cover SQL and python coding, statistics, probability, modeling, product sense, and system design.
If you enjoyed this video, check out some of my other top videos.
Top Courses To Become A Data Engineer In 2022
• Top Courses To Become ...
What Is The Modern Data Stack - Intro To Data Infrastructure Part 1
• What Is The Modern Dat...
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
seattledataguy...
Or check out my blog
www.theseattle...
And if you want to support the channel, then you can become a paid member of my newsletter
seattledataguy...
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: / @seattledataguy
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.
Check out Stratascratch for data science interview prep with real interview questions: stratascratch.com/?via=sdg
Honestly I grinded questions on SS for like 3 months and it improved my SQL immensely. So much so that I can confidently say it helped me land a senior analyst role recently. Their YT content is also A+
That's great to hear. Also totally agree about their YT channel. If you're just looking to check your SQL knowledge its a great first place to start.
SS means StrataScratch??
@@balajivenkatraman2991 yep
2:30 the windows shutdown sound 😂🤣😂
I was struggling with how to transition. Honestly this entire video was based off one scene from adaption with nick cage...
@@SeattleDataGuy Ha! Love me some Nick Cage!
@@LukeBarousse The BEEEESSSS
This is nothing but the FACTS! 😂
Glad it resonated!
This is so funny 🤣. And some good editing as well. Keep it going 🤣🤣🤣
Thanks! I will get back to the regularly scheduled programming. But I thought this would be fun.
does he get his coffee and muffin is all i want to know
He looked fat when I shot it
Whew am i intimidated by technical interviews! I know SQL ought to be the strongest skill for almost all data engineer roles, I got fairly decent at it by the end of last year, but the past few months my courses have focused on Python, Bash/Shell, and interacting with various databases' CLIs, so I'm hoping I havent lost too much by the time I can get back around to it haha
Don't worry! SQL is like riding a bike.
@@SeattleDataGuy it does feel like that at times!
Just make sure to practice a little bit every once and a while
@@SeattleDataGuy for sure, the IBM Data Engineering courses always involve SQL when working with databases in almost every course
Oh damn, that IS ME!
Did I leave my camera turned on? I couldn't wait till the end of the video to comment this!
It is me, talking to myself, trying to write something on a board, telling myself the steps and saying "oh, wait, why is it wrong?" hahaha!!
What an actor, Ben.
De Niro is scared!
Haha! Glad you enjoyed the video. I was trying to really feel all the emotions I have felt doing interviews myself.
Hahaha😁 I had an experience during an interview couple of years back. 10 sql questions, I had to first write the logic/query on paper and then run it, no change in logic allowed when quering in db , in my head all 10 were correct, but when I wrote the query only 7 gave expected result🥲 During development we often start at one place and then change things based on how results are coming! Having the exact logic on paper first was difficult!
Yeah I might just walk out if that happened haha. When I gave interviews I encouraged people to query as much as they wanted. If you get all the answers in 30 minutes, I don't care how many times you had to rewrite your query.
Lol, giving me hope! I thought I was the only one!
You're not alone!
45 Mins are u sure about that :D
It takes way more :D
Yeah...it took me three hours to solve two sum
Hahahahahahah
I was looking at 75 blind leetcode problems and the first on was 2 Sum :D
@@hamsansari2111 Its always two sum
Who are you and how are you spying on me?
I probably interviewed you.
I thought I was the only one😂😂
We all feel the pain!
One query always the same question we need to decipher "how can do the same but only in one query ?" 😄😄😄
Either...can you do that in one query...or can you do that without a window function.
hilarious 😂😂
Glad you enjoyed the video!
uhhhhh... is there a hidden camera in my home office? WHY ARE YOU MAKING A VIDEO ABOUT MY LIFE?!
I just recalled my experiences hahaa
Too much reverberation in the audio, makes hard to understand :( no native English speaker here
Yeah, I tried filming with a mic too. but I need a better mic as it didn't capture most of my audio well.
"SDG" 😂 great company name Ben 💪
Not as cool as blindr
@@SeattleDataGuy that Joma reference! 😂
You guys should totally have collab!
Maybe like a data engineer vs. data scientist rap battle? 😂
That would be iconic.
That would be awesome! But I imagine he is aiming to collab with people in the million sub range. Feel free to help share some of my videos and try to help me get close! But we have a long way to go. 😅😀
@@SeattleDataGuy your channel is so underrated 😭 I recently got a new job last month in data engineering and you've been so helpful in mentally preparing me on what to expect, w.r.t the technologies and just the work in general, I hope your channel grows real fast, you totally deserve it 😭
@Vidya Ratan You're too kind! I will continue to put out as much content as I can.
This sounds like AWS😋
Like AWS interviews?
@@SeattleDataGuy 100%. You be doing interview rounds with half the company on your interview day
Thats So TRUE !😂
I tried to remember my pain
lol
😆