Why Business Analysts need skills in SQL and Relational Database Technology

By Carl Herron, Business Analysis Expert and Instructor

In
order to be effective, Business Analysts need skills in SQL and relational
database technology.  Mind you, BAs are
not required have advanced level skills in SQL or stand in as data modelers or database
administrators.  As a BA, the majority of
your SQL will use the SELECT command. 
And if you build a database, it will typically be simple with no more
than ten to twenty tables.

Fundamental
relational database and SQL skills are foundational for Business Analysts for
several reasons:

1.     
The systems your
team will be developing will most likely use relational database technology.

 2.     
As more mature
organizations will have data dictionaries and entity relationship diagrams
documenting their data, reading these and similar documents will accelerate
your understanding.

 3.     
You will benefit
from querying databases or database extracts as part of your analysis of the
current and future systems.

 4.     
SQL skills can
help you query the new system during the testing phase.

 5.     
If your organization
uses automated systems for activities like requirements management and testing,
SQL will help you analyze the data in these systems.

6.     
During the
project, you can build small databases to support prototyping, analysis, data
management and reporting.

7.     
Many of today’s mission
critical systems have requirements for Business Intelligence.  Understanding the flow of data from
applications into data warehouses and analytical products requires knowledge of
SQL and relational databases.

Completing
these tutorials on the
www.internet.com site will give you a view of the minimum you should know.

Introduction to SQL Tutorial: 

http://sqlcourse.com/intro.html

Intermediate/Advanced SQL Tutorial: 

http://sqlcourse2.com/intro2.html

 

 

 

About these ads
This entry was posted in Computers and Internet. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s