Tip 1: Maintain consistency in DSA.
Tip 2: Master development skills.
Tip 3: Gain strong theoretical knowledge.
Tip 1: Include relevant projects and internship experience, along with a description of your role in those particular projects or internships.
Tip 2: Highlight relevant technical skills and problem-solving abilities.
Three SQL-related queries and two DSA questions.
I used the Sliding Window technique and a HashMap to solve this.
Write an SQL query to find the third-largest salary in a company.
Tip 1: Use a subquery.
Tip 2: Use it three times to find the third-largest salary.
Tip 3: You can also use LIMIT and OFFSET.
Write an SQL query to retrieve common records from two tables.
Tip 1: Clearly understand the problem.
Tip 2: Use intersection to solve it.
Tip 3: If you know about intersection, it can be completed in 2 minutes. Otherwise, it may take a bit longer to think through.
This was the interview round where the first 5 minutes were focused on my introduction. Then, the interviewer evaluated my problem-solving skills by giving me one dynamic programming (DP) question. I initially applied recursion, then moved on to memoization, and finally to tabulation, as that was what the interviewer expected from me.
‘N’ = 3, ‘coins’ = {1, 2, 3}, ‘freq’ = {1, 1, 3}, ‘V’ = 6
For the given example, we can make six by using the following coins:
{1, 2, 3}
{3. 3}
Hence, the answer is 2.
Tip 1: Apply recursion.
Tip 2: Use memoization.
Tip 3: Implement tabulation to make it more optimal.
Standard background and communication check
Tip 1: Talked about my experience as a Backend Intern.
Tip 2: Described my role and the impactful work I accomplished there.
Tip 3: Answered all the questions calmly and confidently.
How soon can I join?
Tip 1: I was in my 7th semester, so going to the office regularly was difficult for me because of my strict attendance rules.
Tip 2: However, since there were some great teachers and I had a good reputation among them, I could take leaves and continue my internship.
Tip 3: I said, "Yes, I am available for an on-site internship."
Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
Which SQL keyword removes duplicate records from a result set?