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
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
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.
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: