Microsoft SQL Server 2005 Admin MCITP 70-444 - Online Course

This series provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Administrator. PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444), will cover your ability to maintain everyday operations of enterprise Microsoft SQL Server 2005 databases. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who wants to achieve MCITP 70-444 certification. This online course contains 10 lessons and 3 practice exams and should take approximately 13 hours to complete.

Lesson 1: Optimizing the Performance of Databases and Database Servers (1.0) hour

Optimizing the Performance of Databases and Database Servers teaches you how to troubleshoot physical server performance, troubleshoot instance performance, and troubleshoot database performance. This course covers optimizing database performance at the server, instance, and database levels.

Lesson 2: Optimizing the Performance of Queries (1.0) hour

Optimizing the Performance of Queries teaches you how to identify poorly performing queries, analyze a query and plan to detect inefficiencies in query logic, maintain and optimize indexes, and enforce appropriate stored procedure logging and output. This course covers optimizing and maintaining query performance. It also addresses troubleshooting concurrency issues.

Lesson 3: Optimizing and Implementing a Data Recovery Plan for a Database (1.0) hour

Optimizing and Implementing a Data Recovery Plan for a Database teaches you how to diagnose causes of failures, plan for fault-tolerance, recover from a database disaster, and salvage good data from a damaged database by using restoration techniques. This course covers optimizing and implementing a data recovery plan for databases.

Lesson 4: Designing a Strategy to Monitor a Database Solution (1.0) hour

Designing a Strategy to Monitor a Database Solution teaches you how to define and implement monitoring standards for a physical server, and choose the appropriate information to monitor. This course covers designing monitoring strategies. It also addresses baselines, thresholds, and notifications.

Lesson 5: Designing a Strategy to Maintain a Database Solution (1.0) hour

Designing a Strategy to Maintain a Database Solution teaches you how to create and implement a maintenance strategy for database servers, design a database maintenance plan, and design a strategy to manage Reporting Services. This course covers the design and implementation of a proactive maintenance solution that will ensure that your database solutions are optimal.

Lesson 6: Designing and Managing SSIS Packages (1.0) hour

Designing and Managing SSIS Packages teaches you how to design and manage SAL Server Integration Services (SSIS) packages. This course covers designing and managing SSIS Packages.

Lesson 7: Designing a Database Data Management Strategy (1.0) hour

Designing a Database Data Management Strategy teaches you how to enforce data quality according to business requirements, and design data integrity. This course covers enforcing data quality according to business requirements and designing for data integrity.

Lesson 8: Designing a Strategy to Manage Replication (1.0) hour

Designing a Strategy to Manage Replication teaches you how to design a strategy to manage data across linked servers. This course covers recommendations for designing a replication management strategy. Topics include Design a strategy to manage replication.

Lesson 9: Protecting Your SQL Server from Attack (1.0) hour

Protecting Your SQL Server from Attack teaches you how to optimize a database control strategy to meet business requirements, perform a security audit of the existing security infrastructure based on the security plan, and prepare for and respond to threats and attacks. This course covers considerations for protecting your SQL server.

Lesson 10: Designing a Strategy to Manage and Maintain Database Security (1.0) hour

Designing a Strategy to Manage and Maintain Database Security teaches you how to maintain a server-level security strategy, and maintain a user-level security strategy. This course covers maintaining monitoring strategies at the server and user levels.

3 Practice Exams

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.