70-457 and 70-458 Game Plan Part Uno

Being methodical and logical as I am, I have set forth a plan to achieve my Microsoft Certified Solutions Associate as noted earlier in my goals for 2013.  Having not found much in the way of preparation material as noted in this post , I decided to rent the 70-462 Training Kit from Amazon and transpose some of the objectives there to fit the 70-457 and 70-458 since I am taking the upgrade exams the materials for the regular exams should suffice in preparation.

Now I have outlined a calendar below and the hard dates to hold me accountable to the task especially since the book has to be returned in June.  Let the journey begin!

70-462 Training Kit – 70-457 Objectives
Objective Chapter Lesson Date
Install and Configure
Plan Installation 1 1 1/20/2013
Install SQL Server & related services 1 2 1/20/2013
Implement a migration strategy 4 1 1/27/2013
Configure additional SQL server components 3 1 1/27/2013
Manage SQL Server agent 11 1 2/3/2013
Maintain Instances and Databases
Manage and configure databases 3 3 2/10/2013
Configure SQL Server Instances 2 1 2/17/2013
Implement a SQL Server clustered instance 8 1 2/24/2013
Manage SQL Server instances 2 2 3/3/2013
Optimize and Troubleshoot
Identify and resolve concurrency problems 10 2 3/10/2013
Collect and analyze troubleshooting data 9 1-6 3/17/2013
Audit SQL Server instances 6 3 3/24/2013
70-462 Training Kit – 70-458 Objectives
Manage Data
Configure and maintain a backup strategy 11 2 3/31/2013
Restore databases
11 3 4/7/2013
Implement and maintain indexes
10 1 4/14/2013
Import and Export Data 4 2 4/21/2013
Implement Security
Manage logins and server roles 5 1 4/28/2013
Manage database permissions 6 1 5/5/2013
Manage users and database roles 5 2 5/12/2013
Troubleshoot security 6 2 5/19/2013
Implement High Availability
Implement AlwaysOn 8 2 5/26/2013
Implement database mirroring 7 1 6/2/2013
Implement replication 7 2 6/9/2013
Advertisement

About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on January 10, 2013, in Career Advice, Goals, Personal Development Plan, Training and tagged , , , . Bookmark the permalink. Leave a comment.

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 )

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: