Day 1

• Analyzing Capacity Needs
• Designing a Strategy for Data Archiving
• Designing a Strategy for Database Server Consolidation
• Designing a Strategy for Data Distribution
• Designing a Database Server Infrastructure
• Designing a Strategy for Data Recovery
• Establishing Database Conventions and Standards

Day 2

• Introduction to Designing SQL Server Security
• Designing a SQL Server Systems Infrastructure Security Policy
• Designing Security Policies for Instances and Databases
• Integrating Data Encryption into a Database Security Design
• Designing a Security Exceptions Policy
• Designing a Response Strategy for Threats and Attacks

Day 3 - Testing Day

• Exam 70-443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
• Selecting the Appropriate High ? availability Solution
• Designing a Clustering Solution
• Designing a Highly Available Database Storage Solution

Day 4

• Designing a Log Shipping Solution
• Designing a Database Mirroring Solution
• Designing a Highly Available Solution Based on Replication
• Combining High-availability Technologies
• Documenting and Testing a High-availability Strategy

Day 5

• Managing and Automating Databases and Servers
• Managing SQL Server Supporting Services
• Building a Monitoring Solution for SQL Server Performance Issues
• Troubleshooting Database and Database Server Performance Issues
• Optimizing the Query Performance Environment

Day 6 - Testing Day

• Troubleshooting SQL Server Connectivity Issues
• Troubleshooting SQL Server Data Issues
• Exam 70-444: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005