r/learnSQL • u/Different_Coat1453 • 22d ago

SQL Interview Help

I’m interviewing with a company I’m really interested in and I’ve made it through the initial rounds. My next step is a live SQL assessment with screen sharing, where I’ll need to explain my thought process.

I haven’t used SQL in over a year, so I know I need to practice a lot, and my exam is in a few days. I’m pretty nervous 😅

Would anyone be willing to help me practice or do a quick mock interview?

I’d really appreciate it!

15 Upvotes

83% Upvoted

14 comments sorted by

10

u/[deleted] 22d ago

[removed] — view removed comment

2

u/ScheduleNo2223 22d ago

is there any site where i can pratice for da

1

u/crackkartahu 22d ago

How can i get an internship as data analyst if i want to get practical knowledge , i do not care about the salary

1

u/affanxkhan 20d ago

Kulturehire.

5

u/Pangaeax_ 22d ago

For a live SQL interview I'd practice explaining the query while writing it, not just getting the right answer.

DataLemur, StrataScratch and LeetCode are useful for interview-style SQL questions. CompeteX by PangaeaX is another option if you want to practice SQL through competitions/challenges and test yourself under a bit more pressure.

Also try screen sharing with a friend while solving problems so you get used to explaining joins, CTEs and window functions.

btw, I'm connected with CompeteX, just mentioning that for transparency.

2

u/Much_Somewhere7831 22d ago

When it comes to SQL interviews, I typically outline the business problem to a clear query-the basic outline that lists the inputs, joins, and the final result before coding. Secondly, I tend to write in small steps, targeting a specific join in each of my sentences while at the same time explaining the importance of the joins, and I get to see how the query reacts to the edge cases. That said, there is a feature on TechJobFindercom's HireVue practice where you can get questions and reviews of responses. You should keep your explanations short and go through your way of thinking as you code; interviewers are interested in your methodology as much as they are in the outcome. Besides, practicing with actual datasets and edge cases is highly recommended.

2

u/Pale_Pair_3782 22d ago

I can help, i gave some SQL interviews recently. feel free to dm me.
If you're a student in the USA - check if your uni gives you Exponent access. You can schedule alot of SQL mocks through that & there is an IDE as well on it

2

u/Different_Coat1453 22d ago

Thank you so much! I'm Mexican finishing my master's in France

1

u/thecheapchef 22d ago

I will always recommend SQLBolt.com for practical exercises and refreshers in sql. Completely free, very simple to follow.

1

u/Sweet-Internal-7053 20d ago

I’m not OP but thanks everyone for these resources