4. Describe your familiarity with SQL queries.
Though it is not necessary for a business analyst to demonstrate advanced technical skills, certain skills are incredibly valuable. You may be asked to explain the elements of a SQL Statement during an interview so employers can assess your related technical skills and advanced analysis skills. In addition to providing definitions that demonstrate your knowledge, you might also consider providing an example of how you have used SQL to make an impact in your previous BA work.
There are four parts to an SQL statement. The DDL, or the Data Definition Language, is used for defining data structure. The DML, or Data Manipulation Language, is used for inserting, deleting and modifying data. The DCL, or Data Control Language, is used to control access to data stored in the database. Finally, the TCL, or Transactional Control Language, is used to organize data adjusted by the DML. I have used SQL statements to determine which of my client's customers are purchasing which products, which has helped them make important decisions about future product lines. This work has made them a repeat customer three years running
Do'stlaringiz bilan baham: |