I’ve managed to pass the following exams so far:
- 461 – Querying Microsoft SQL Server 2012
- 462 – Administering Microsoft SQL Server 2012 Databases
- 464 – Developing Microsoft SQL Server 2012 Databases
Since then I’ve had a break and have been going through Kalen Delaney’s excellent Microsoft SQL Server 2012 Internals book but now I’m going to start looking at
- 463 – Implementing a Data Warehouse with Microsoft SQL Server 2012
This one along with 461 and 462 will give me the Microsoft Certified Solutions Associate (MCSA) qualification.
Then I’ve got
- 465 – Designing Database Solutions for SQL Server 2012
which along with 464 increases the MCSA to a Microsoft Certified Solutions Expert (MCSE). There are two flavours of MCSE, this one would be the Data Platform one. There is also the Business Intelligence one which has the following exams instead of 464 and 465.
- 466 – Implementing Data Models and Reports with Microsoft SQL Server 2012
- 467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012
I haven’t decided if I’ll go for the BI ones as well but we’ll see.
If you’re looking for a good resource for helping with the exams then I’d recommend the official guide books and practise tests. The first 2012 exam I did was the DBA one (462) and I read that cover to cover before even looking at the practise tests. For 461 I found it much better to read the book not in chapter order but in objective order. The front couple of pages of the book list the exam objectives along with the relevant chapters for each one. I read all the chapters for the first objective and kept at the practise tests for that objective until I was getting 80 – 90%, then moved on to the next one. You can set up the practise tests to only include questions for a particular objective, or multiple objectives which is very handy. Once I was passing the questions for the second objective I ran through a few tests containing questions for both the first and second objectives and then moved on to the third. I carried on until all objectives where complete and I was getting high scores on the entire test. I’m planning on doing the same for the data warehousing book (463).