Forums for the Business Analyst

  Modern Analyst Forums  Careers  Getting Started  how much sql is needed for business analyst?
Previous Previous
Next Next
New Post 7/30/2014 4:10 PM
User is offline mrdlau
1 posts
No Ranking

how much sql is needed for business analyst? 

I'm looking in to the business and data analyst role, and looking at job requirements, a lot of them require sql or sas proficiency .  The good thing is that I actually got a call on a few postings, but after they told me that there will be an sql exam, I had to back down.  I'm learning SQL on my own at the moment;  so I"m wondering, what type of knowledge I need to know.  Right now, i'm just going over w3schools sql website going over all the different functions.  Is that enough to be considered' sql proficient'?  Am I expected to memorize all the functions?  

I'm just trying to figure out if I am "learning" the right way., and what is the best way to prepare myself

New Post 8/4/2014 11:18 PM
Online now... Adrian M.
755 posts
3rd Level Poster

Re: how much sql is needed for business analyst? 

The best thing to do is to ask what types of questions they might ask and what level of SQL proficiency they are looking for.  It would be better than simply backing down on the given position.  Might actually be OK to say, "Look - I might not get this job but can you do me a favor and give me an idea of what type of SQL skill-set you are looking for?"

You can always call them later and tell them that you're ready!  The position might still be open and you might even get hired.

I'm not claiming that this will answer your question but you might be interested in this:

SQL for the Business Analyst - How to be an expert without knowing how to code



Adrian Marchis
Business Analyst Community Blog - Post your thoughts!
New Post 2/11/2015 6:33 AM
User is offline vlookup
39 posts
9th Level Poster

Re: how much sql is needed for business analyst? 

At the OP


In my situation it requires a heavy amount.  I honestly feel I could move into a SQL development position I write so much.  Not saying I would be a rock star, but I could snap in and within 6 month be an average contributing member.  In others from what I have seen a lot.  

But I am not a pure functional.  

Previous Previous
Next Next
  Modern Analyst Forums  Careers  Getting Started  how much sql is needed for business analyst?

Community Blog - Latest Posts

A business analysis checklist helps you stay organized while you work through projects. It includes questions that will help you identify problems in your current processes, and suggest improvements for future projects. Understand the Problem Before you start writing code, you need to understand what problem you're solving. This means u...
I’ve heard “The End is Near!” for Business Analysts for almost 20 years.  Waterfall project management, with its need for formal requirements, is dead…a dinosaur…so 1990’s.  To be honest, that’s mostly true.  With the publishing of the Agile Manifesto in 2001 there was no need for a 2-inch-...
Business analysis is used to identify and articulate the need for change in how organizations work, and to facilitate that change. As business analysts, we identify and define the solutions that will maximize the value delivered by an organization to its stakeholders. We look for opportunities for new business models and new ways to work together. ...



Copyright 2006-2022 by Modern Analyst Media LLC