|
We offer you the most effective way to upgrade your MCDBA to SQL Server 2005 technology. The 70-447 TS: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 certification training course teaches students how to optimize and maintain database solutions using SQL Server 2005, including two or more of the following phases in the product life cycle: design, development, deployment, optimization, maintenance, or support. Upon completion of this course, students will be armed with the knowledge and skills to:
- define high-availability solutions
- automate administrative tasks
- define security solutions
- monitor and troubleshoot the database server
- design and execute deployments and define the infrastructure (such as storage, hardware, and number of servers or instances).
This 70-447 course is intended for IT professionals who currently hold an MCDBA and work in the complex computing environment of mid-sized to large companies. The MCDBA certification is a prerequisite for this certification exam.
When you pass Exam 70-447 TS: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 you complete the requirements for the following certification:
- -Microsoft Certified IT Professional, Database Administrator
This Microsoft Certified Partner course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.
Learning Segments
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
|
