Learning Plan for Implementing and Maintaining Microsoft SQL Server 2008 (Exam 70-432)
This learning plan is intended to help IT professionals and developers gain the knowledge and skills required to implement and maintain Microsoft SQL Server 2008, and ultimately to prepare for Microsoft exam 70-432.
Step 1 – Features and Tools Overview (SQL Server 2008)
This TechNet guide contains content on the variety of Microsoft SQL Server features and tools that you can use to develop and manage your databases and solutions.
Step 2 – Collection 6187: What’s New in Microsoft SQL Server 2008
In this 3 hour on-line collection, IT Professionals will learn about the new features in SQL Server 2008.
Step 3 – Course 6231A: Maintaining a Microsoft SQL Server 2008 Database
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
Step 4 – Course 6232B: Implementing a Microsoft SQL Server 2008 R2 Database
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.
Step 5 – Collection 6369: Implementing and Maintaining Microsoft SQL Server 2008
This 16-hour collection provides you with the skills and knowledge required for implementing and maintaining Microsoft SQL Server 2008.
Topics covered in this course include:
– Installing and Configuring SQL Server 2008
– Creating and Managing Databases
– Planning, Creating, and Optimizing Indexes
– Backing Up and Restoring Databases
– Managing Security
– Automating Administrative Tasks
– Monitoring and Controlling Resources
– Implementing High Availability and Replication
Step 6 – Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This three-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Step 7 – MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 – Implementation and Maintenance
This 2-in-1 kit delivers in-depth preparation plus practice MCTS Exam 70-432, SQL Server 2008—Implementation and Maintenance. Ace your exam prep—and build real-world job skills—with lessons, labs, practice tests, and more.
Step 8 – SQL Server 2008 Books Online
This SQL Server TechCenter resource contains content on the following topics:
– Database Engine
– Analysis Services—Multidimensional Data
– Analysis Services—Data Mining
– Integration Services
– Reporting Services
– SQL Server Service Broker
Step 9 – TechNet Webcast: 24 Hours of SQL Server 2008
This series of 90-minute webcasts explores the features of SQL Server 2008. Learn how to:
– Manage, monitor, secure, and optimize consolidated data systems
– Consolidate servers with multiple databases
– Consolidate data services through virtualization
– Migrate databases
– Build a scalable infrastructure that manages reports and analysis and eases data access
Step 10 – Preparation Guide for Exam 70-432
This certification exam measures your ability to implement and maintain Microsoft SQL Server 2008 installations.
Step 11 – Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
Register now to take Exam 70-432.