Microsoft SQL Server 2005 Design MCITP 70-443: 1 Designing the Hardware and Software Infrastructure
Description
This course covers planning and designing a database infrastructure.
Objectives
- Design for capacity requirements
- Specify software versions and hardware configurations
Microsoft SQL Server 2005 Design MCITP 70-443: 2 Designing Physical Storage
Description
This course covers how to best design and organize physical storage.
Objectives
- Design physical storage
- Design instances
Microsoft SQL Server 2005 Design MCITP 70-443: 3 Designing a Consolidation Strategy
Description
This course covers developing a database consolidation strategy.
Objectives
- Design a database consolidation strategy
Microsoft SQL Server 2005 Design MCITP 70-443: 4 Designing Database-Level Security
Description
This course covers designing an effective database-level security policy for SQL Server 2005 instances.
Objectives
- Analyze business requirements
- Integrate database security with enterprise-level authentication systems
- Modify the security design based on the impact of network security policies
- Analyze the risk of attacks to the server environment and specify mitigations
Microsoft SQL Server 2005 Design MCITP 70-443: 5 Designing Windows Server-Level Security Processes
Description
This course covers how the server-wide security parameters of SQL Server are determined and set globally for each instance.
Objectives
- Develop Microsoft Windows server-level security policies
Microsoft SQL Server 2005 Design MCITP 70-443: 6 Designing SQL Server Service-Level Security
Description
This course covers server-level SQL Server security items that affect the entire database service.
Objectives
- Design SQL Server service-level security
- Design database-level security
Microsoft SQL Server 2005 Design MCITP 70-443: 7 Designing SQL Server Object-Level Security
Description
This course covers the lowest level of security - the objects that store and interact with data.
Objectives
- Develop object-level security
Microsoft SQL Server 2005 Design MCITP 70-443: 8 Designing a Physical Database
Description
This course covers creating, configuring, and administering databases in order to maximize their performance.
Objectives
- Modify an existing database design based on performance and business requirements
- Design tables and filegroups
- Design index usage and views
Microsoft SQL Server 2005 Design MCITP 70-443: 9 Creating Database Conventions and Standards
Description
This course covers database conventions and standards.
Objectives
- Create database conventions and standards
- Create database change control procedures
Microsoft SQL Server 2005 Design MCITP 70-443:10 Designing a SQL Server 2005 Solution for High Availability
Description
This course covers the technologies used in SQL Server to achieve a highly available database server.
Objectives
- Develop a strategy for migration to a highly available environment
- Design a highly available database storage solution
- Design a database-clustering and database mirroring solutions
- Design a high-availability solution based on replication
Microsoft SQL Server 2005 Design MCITP 70-443:11 Designing a Data Recovery Solution for a Database
Description
This course covers planning a data recovery strategy for databases, including a backup and restore plan.
Objectives
- Specify data recovery technologies based on business requirements
- Design backup strategies
- Create a disaster recovery plan
Microsoft SQL Server 2005 Design MCITP 70-443:12 Designing a Data-Archiving Solution
Description
This course covers designing a data-archiving solution.
Objectives
- Select archiving techniques based on business requirements
- Design the format of archival data
- Specify what data to archive and plan for data archival and access
- Design the topology and type of replication for archiving data
Microsoft SQL Server 2005 Design MCITP 70-443:13 Practice Exam 1
Description
This course presents questions that will help you prepare for the MCITP 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions
Microsoft SQL Server 2005 Design MCITP 70-443:14 Practice Exam 2
Description
This course presents questions that will help you prepare for the MCITP 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.
Objectives
- Complete the practice exam questions