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

I passed the 70-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 today.  Next I will be attempting the 70-458, as I study I’ll put my notes and links to relevant materials here.  I hope to take and pass the exam by the end of March 2014.

I’ll add links to free/paid for resources and if anyone has one that you believe will be helpful just leave a comment.  This exam is half exam 70-462  and half 70-463.

Here is a list of resources that I will be using to prepare for this exam:

• Books
  • Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
  • Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012
• Microsoft Virtual Academy
  • Administering Microsoft SQL Server 2012 Jump Start
  • Implementing a Data Warehouse with SQL Server Jump Start
• PluralSight
  • SQL Server 2012 Database Administration (70-462) Part 1
  • SQL Server 2012 Database Administration (70-462) Part 2
  • SQL Server 2012 Database Administration (70-462) Part 3
  • Integration Services Fundamentals
  • Advanced Integration Services
• MCM Videos
• Links to BOL content for 70-463
• Microsoft Integration Services “How do I ?” Videos

Here is were you can get the listed objectives for the exam taken from Microsoft.  I am going to break the blog post up into a post for each objective to make it easier to follow and see notes.

• Objective 1 – Manage Data
• Objective 2 – Implement Security
• Objective 3 – Implement high availability
• Objective 4 – Design and implement a data warehouse
• Objective 5 – Extract and transform data
• Objective 6 – Load data
• Objective 7 – Configure and deploy SSIS solutions
• Objective 8 – Build data Quality solutions