Microsoft SQL Server 2005 Admin MCITP 70-444: 1 Optimizing the Performance of Databases and Database Servers
Description
This course covers optimizing database performance at the server, instance, and database levels.
Objectives
- Troubleshoot physical server performance
- Troubleshoot instance performance
- Troubleshoot database performance
Microsoft SQL Server 2005 Admin MCITP 70-444: 2 Optimizing the Performance of Queries
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444: 3 Optimizing and Implementing a Data Recovery Plan for a Database
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444: 4 Designing a Strategy to Monitor a Database Solution
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444: 5 Designing a Strategy to Maintain a Database Solution
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444: 6 Designing and Managing SSIS Packages
Description
This course covers designing and managing SSIS Packages.
Objectives
- Design and manage SAL Server Integration Services (SSIS) packages
Microsoft SQL Server 2005 Admin MCITP 70-444: 7 Designing a Database Data Management Strategy
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444: 8 Designing a Strategy to Manage Replication
Description
This course covers recommendations for designing a replication management strategy.
Objectives
- Design a strategy to manage data across linked servers
Microsoft SQL Server 2005 Admin MCITP 70-444: 9 Protecting Your SQL Server from Attack
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444:10 Designing a Strategy to Manage and Maintain Database Security
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444:11 Practice Exam 1
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444:12 Practice Exam 2
Description
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
Microsoft SQL Server 2005 Admin MCITP 70-444:13 Practice Exam 3
Description
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