none
SSRS RRS feed

  • Question

  • What would be the closest thing to getting certification in SSRS?

    Had a look at course 10774 and 10778. 10778 covers it more but do I need to know anything from the previous courses before doing 10778?

    Thursday, August 7, 2014 12:25 PM

Answers

  • There is no exam specific to SSRS.  The closest is 70-466 however it also includes a lot on SSAS.

    Here are the Student Prerequisites for course 10778 (which has been superseded by 20466):

    • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

    This course is also heavily based around SSAS with only 5 of the 12 modules dedicated to SSRS.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCSA, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript


    Thursday, August 7, 2014 10:29 PM
    Moderator
  • Hi, ElectricRose.

    Please do not confuse taking a Microsoft course with earning a certification. You cannot earn a certification by merely take a course.

    Here is course 20466C, as explained by Mr. Wharty: https://www.microsoft.com/learning/en-us/course.aspx?ID=20466C

    Instead, you must purchase and pass one or more computer exams to earn a certification. This year, you can purchase exams with Prometric. Eventuqlly exams will be delivered by Pearson Certiport.

    As suggested by Mr. Wharty, the closest exam would be 70-466: https://www.microsoft.com/learning/en-us/exam-70-466.aspx

    It is one of five exams required to earn the SQL Server: Business Intelligence certification. Learn more about this certification here: https://www.microsoft.com/learning/en-us/mcse-sql-business-intelligence.aspx

    Alternately, you can just go for the MCSA SQL Server 2012 title, which only requires you to pass three exams. Here: https://www.microsoft.com/learning/en-us/mcsa-sql-certification.aspx

    In order to earn either of these titles, you will need to have a thorough understanding of SQL Server and the related business intelligence tools.

    Good luck!


    Best wishes, Davin Mickelson

    Thursday, August 7, 2014 10:41 PM
    Answerer

All replies

  • There is no exam specific to SSRS.  The closest is 70-466 however it also includes a lot on SSAS.

    Here are the Student Prerequisites for course 10778 (which has been superseded by 20466):

    • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

    This course is also heavily based around SSAS with only 5 of the 12 modules dedicated to SSRS.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCSA, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript


    Thursday, August 7, 2014 10:29 PM
    Moderator
  • Hi, ElectricRose.

    Please do not confuse taking a Microsoft course with earning a certification. You cannot earn a certification by merely take a course.

    Here is course 20466C, as explained by Mr. Wharty: https://www.microsoft.com/learning/en-us/course.aspx?ID=20466C

    Instead, you must purchase and pass one or more computer exams to earn a certification. This year, you can purchase exams with Prometric. Eventuqlly exams will be delivered by Pearson Certiport.

    As suggested by Mr. Wharty, the closest exam would be 70-466: https://www.microsoft.com/learning/en-us/exam-70-466.aspx

    It is one of five exams required to earn the SQL Server: Business Intelligence certification. Learn more about this certification here: https://www.microsoft.com/learning/en-us/mcse-sql-business-intelligence.aspx

    Alternately, you can just go for the MCSA SQL Server 2012 title, which only requires you to pass three exams. Here: https://www.microsoft.com/learning/en-us/mcsa-sql-certification.aspx

    In order to earn either of these titles, you will need to have a thorough understanding of SQL Server and the related business intelligence tools.

    Good luck!


    Best wishes, Davin Mickelson

    Thursday, August 7, 2014 10:41 PM
    Answerer