1. Microsoft SQL Server 2005 Admin MCITP 70-444:1 Optimizing the Performance of Databases and Database Servers
Time: 1 hours
This course covers optimizing database performance at the server, instance, and database levels.
Objectives
- Troubleshoot physical server performance
- Troubleshoot instance performance
- Troubleshoot database performance
2. Microsoft SQL Server 2005 Admin MCITP 70-444:2 Optimizing the Performance of Queries
Time: 1 hours
This course covers optimizing and maintaining query performance. It also addresses troubleshooting concurrency issues.
Objectives
- Identify poorly performing queries
- Analyze a query and plan to detect inefficiencies in query logic
- Maintain and optimize indexes
- Enforce appropriate stored procedure logging and output
3. Microsoft SQL Server 2005 Admin MCITP 70-444:3 Optimizing and Implementing a Data Recovery Plan for a Database
Time: 1 hours
This course covers optimizing and implementing a data recovery plan for databases.
Objectives
- Diagnose causes of failures
- Plan for fault-tolerance
- Recover from a database disaster
- Salvage good data from a damaged database by using restoration techniques
4. Microsoft SQL Server 2005 Admin MCITP 70-444:4 Designing a Strategy to Monitor a Database Solution
Time: 1 hours
This course covers designing monitoring strategies. It also addresses baselines, thresholds, and notifications.
Objectives
- Define and implement monitoring standards for a physical server
- Choose the appropriate information to monitor
5. Microsoft SQL Server 2005 Admin MCITP 70-444:5 Designing a Strategy to Maintain a Database Solution
Time: 1 hours
This course covers the design and implementation of a proactive maintenance solution that will ensure that your database solutions are optimal.
Objectives
- Create and implement a maintenance strategy for database servers
- Design a database maintenance plan
- Design a strategy to manage Reporting Services
6. Microsoft SQL Server 2005 Admin MCITP 70-444:6 Designing and Managing SSIS Packages
Time: 1 hours
This course covers designing and managing SSIS Packages.
Objectives
- Design and manage SAL Server Integration Services (SSIS) packages
7. Microsoft SQL Server 2005 Admin MCITP 70-444:7 Designing a Database Data Management Strategy
Time: 1 hours
This course covers enforcing data quality according to business requirements and designing for data integrity.
Objectives
- Enforce data quality according to business requirements
- Design data integrity
8. Microsoft SQL Server 2005 Admin MCITP 70-444:8 Designing a Strategy to Manage Replication
Time: 1 hours
This course covers recommendations for designing a replication management strategy.
Objectives
- Design a strategy to manage data across linked servers
Topics
- Design a strategy to manage replication
9. Microsoft SQL Server 2005 Admin MCITP 70-444:9 Protecting Your SQL Server from Attack
Time: 1 hours
This course covers considerations for protecting your SQL server.
Objectives
- Optimize a database control strategy to meet business requirements
- Perform a security audit of the existing security infrastructure based on the security plan
- Prepare for and respond to threats and attacks
10. Microsoft SQL Server 2005 Admin MCITP 70-444:10 Designing a Strategy to Manage and Maintain Database Security
Time: 1 hours
This course covers maintaining monitoring strategies at the server and user levels.
Objectives
- Maintain a server-level security strategy
- Maintain a user-level security strategy
11. Microsoft SQL Server 2005 Admin MCITP 70-444:11 Practice Exam 1
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution 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
12. Microsoft SQL Server 2005 Admin MCITP 70-444:12 Practice Exam 2
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution 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
13. Microsoft SQL Server 2005 Admin MCITP 70-444:13 Practice Exam 3
Time: 1 hours
This course presents questions that will help you prepare for the MCITP 70-444 PRO: Optimizing and Maintaining a Database Administration Solution 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