Learn online with these interactive online courses.
Affordable Pricing (Only $99.95 for the complete series)
A full year to complete the courses
Retake the courses as many times as you like
Measure your progress with assessment tests after each course
Earn completion certificates after passing each assessment test
Microsoft SQL Server 2005 Design MCITP 70-443 Series (16 hours)
1. Microsoft SQL Server 2005 Design MCITP 70-443:1 Designing the Hardware and Software Infrastructure
Time: 2 hours
This course covers planning and designing a database infrastructure.
Objectives
Design for capacity requirements
Specify software versions and hardware configurations
2. Microsoft SQL Server 2005 Design MCITP 70-443:2 Designing Physical Storage
Time: 1 hours
This course covers how to best design and organize physical storage.
Objectives
Design physical storage
Design instances
3. Microsoft SQL Server 2005 Design MCITP 70-443:3 Designing a Consolidation Strategy
Time: 2 hours
This course covers developing a database consolidation strategy.
Objectives
Design a database consolidation strategy
4. Microsoft SQL Server 2005 Design MCITP 70-443:4 Designing Database-Level Security
Time: 1 hours
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
5. Microsoft SQL Server 2005 Design MCITP 70-443:5 Designing Windows Server-Level Security Processes
Time: 1 hours
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
6. Microsoft SQL Server 2005 Design MCITP 70-443:6 Designing SQL Server Service-Level Security
Time: 1 hours
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
7. Microsoft SQL Server 2005 Design MCITP 70-443:7 Designing SQL Server Object-Level Security
Time: 1 hours
This course covers the lowest level of security - the objects that store and interact with data.
Objectives
Develop object-level security
8. Microsoft SQL Server 2005 Design MCITP 70-443:8 Designing a Physical Database
Time: 1 hours
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
9. Microsoft SQL Server 2005 Design MCITP 70-443:9 Creating Database Conventions and Standards
Time: 1 hours
This course covers database conventions and standards.
Objectives
Create database conventions and standards
Create database change control procedures
10. Microsoft SQL Server 2005 Design MCITP 70-443:10 Designing a SQL Server 2005 Solution for High Availability
Time: 1 hours
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
11. Microsoft SQL Server 2005 Design MCITP 70-443:11 Designing a Data Recovery Solution for a Database
Time: 1 hours
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
12. Microsoft SQL Server 2005 Design MCITP 70-443:12 Designing a Data-Archiving Solution
Time: 1 hours
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
13. Microsoft SQL Server 2005 Design MCITP 70-443:13 Practice Exam 1
Time: 1 hours
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
Topics
Practice exam
14. Microsoft SQL Server 2005 Design MCITP 70-443:14 Practice Exam 2
Time: 1 hours
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
Topics
Practice exam
Resources for Microsoft SQL Server 2005 Design MCITP 70-443
Know of a good resource for Microsoft SQL Server 2005 Design MCITP 70-443 Online Training? Please Let Us Know.