MCTS 70-432 Microsoft SQL Server 2008

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the primer certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. Database administrators install or configure SQL Server and manager or maintain databases or multidimensional databases, databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by midsize to large organizations.

Unit 1: Introducing SQL Server 2008

• Topic A: Understanding SQL Server’s Role.
• Topic B: Chapter 2 Installing SQL Server 2008.
• Topic C: Chapter 3 Working with the Administration Tools.
• Topic D: SQL Server Command-Line Administration.

Unit 2: Designing Database Solutions

• Topic A: Database Concepts and Terminology.
• Topic B: ERD and Capacity Planning.
• Topic C: Normalization: Enough Is Enough.

Unit 3: Implementing Database Solutions

• Topic A: Creating SQL Server Databases
• Topic B: Creating Tables
• Topic C: Indexes and Views
• Topic D: Triggers and Stored Procedures
• Topic E: Implementing Advanced Features

Unit 4: Administration and Maintenance

• Topic A: Creating Jobs, Operators, and Alerts.
• Topic B: Performance Monitoring and Tuning.
• Topic C: Policy-Based Management.
• Topic D: Backup and Restoration.

Unit 5: SQL Server Security

• Topic A: Security Threats and Principles.
• Topic B: Authentication and Encryption.
• Topic C: Security Best Practices.

Unit 6: High Availability and Data Distribution

• Topic A: SQL Server Failover Clustering.
• Topic B: Database Mirroring and Snapshots.
• Topic C: Implementing Replication.