One of my goals for 2014/2015 is to learn enough to become a Microsoft Certified Solutions Expert (MCSE): Business Intelligence.
I can upgrade my MCITP certification, but I decided to start from scratch with the SQL Server 2012 exams because it’s a great way for me to learn new features while my company is still using SQL Server 2008. I’m also sure it will be very useful for me to step out of my comfort zone of data warehouse development / architecture and dive into the scary world of database administration.
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 will remain in market without any alterations and passing the three required exams will be my goal this year. The MCSE exams will be updated with SQL Server 2014 topics and I aim to pass them later this year or early next year.
The three Training Kit books finally arrived yesterday: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012, Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases and Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012.
Reviews range from “useless” to “excellent”. Based on my experience I can’t rely on these books alone, but hopefully they’ll be a great starting point and will help me identify what I need to work on. My own reviews will be posted as I finish the books and take the exams.
My plan is simply to work my way through each chapter and write down useful suggestions and improvements for my company. It’s easier for me to learn when I can relate the content to my work. I’m most excited about learning more about database administration since that’s not something I do every day, and most curious about the data warehouse part since I’m kind of already supposed to know my way around dimensional modeling and SSIS :)
I passed exam 70-461 (Querying Microsoft SQL Server 2012) in January 2015.
I passed exam 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) in April 2015.
I passed exam 70-462 (Administering Microsoft SQL Server 2012 Databases) in May 2015.
Have you recently taken any of these exams? What is your job and what did you find most challenging?