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 |
Posted on January 10, 2013, in Career Advice, Goals, Personal Development Plan, Training and tagged Certification, Goals, MCSA, SQL Learning. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0