What is your experience using SQL queries, and can you discuss the different parts of an SQL Statement?
This is a technical question that seeks to understand your knowledge of SQL. As an IT business analyst, you don't need to have advanced technical skills, but it helps if you have skills in SQL and relational database technology. Technical questions like this are best answered directly and succinctly. The interviewer will ask follow up questions if they need additional information.
"I have a great deal of experience using SQL and making queries to locate the information I need for the project I am working on. An SQL statement is made up of three parts. There is the Data Definition Language (DDL,) the Data Manipulation Language (DML,) and the Data Control Language ( DCL.) Using these properly results in the appropriate data set."
Community answers are written by other candidates practicing this set. Reading how others frame the same question is one of the fastest ways to sharpen your own.
Anonymous Answer
I'm gonna be honest while I have been taught SQL in the past and while I do understand the basics this is not something I use on a daily basis in my current role, however, I am sure I can pick up SQL again if it is something needed for this role.
Marcie's Feedback
Prior to the interview, consider brushing up on the various parts of SQL statements so you can discuss this if needed. You can then be honest and state that you don't typically use SQL within your current role but that you're familiar with it and confident that you'd quickly pick it up again if needed.
