SQL Server 2005 Upgrade MCTS 70-447


SQL Server 2005 Upgrade MCTS 70-447

This course offers you the most effective way to upgrade your MCDBA to SQL Server 2005 technology. 

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).

Our 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

  The Microsoft Certified Database Administrator (MCDBA) credential is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server.

n Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software - saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format - allowing you to get the most out of your time. n

Our courses incorporate audio, video, and text training and then the total experience is reinforced with exercises and practice tests to ensure that you have really grasped the material.

This Course is available online or via DVD's:
Online Course = All items marked with are included.
DVD Study Kit = Everything! - If its marked with then its included.
For Pricing - Click Here
Live Video,
Courses =
Courses =
Online Streaming Video
(Broadband min 512k)
12 Months subscription
Featuring live instructor-led classroom-like sessions in digital video format. Multimedia-rich delivery brings experienced subject matter experts to your desktop or laptop.
Training Simulations  
DVD Courses = Delivered on DVD
Online Courses = Online Access
Interactive hands-on practice lab
Email Support  
1 Year's Technical Email Support
DVD Courses= Delivered
on DVD
Online Courses = Downloadable
Free Upgrades  
12 months of Free Upgrades.
Compatibility with:  

XP | Win 2003/8 server | Vista
Exam Simulator  
Exam Simulator for closest replication to the real exam!



Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player





(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


Full motion video

Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Instructor-Led Training

Combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media DVD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.


We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.Supplied on DVD for DVD courses or downloadable for Online Courses.

Practice Exam Simulators

We offer exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam!

Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test.
If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.

Hands-on Lab Simulation

Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..

Free Upgrades

A unique benefit of the our Learning System, is that
it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive DVD's for up to 1 year from date of original purchase? absolutely free!


SQL Server 2005 Upgrade MCTS 70-447

Online Course: £300 + VAT
DVD Study Kit: £300 + VAT
List Price:£550  
Online Library: 95% off

1yr Unlimited Online Access to 143 Courses
Save 95%

      What's included in each option?

mcse training
 ©Copyright 2009 All Rights Reserved
SQL Server 2005 Upgrade MCTS 70-447