In what order should training be done? DBA to BI RRS feed

  • Question

  • Mainly looking for a plan of attack to learning BI while I'm currently unemployed.

    Yes, I know, took me a long time but had a lot of life snags along the way.... I currently have completed all the 4 courses for the MCDBA (SQL 2000 implementation and maintenance. still trying to pass 70-293 - windows 2003 infrastructure) and I have work experience supporting applications with SQL backends, however, I have no work experience as a production DBA and no experience creating front ends other than forms in Access.  As I have learned more throughout the years on my own, I have discovered that my dream job would be a BI analyst or developer.

    My training and experience is with basic sql admin/maint and sql queries for SQL 2000 and SQL 2005.  I realize the following are most of what I need to learn to get closer to being able to get a job using MS BI technologies:

    SQL 2008 (admin? implementation?)
    Visual Studio
    .NET (which language is best?)

    What's the best order in which to take any training/courses so I can learn them?  Does the above order work? Are there other suggestions? The only programming background I have are the college, class and online courses for Visual Basic 5, Power C, Pascal, VBA from over 10 years ago... So, I understand programming code enough to learn it quickly again.  Just not sure what kind of prerequisites each of the above might require of each other and if I'm missing something I should add to the list.

    Thank you for your input.  I'll worry about cert tests later. Right now, I just want to learn the technology and get familiar with it doing my own projects, etc. I have a test system setup currently with Windows and SQL 2008 and step by step books from o'reilly for SSAS, SSIS, and SSRS, so I can get started on those right away.

    Maybe someone already in BI can describe the order in which they learned the different technologies or the order in which they wish they would have learned things. Thanks!

    Dana Schwehr MCP, A+
    Wednesday, May 25, 2011 11:05 PM


  • I've got one suggestion regarding the order of the topics that you mentioned: I'd place SQL 2008 administration and implementation before SSAS, SSIS and SSRS. You will need to already know how to configure logins and users, how to use the Agent, how to create tables, and so on before you tackle the SSxS parts.

    If you are going to work on the server side, you don't need to learn Visual Studio and .Net. Of course, if you do wish to become a developer, then yes, you will have to go in depth into .Net. The language doesn't matter much. I personally favor C#, but this is a personal preference; you can do in VB.NET anything that can be done in C#.

    • Proposed as answer by Mr. Wharty Wednesday, June 1, 2011 5:21 AM
    • Marked as answer by Rubel Khan Wednesday, June 8, 2011 6:19 AM
    Thursday, May 26, 2011 6:11 AM