Forgot My Password Support
◊ MICROSOFT SQL SERVER 2005 ADMIN MCITP 70-444 ONLINE TRAINING SERIES

Online Microsoft SQL Server 2005 Admin MCITP 70-444 Training


Only $99.95

Microsoft SQL Server 2005 Admin MCITP 70-444 Series (13 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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

Topics

  • Practice Exam



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

Topics

  • Practice exam



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

Topics

  • Practice exam



Resources for Microsoft SQL Server 2005 Admin MCITP 70-444