Answered by:
SSRS

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- Edited by Mr. Wharty Thursday, August 7, 2014 10:30 PM
- Proposed as answer by Davin MickelsonEditor Thursday, August 7, 2014 10:41 PM
- Marked as answer by Danny van DamMVP, Editor Tuesday, August 26, 2014 9:33 AM
Thursday, August 7, 2014 10:29 PM -
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
- Proposed as answer by Mr. Wharty Thursday, August 7, 2014 10:43 PM
- Marked as answer by Danny van DamMVP, Editor Tuesday, August 26, 2014 9:33 AM
Thursday, August 7, 2014 10:41 PMAnswerer
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- Edited by Mr. Wharty Thursday, August 7, 2014 10:30 PM
- Proposed as answer by Davin MickelsonEditor Thursday, August 7, 2014 10:41 PM
- Marked as answer by Danny van DamMVP, Editor Tuesday, August 26, 2014 9:33 AM
Thursday, August 7, 2014 10:29 PM -
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
- Proposed as answer by Mr. Wharty Thursday, August 7, 2014 10:43 PM
- Marked as answer by Danny van DamMVP, Editor Tuesday, August 26, 2014 9:33 AM
Thursday, August 7, 2014 10:41 PMAnswerer