Microsoft SQL Server 2005 Admin MCITP 70-444
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.
Optimizing the Performance of Databases and Database Servers
This course covers optimizing database performance at the server, instance, and database levels and teaches you how to troubleshoot physical server performance, troubleshoot instance performance, and troubleshoot database performance.
Optimizing the Performance of Queries
This course covers optimizing and maintaining query performance It also addresses troubleshooting concurrency issues and 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.
Optimizing and Implementing a Data Recovery Plan for a Database
This course covers optimizing and implementing a data recovery plan for databases and 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.
Designing a Strategy to Monitor a Database Solution
This course covers designing monitoring strategies It also addresses baselines, thresholds, and notifications and teaches you how to define and implement monitoring standards for a physical server, and choose the appropriate information to monitor.
Designing a Strategy to Maintain a Database Solution
This course covers the design and implementation of a proactive maintenance solution that will ensure that your database solutions are optimal and 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.
Designing and Managing SSIS Packages
This course covers designing and managing SSIS Packages and teaches you how to design and manage SAL Server Integration Services (SSIS) packages.
Designing a Database Data Management Strategy
This course covers enforcing data quality according to business requirements and designing for data integrity and teaches you how to enforce data quality according to business requirements, and design data integrity.
Designing a Strategy to Manage Replication
This course covers recommendations for designing a replication management strategy and teaches you how to design a strategy to manage data across linked servers.
Protecting Your SQL Server from Attack
This course covers considerations for protecting your SQL server and 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.
Designing a Strategy to Manage and Maintain Database Security
This course covers maintaining monitoring strategies at the server and user levels and teaches you how to maintain a server-level security strategy, and maintain a user-level security strategy.
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.