Microsoft Exam 70-443: PRO - Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

This Microsoft Exam 70-443 training course PRO- Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 teaches database administrators how:

• to design a Microsoft SQL Server 2005 database infrastructure,
• to design security for database systems using Microsoft SQL Server 2005,
• to monitor security and respond to threats and to design database solutions that meet the availability needs of their organization

It emphasises high availability, which includes thinking about the database itself and about their entire environment, including:

• business needs
• regulatory requirements
• network, systems, and database considerations during design

Students will also learn how to document and test the high availability database solution.

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 High Availability Database Solutions Using Microsoft SQL Server 2005

Determining Appropriate High-Availability Solutions
Identifying High-Availability Requirements and Constraints
Analyzing High-Availability Requirements and Constraints
High-Availability Solution
Determining Storage Requirements for SQL Server Databases
Determining Storage Requirements for SQL Server Components and Files
Designing Storage Solutions for SQL Server Databases
Designing a Backup and Restore Strategy
Designing the Platform for Failover Clustering
Designing the SQL Server Cluster Implementation
Designing Recovery Strategies and a Test Plan for Failover Clustering
Migrating and Upgrading SQL Server Clusters
Designing an Operations Plan for Clustering
Introduction to Designing a Log Shipping Solution
Designing Log Shipping Server Roles and Topology
Designing a Log Shipping Upgrade Strategy
Designing an Operations Plan for Log Shipping
Introduction to Designing a Database Mirroring Solution
Designing Database Roles and Topology for Database Mirroring
Converting High-Availability Solutions to Database Mirroring
Designing an Operations Plan for Database Mirroring
Introduction to Designing a Replication Solution
Designing a Replication Solution
Designing a Replication Upgrade Strategy
Designing an Operations Plan for Replication
Evaluating Weaknesses in Each High-Availability Technology
Maximizing Availability by Combining High-Availability Technologies
Documenting High-Availability Solutions
Creating a Test Plan for High-Availability Solutions

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

Designing a Microsoft SQL Server 2005 Infrastructure

Estimating Storage Requirements
Estimating CPU Requirements
Estimating Memory Requirements
Estimating Network Requirements
Analyzing Capacity Needs
Identifying Requirements That Affect Data Archiving
Determining the Structure of Archival Data
Creating a Data Archival Plan
Overview of Database Server Consolidation
Designing a Database Server Consolidation Strategy
Selecting a Data Distribution Tool
Creating a Data Distribution Plan Using Replication
Evaluating the Current Database Server Infrastructure
Gathering Requirements for Changing a Database Server Infrastructure
Designing Modifications to a Database Server Infrastructure
Designing a Backup and Restore Strategy
Creating a Database Disaster Recovery Plan
Establishing Database Naming Conventions
Defining Database Standards