Related Posts
More Posts
Need 11 likes for DM. TIA.
Pyr in a pool

TCS is the worst company one can be in.
Cheap mindset management cares more about timesheet,wfo,forceful mandatory trainings,imposing strict restrictions on laptop,access to personal docs only via vpn,no employee well being no salary hikes nth at all.90% projects filled with freshers coz they cost less.No WLB for good dedicated hard working employees as they are punished with more and more work, leaves rewards mostly for people who don’t work.But no issues kyunki job security hai 😂
It depends on the company, but I've had a few that required a live coding demo - basically a leetcode/hackerrank SQL challenge that I had to do for the panel interview. If you want to practice, I'd say leetcode is good for interview prep.
Oooh this is really good to know. I was wondering this myself. I didn't know they ask for live coding demos. I will def need to practice this.
If you know what specific company you'll be interviewing with, Glassdoor "interviews" usually has intel on that sort of thing. Super helpful.
Agree with the suggestions above. I can’t imagine they would ask much more than joins, group by, and maybe nested queries and partition by. Other than that, most of your data analysis should be done outside of SQL, and you should tell them that 🙂
I'll add that for my last DA role I had some questions about stored procedures. I'm not sure if this is typically for a DA though - I thought it was more on the engineering side
Best case scenario is you get a take home assignment. For the most part most sql interviews are mid level so your joins, case when, percentages, etc. The hardest question I’ve had was utilizing a row clause in a windows function.
Also something to keep in mind is that you generally won’t be able to run any of your queries since they’ll usually just give you table names & fields but no actual data in the tables.
DA1 and A1, I’ll look into those. Thanks!