Microsoft Exam 70-444: PRO - Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

The Microsoft Exam 70-444 training course PRO - Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 teaches database administrators:

• to design security for database systems using Microsoft SQL ServerT 2005
• to administer and automate Microsoft SQL Server 2005 databases and servers
• to determine and troubleshoot performance issues using Microsoft SQL Server 2005, including establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.

When you pass this exam, you earn credit towards the following certifications: MCITP Database Administrator.

This Microsoft Certified Partner, approved Microsoft course curriculum, ensures you receive the training and knowledge needed to succeed.

Learning segments

Designing Security for Microsoft SQL Server 2005

Principles of Database Security
Security Standards
Methodology for Designing a SQL Server Security Policy
Monitoring SQL Server Security
Developing an Authentication Policy
Developing Server-Level Security Policies
Developing a Secure Communication Policy
Defining SQL Server Security-Monitoring Standards
Designing an Instance-Level Security Policy
Designing a Database-Level Security Policy
Designing an Object-Level Security Policy
Defining Security Monitoring Standards for Instances and Databases
Securing Data by Using Encryption and Certificates
Designing Data Encryption Policies
Determining a Key Storage Method
Analyzing Business and Regulatory Requirements
Determining the Exceptions and Their Impact
Constraints of Government Regulations
Designing a Response Policy for Virus and Worm Attacks
Designing a Response Policy for Denial of Service Attacks
Designing a Response Policy for Internal and SQL Injection Attacks

Administering and Automating Microsoft SQL Server 2005 Databases and Servers

Planning an Automated System for Database Maintenance
Planning an Automated System for Server Maintenance
Documenting Administration and Automation Information
Managing SSIS Packages
Managing Replication
Managing Reporting Services

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

Using SQL Server Profiler and System Monitor
Troubleshoot Performance Issues
Narrowing Down a Performance Issue to a Database Object
Troubleshooting Database Server Performance Issues
Query Performance Troubleshooting Process
Optimizing the Query Performance Environment
Troubleshooting SQL Server Connectivity Issues
Areas to Troubleshoot for Connectivity Issues
Troubleshooting SQL Server Data Issues
Troubleshooting Data Integrity Issues
Troubleshooting Concurrency Issues
SQL Server Data Concurrency Issues