Want to upgrade your current MCTS Certification in SQL 2008?

Certification Path

With the release of SQL Server 2012 last year, Microsoft also overhauled its certification exams for DBA Professionals.

If you are an MCTS Certified IT Professional in SQL Server 2008 Implementation and Maintenance, you need to follow the path as shown in the image above. You need to take 2 cerftication exams :

1. 70-457 :Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1

2. 70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

Exam 70-457 covers T-SQL statements, Joins, Subqueries, New data types and new query features in SQL Server 2012.

Exam 70-458 deals more with tasks on administration and maintenance. It covers Administration, Implementation and Maintenance, contrast and compare AlwaysOn technology, Implement solutions using Data Quality Storage.

Click here to get a complete overview of the the exam description and path.

The training materials are not yet available from Microsoft Press. I managed to get this book though from Amazon. It’s very basic and covers the topics for the exam yet you need to do deep dive in other resources. There is also a part in the book that has a basic question and answer portion to help you review what you’ve just read. I use this part of the book to include in my practice questions.

I have certification in MCTS and i plan to take this exam to upgrade my certification level. I am currently using this book as guide for all the topics covered in Exam 70-457 and  at the same time research, research and more online research everyday and don’t forget about the very helpful virtual labs in TechNet. I will write more on this next time.

Enjoy learning more!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


Inspired Global Storytelling

My Time to Travel

The travels of an old(er), solo, woman


The life of a data geek


Traveller Observer

The SQL Pro

(Ayman El-Ghazali - www.thesqlpro.com)

Meels on Wheels

Meels for breakfast, lunch and dinner.


Building A Business While Having A Life

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009


Explaining the bits and bytes of SQL Server and Azure

Coding Tips

We are crazy about programming and we want to share our craziness with you!!!

SQL Studies

 Live, Learn, Share

Sql And Me

My Experiments with SQLServer

Dimitrios Kalemis

I am exactly like Jesus Christ: an atheist and anarchist against society and bad people with influence and power (judges, social workers, politicians, priests, and teachers).

Clint Huijbers' Blog

Senior Certified Microsoft BI Consultant

Blog of Many Useless Wonders

Where Uselessness Abounds!

Steve Spevack's Blog

IT Recruitment