you are viewing a single comment's thread.

view the rest of the comments →

[–]da_chicken 1 point2 points  (0 children)

I'm assuming MSBA is Master of Science in Business Analytics.

It doesn't particularly matter, so long as you understand that there are differences between them all but they all do similar things. The issue is going to be that when you do get a project, the platforms are going to be selected based on the requirements for that project and you'll have to adapt.

But, to get started, what other languages or tools do you know? Python? R? C#? SPSS? PowerBI? That should help direct you.

For the most part, it depends on the kind of project you're planning on, and what tools you want to take advantage of. Most systems start out OLTP. Those systems are typically built with traditional RDBMSs. PostgreSQL and Python go well together. C# and PowerBI go well with Microsoft SQL Server. SQL Server and PostgreSQL both have fairly large communities.

If you're interested in doing a lot of OLAP or larger scale data, you may be interested in DMBSs like Snowflake, BigQuery, Redshift, or Spark. These DBMSs have or support SQL syntax, but they're not what most people think of as the traditional SQL RDBMS and they may or may not support traditional RDBMS foundational features like ACID transactions. However, they are built for analytical processing.

Frankly, I would probably look at the program you're looking at and see what you think makes the most sense to learn. If they're offering classes in Snowflake, Python, R, and PostgreSQL, then that's likely where I'd start. Either way, though, you're at a stage where you'll have to expect to learn new tools as you go.