Why Business Analysts need skills in SQL and Relational Database Technology

By Carl Herron, Business Analysis Expert and Instructor

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.

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

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

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

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

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

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

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

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.

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

Introduction to SQL Tutorial: 


Intermediate/Advanced SQL Tutorial: 





About sansatechnology

Sansa Technology is an IT staffing, Consulting and Training company located in the heart of Silicon Valley. If you are a consultant looking for your new gig, send us your resume to us. If you are looking for training in the field of White Box Testing, Java, Java EE, Selenium, DevOps, Android and others, connect with us as well. Visit us at www.sansatechnology.com or email contact@sansatechnology.com
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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s