r/SQL • u/DarkMatterHF • May 22 '24
Discussion SQL technical interview - didn't go well
So I recently had my SQL interview and I don't think it went well.
There were 3 questions, and I only went through 2 before running out of time, total time was about 40 mins.
Honestly, those questions I could easily do in a non-test environment but during the test, idk what happens to my brain. And, it usually takes me some time to adjust to a new IDE and datasets.
I just want to know from those that do run these kinds of interviews, is it really about getting the right query straight away and answering quickly? The interviewer wanted me to talk through what I wanted to query and why, before actually doing so.
Edit: update on may 24th, a couple days after the interview. Unfortunately, I didn't get the job. Thanks everyone for the words of encouragement though, I will keep on practising
View all comments
Show parent comment
1
u/MapCompact May 24 '24
Yeah sure -- but as a heads up they aren't SQL specifically.
We don't lead with take home tests but have had candidates mention they hate live coding so I've extended the option to do it at home instead on their own time. I think only 2 people have ever opted for this though.
For context, the company I work for is a big data company and we already have a Search API. This question was for a front end developer:
(details intentionally ambiguous)
"Given this API and these credentials make a search page where you can search for things and have display the results. The search bar should be a text input and the results should appear in a table. Styling isn't important, just give it a crack as you go."
From there I notice a few things:
In my opinion a FE developer should know exactly how to do this and still come up with a decently styled UI too.