Hi, I have a coding interview coming up for a tech firm in san fran with karat conducting the coding portion of the interview. The question itself will be based on the following: Expect a short section of SQL Knowledge questions. In terms of the question you'll be asked during the coding portion of your interview, you'll be asked an algorithmic coding question. You will be using our coding environment and you can choose the language of your choice. Could anyone shed some light on possible questions that would help me prepare for this? Thank you
Google sample questions. You should know depth first and breadth first search, when to use a stack vs. a queue, and be able to move multiple pointers at the same time. Be able to talk about the time space of your code and dont be afraid to ask clarifying questions if allowed. Its generally about seeing how you think and reason, and not always about getting the best answer. If it's a white boarding question, always a good idea to bring your own markers, but this sounds like you get to use an ide, which I've always found much easier.
You could have answered your question yourself with the search bar in a fraction of the time it took for you to write your post. You won't make it in tech if you can't use search tools effectively so I'd suggest you work on that first instead of asking to be spoonfed interview questions.
Sort of a dick response! If you think you are helping? You really are causing more damage to his ego than showing the errors in his way helps him. Food for thought!
@Facebook : you could have ignored OP’s question instated of posting such a dick response . You wont make it in life if you cant help/ respect people. I’d suggest you work on that first instead of giving your useless egoistic opinion
Also, yeah, know sql basics...its not that hard. Make sure you understand execution plans, and how they are calculated, basic joints, subqueries, and dot vs. Cartesian products. Have basic plsql (or whatever for the particular database) knowledge and obvio6be familiar with connecting from your code...bind variables, hibernate, etc.
I was asked 2 SQL join questions. Know your joins that should be enough
Thanks ronney. Any input on the exact question as well as level of difficulty? Also any other advice would be really appreciated regarding your own interview experience.
I'd say 1 was easy and the other was medium. I'd suggest to practice few LC DB (Easy and medium) questions. You should be good
I have no experience with Karat..but lately I have started preparation..i would suggest get comfortable with subqueries, multiple joins , window function in sql