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)
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.
Course Review and Exam Tips & Demo Scripts
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