|
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.
When you pass Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance you complete the requirements for the following certification:
- Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance
Exam 70-432 also counts as credit toward the following certifications:
- MCITP: Database Administrator 2008
The course offers you the most effective way to earn your Microsoft Certified Technology Specialist (MCTS). Developers holding the Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance certification have demonstrated the knowledge and skills necessary to work in environments in which SQL Server 2008 databases are central to their job roles.
This Microsoft Certified Partner Training Course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
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
|
