Should business analyst know SQL

Should business analyst know SQL


Now a days many recruiters mention SQL as a IT skill  set for a business analyst. Why would they do that? There are many reasons on why a business analyst should know SQL and how it is helpful.

Gone are the days when many thought that SQL knowledge is a ‘desirable’ skill for a business analyst to have. But now the business analysts are ‘required’ to have a basic SQL knowledge (atleast few basic commands) to work on their daily tasks.

Companies around the world rely on their databases to keep their businesses running smoothly and efficiently. For some companies, if their database goes down, then their whole business stops. Did you know that the only way you can talk to these databases is through SQL?

Most of the applications which are developed these days use RDBMS like Microsoft SQL server. MySQL, Oracle RDB, PostgreSQL etc. Having  knowledge of SQL will help to do some basic tasks like creating a db table, dropping or deleting it, creating and modifying the query to get the data out of db tables etc

As a business analyst, you may need to work on ER diagrams which consists of all the information on the entities and relationships of the data and its flow. It will be very helpful for you to read and understand these documents when you know SQL basics.

You can get the data you want by writing a simple query without asking for any external help especially during the application testing.

Just to answer the question – Should business analyst know SQL ?

Here is a summarized answer – a business analyst doesn’t need to get trained on database administration. All he can do is to learn some simple functions to work with SQL which will help you do better in your data driven projects.

Hope this article helped. Please feel free to reach us info@bacentric.com in case you have any questions.

About Us

BACentric is a service driven company specializing in the project management, business analysis and business continuity management. We provide the forward-thinking expertise to support business with preparing and managing the right conditions needed to implement effective and sustainable change.

We conduct business analyst training in Bangalore, Hyderabad, Chennai, Pune, Mumbai and other major cities in India.


https://www.bacentric.com/should-business-analyst-know-sql/

7 views1 comment

Recent Posts

See All

( I am not the author of this article, link is provided at page bottom) Technological innovation and digital disruption are transforming the logistics and supply chain industry. Logistics involves eff

Written by Giorgos Sioutzos on August 11, 2022 Being creative may seem contradictory to an analyst structured approach to everyday tasks but this is far away from truth. Creativity is something requir

Posted by: Lucid Content Team Product owners are at the center of every development cycle. But what do they actually do? Though a product owner’s role can vary depending on the environment, they typic