Database and other sql queries , it was very comfortable because of interviewer. He was very nice person and made comfortable. What are tables and Fields? What is a join? What are the types of join and explain each? There are various types of join which can be used to retrieve data and it depends on the relationship between tables. Inner join. Inner join return rows when there is at least one match of rows between the tables. Right Join. Right join return rows which are common between the tables and all rows of Right hand side table. Simply, it returns all the rows from the right hand side table even though there are no matches in the left hand side table. Left Join. Left join return rows which are common between the tables and all rows of Left hand side table. Simply, it returns all the rows from Left hand side table even though there are no matches in the Right hand side table. Full Join. Full join return rows when there are matching rows in any one of the tables. This means, it returns all the rows from the left hand side table and all the rows from the right hand side table.

First interview with the team and HR - some soft skills questions and some tech questions (what happens when you click a button). Next stage - home test, real-life scenario task for 1 hour. Too heavy, diverse and controversial for one hour - not something that actually happens in real -life, "You got a request to expand an existing exam taking website to the new region. It also will need to include new functionality (bla bla bla - business details why) 1. Write questions for the stakeholders workshop covering all possible questions, 2. Write Epics and detailed User Stories". It's not difficult, it's inadequate for this amount of time.