Summary and Links for Microsoft MCSE Data Platform Solutions Expert

mcsepicture

Microsoft MCSE Data Platform
Some notes on the syllabus for this – thinking of taking it.

https://www.microsoft.com/learning/en-gb/mcse-sql-data-platform.aspx

Earning an MCSE : Data Platform certification will qualify you for
jobs such as database analyst and database designer

1 : Querying Microsoft SQL Server 2012
Exam 70-461 – MS SQL 2012 credit towards certification MCSA and MCSE

* Create Database Objects (24%)
* Work with data (27%)
* Modify data (24%)
* Troubleshoot and optimise (25%)

See : https://www.microsoft.com/learning/en-gb/exam-70-461.aspx

2 : Administering Microsoft SQL Server 2012 Databases
Exam 70-462 – MS SQL 2012 credit towards certification MCSA and MCSE

* Install and configure (19%)
* Maintain instances and databases (17%)
* Optimise and troubleshoot (14%)
* Manage data (19%)
* Implement security (18%)
* Implement high availability (12%)

See : https://www.microsoft.com/learning/en-gb/exam-70-462.aspx

3 : Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam 70-463 – MS SQL 2012 credit towards certification MCSA and MCSE

* Design and implementation of data warehouse (11%)
* Extract and transform data (23%)
* Load data (27%)
* Configure and deploy SSIS solutions (24%)
* Build data quality solutions (15%)

See : https://www.microsoft.com/learning/en-gb/exam-70-463.aspx

After completing steps 1-2 you’ll earn a Microsoft certified Solutions
Associate (MCSA) SQL Server 2012 certification

4: Developing Microsoft SQL Server 2012 Databases
Exam 70-464 – MS SQL 2012 credit towards certification MCSE

* Implement database objects (31%)
* Implement programming objects (21%)
* Design database objects (24%)
* Optimise and troubleshoot queries (24%)

See : https://www.microsoft.com/learning/en-gb/exam-70-464.aspx

5 : Designing Database Solutions for SQL Server 2012
Exam 70-465 – MS SQL 2012 credit towards certification MCSE

* Design database structure (29%)
* Design databases and database objects (32%)
* Design database security (15%)
* Design a troubleshooting and optimisation solution (24%)

See : https://www.microsoft.com/learning/en-gb/exam-70-465.aspx

About Mark

Mark Brooks a forty something individual working and living in and around Edinburgh
This entry was posted in All, Learning, Personal Development, SQL Server. Bookmark the permalink.