70-432 SQL Server 2008, Implementation and Maintenance

Course Name

70-432 SQL Server 2008, Implementation and Maintenance

Contact Hours: 45 (an estimated time frame devoted to a course of study from start to finish that can vary from student to student)

Course Description

MCTS 70-432 Training Course TS: Microsoft SQL Server 2008, Implementation and Maintenance  teaches students how to install and configure SQL Server 2008, maintain SQL Server instances and databases, manage SQL Server security, perform data management, optimize performance, monitor and troubleshoot SQL Server and implement high availablity with SQL Server 2008. Bonus--1 year post course completion access.

Outcome

Assessment

Course Review and Exam Tips & Demo Scripts

Outline

Microsoft Exam 70-432: MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Certification Training Course Curriculum:
Course Outline
Installing SQL Server

Services and Installation Process
Installing SQL Server
Module Review
Configuring SQL Instances

Common Server Options
Database Mail
Module Review
Managing Databases

Recovery Models
Partitions
Encryption and Compression
Module Review
Disaster Recovery

Backups and Restores
Database Snapshots
Module Review
Security

Authorization
Policies
Database and Server Level Triggers
SQL Server Auditing
Module Review
Indexes

Specialized Indexes
Module Review
Concurrency
Monitoring Locks
Module Review
Optimizing Performance

SQL Server Profiler
Data Collector
Resource Governor
Module Review
Maintaining a SQL Server Database
Automating SQL Tasks
Maintenance Plans
Importing/Exporting Data
Module Review
High Availability

Database Mirroring
Log Shipping
Replication
Module Review
Course Review and Exam Tips
70-432 Demo Scripts