This may be more of a vent than a question so apologies in advance.
I recently had an online assessment with a company that I was excited to interview for. The assessment was comprised of 7 SQL questions each with varying amounts of time to complete them. The questions were more than fair however I completely choked and only passed 1 of 7.
I know the obvious answer is more practice but I'm really frustrated that the penalty is really high if you can't recall the information you need at that exact moment or can't figure out the approach you need right then and there to resolve it before the allotted time. I feel like companies never consider that a candidate might very well have the body of knowledge they're looking for but just couldn't recall what was needed at that exact moment. In other words we're reduced down to a simple "pass/fail". I understand that companies have to use these tools to a certain extent in order to filter out and reduce the candidate pool size but I believe it's such a poor filter and terrible way to determine if someone has the right level they're looking for.
My question is then, how do you over come this? I practice leetcode when I can and read up on concepts that I struggle with but I feel like it's just not enough to break through this hurdle. There's only so much time in the day and my energy is usually sapped after work.
Thanks so much for the detailed reply/advice. I definitely need to have a change of perspective especially in this economy.
Just want to say that you're not alone. I totally relate to how you feel
Software engineering is not memorization, regardless that, sometimes in the interviews you are expected to remember syntax or stuff like that.
Following the Alex's advice: Make a list of the companies that you really are excited to join and the ones that are like "meh".
Get experience first with the "meh" companies.
From my personal experience: Take the interviews as a free skill evaluation from a company where you will learn more about yourself and challenges that you are not used to in your daily life. The job offer is like the bonus price.
The attitude is elemental, feeling frustrated is fine, is part of the process, we all need a vent sometimes, is nice that you have a support community
Keep building your resilience and skills, if you persist and keep learning on each "battle", is a matter of time that you will win the "bonus" price uwu