Tip 1 : Have Patience
Tip 2 : Make your fundamentals strong
Tip 3 : Practice varieties of problems as much as you can.
Tip 4 : Participate in various contests
Tip 1 : Have Couple of Projects
Tip 2 : Be confident about your project
Tip 3 : Highlight the tech stack used in your project.
Tip 4 : Keep your Resume classic and simple
It happened during the day time. Interviewer was very helpful and kind. He started the interview with his introduction and then he asked me to give mine. Then he quickly switched to projects. He asked basic questions regarding the project that I had mentioned in my resume. After that he shifted to core fundamentals. Asked questions on OOPS, Operating System, DBMS and then he gave me a SQL query to write. In the end he gave me a problem to solve ( Longest Palindromic Substring -Leetcode Hard). I was able to solve this problem. I answered around 80-85% of the questions that he asked about fundamentals. I was thinking out loud so he was very kind to help me in between.


str = "ababc"
The longest palindromic substring of "ababc" is "aba", since "aba" is a palindrome and it is the longest substring of length 3 which is a palindrome.
There is another palindromic substring of length 3 is "bab". Since starting index of "aba" is less than "bab", so "aba" is the answer.
Fetch Nth Highest Salary
SELECT DISTINCT( salary )
FROM employees Emp1
WHERE N = (SELECT Count(DISTINCT ( Emp2.salary ))
FROM employees Emp2
WHERE Emp2.salary >= Emp1.salary);
It happened during the day time. Interviewers were very helpful and kind. They started the interview with their introduction and then asked me to give mine. Then one of them quickly switched to projects. She asked basic questions regarding the project that I had mentioned in my resume. After that she shifted to core fundamentals. Asked questions on OOPS, Operating System, DBMS. Focus was more on DBMS this time. Then the other interviewer started asking about cybersecurity related questions. I was able to answer most of them and i was clarifying all the doubts instantly that was coming in my mind.
Explain different types of joins.
> INNER JOIN
> LEFT JOIN
> RIGHT JOIN
> FULL JOIN
What is Normalization? Explain its advantages.
The Four Pillars of Object-Oriented Programming.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
How do you remove whitespace from the start of a string?