Tip 1 : Must go for interviews questions present online for topics you have mentioned.
Tip 2 : Be updated with the latest technology and have those concepts clear in your mind and do prepare your projects and have a clear picture of it to explain that
Tip 3 : For preparing algorithms do practice them, that is the best way and lastly you can check your knowledge by solving mcqs and quizzes of those topics to have confidence.
Tip 1 : Do not mention anything in your resume that you are not confident about. And prepare your resume well before interview.
Tip 2 : Mention your projects and technical skills and your github link to showcase your project portfolio that will have a great impression
Tip 1 : Remember the technique to solve such question.
Tip 1 : Used dictionary to find the sum of the number.
Finding the age of the employee from personal details table .
Tip 1 : do practice sql queries and joins and some clauses
Difference between primary key and candidate key
Tip 1 : do check all the differences between keys in DBMS and other concepts as well and have a clear concept of other topics as well
What is pickling?
Tip 1 : do prepare your resume and keep yourself updated according to that as questions are raised from that.
Tip 2 : If you have mentioned some latest technology then you should have basic idea about that and go through the interview questions from that topic which will really be helpful.