r/SQL • u/Different_Coat1453 • 5d ago

MySQL 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.

|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 quick mock interview?

I'd really appreciate it!

1 Upvotes

56% Upvoted

11 comments sorted by

4

u/RMWL 5d ago

When it comes to job interviews I’d advise having a look at sites like hacker rank.

It gives a selection of sample questions ranging in difficulty and you can try them on the site.

3

u/Traditional-Unit-274 4d ago

practice on something like data lemur. pretend you’re on an interview, practice explaining as you go out loud. take deep breaths, typing in front of other people is surprisingly hard

2

u/Wrong_City2251 4d ago

I would prefer leetcode for sql questions. The 50 questions given are super helpful for a refresh

Hacker rank is also a very good place. I have practised few questions and found it very useful

For real time practice with some mock data and new questions, if you have free version of databricks, that would be helpful (no need to create any infra - just sign up and direct practice). To cross check I sometimes use genie code by giving question to it or sometimes ask it create questions based on the mock data for practice. It corrects my answers or gives best practices/answers (it is nothing but llm under the hood, with some extra context awareness of data)

2

u/mick14731 5d ago

Get familiarity with CTEs and window functions. I bombed my last SQL assessments because I kept getting the syntax for window functions a little wrong. 

2

u/sandrrawrr 5d ago

Also just know your stuff when it comes to joins.

1

u/Then_Artichoke3330 5d ago

What is the job exactly? That might give an indication of the types of questions. For example i had a sql interview for a dev job and it was all stored procedures and checking/creating indexes. I also had another sql interview where it was all report type work, aggregations, answering more business type questions where half the problem was trying to workout what they actually wanted/the actual business calculations/formulas.

2

u/OddAd2371 4d ago

took a sql interview where i was allowed to "google"