I have 10+ years of experience in SAS. I can do almost anything an analytics professional might want to do in SAS. Trying to Get back into the market every after kids growing up and employer asks LC type questions which I cannot answer or take more than average time. Can someone please advise what should I be doing ? Is it normal to fail after 10+ years of experience? Please advise. Constructive feedback is highly appreciated.
Practice, practice and more practice. Its natural after such a break
Be kind to yourself. Starting to crack LC is not easy for anyone. Be persistent with daily practice. You will start seeing results in 2-3 months.
What was the question?
Simple windows function questions.
Where have you had these SQL interviews? Perhaps we can gauge difficulty from our experiences based on the company
Find a dataset that you can easily work with and see the data clearly (make it idiot proof). Practice a variety of manipulations. Proceed to leetcode or other platforms Or pay for Dataquest or some other course
Try StrataScratch. It's like leetcode for SQL. Costs about $30/month but I found it really helpful.
I've found hackerrank FAR nicer than LC to practice SQL. I think that the interface is way easier to navigate and the questions are also better designed for learning. I would start there and move to LC afterwards. FWIW I passed the analytics parts of Meta interviews without touching SQL, as they said that dplyr / pandas were also ok for research data scientist positions. Now I'm using SQL daily though ;)
Pets
Yesterday
890
Cat killed bird
Work Visa
8h
1850
How the f*ck did 450k c*nts apply for H-1B after so many layoffs?
World Conflicts
Yesterday
687
American police seem to work only when Israel is challenged
Tech Industry
12h
2690
Asians - what are your thoughts on asian female white male ?
World Conflicts
Yesterday
1107
I am Columbia alumni
Practice more. Read other people's solutions. Star mark questions you can't solve and do phased revision. Do mock interviews.