When interviewing a candidate for a business analyst role, employers are looking to assess your analytical problem-solving skills as well as your communication and collaboration skills. Be prepared to analyze a business case study and answer behavioral questions that often test your ability to handle challenging stakeholders or tight deadlines. Business analysts must also be creative thinkers, so expect to tackle a few unusual brainteasers that are designed to see how well you can think through a complex problem.
SQL questions. I have very little experience and didn't know SQL as well as they probably would like. If you have X table and Y table how would you join them? Is this an inner or outer join?
That depends. You have to pay attention to the data and how it's setup. The joining it completely based on the Primary and Foreign Keys.
Actually, the keys have very little to do with the choice between an inner and outer join. It depends more on what results you want returned. Inner joins only return data for rows that match the select criteria, outer joins return those AND rows that don't match.