◊ MICROSOFT SQL SERVER 2005 DESIGN MCITP 70-443 ONLINE TRAINING SERIES
Online Microsoft SQL Server 2005 Design MCITP 70-443 Training
Database » SQL Server
Check out these great money-saving course packages:
Only $99.95
Microsoft SQL Server 2005 Design MCITP 70-443 Series (16 hours)
ONLINE COURSE FEATURES
- Learn online with these interactive online elearning courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the elearning courses
- Retake the elearning courses as many times as you like
- Measure your progress with assessment tests after each elearning course
- Earn completion certificates after passing each assessment test
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. Designing Physical Storage
Time: 1 hours
This course covers how to best design and organize physical storage.
Objectives
- Design physical storage
- Design instances
3. Designing a Consolidation Strategy
Time: 2 hours
This course covers developing a database consolidation strategy.
Objectives
- Design a database consolidation strategy
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. 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. 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. 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. 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. 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. 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. 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. 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. 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
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
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.
