Upgrade your MCDBA Skills to MCITP Database Administrator by Using SQL Server 2005 (Exam 70-447)

SQL Server 2005 - Upgrade your MCDBA Skills to MCITP
Database Administrator Training Course Curriculum:

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

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

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