Exam 70-443: Designing a Database Server Infrastructure SQL2005

MCITP : Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. In addition, MCITP DBA's also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations.

MCITP candidates for this exam are professional database administrators who optimize and maintain database solutions. They have three or more years dedicated to database work, which may include two or more of the following phases in the product lifecycle: design, development, deployment, optimization, maintenance, or support. The typical work environment is an enterprise or a medium-sized organization. MCITP candidates should be experienced in using Microsoft SQL Server 2005.

How to Earn Your MCITP: Database Administrator

MCITP : Database Administrator Candidates without a MCTS Certification

1. Earn your MCTS: SQL Server 2005 by passing- the following exam:

• MCTS Exam 70–431: Microsoft SQL Server 2005 - Implementation and Maintenance

2. After earning this certification, candidates earn their MCITP: Database Administrator by passing two required exams.

• MCITP Exam 70–443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
• MCITP Exam 70–444: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

PACKAGE INCLUDES:

• 3 DVDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
• Interactive Hands-on-lab simulations
• Printable Courseware
• Exclusive LearningZone Live Mentor (Value at $585) Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7). Only $69.00 extra per exam (optional).
• 3 Microsoft Authorized MeasureUp Exam Simulations 
• Proven technique- Actual Exam Secrets Review
• Free 1 Year Upgrade Policy

Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)
Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.

COURSE OUTLINE:

Part I

Module 01 - Capacity Requirements

Module 02 - Data Archiving

Module 03 - Database Server Consolidation

Module 04 - Data Distribution

Module 05 - Database Server Infrastructure

Module 06 - Data Recovery

Module 07 - Database Conventions and Standards

Part II

Module 01 - Introduction to SQL Server Security

Module 02 - SQL Server Systems Infrastructure Security Policy

Module 03 - Instance and Database Security Policies

Module 04 - Integrating Data Encryption

Module 05 - Security Exceptions Policy

Module 06 - Response Policy for Threats and Attacks

Part III

Module 01 - Proposing a High-availability Solution

Module 02 - Highly Available Database Storage Solution

Module 03 - Failover Clustering Solution

Module 04 - Log Shipping Solution

Module 05 - Database Mirroring Solution

Module 06 - Replication Solutions for High Availability

Module 07 - Combining High-Availability Technologies

Module 08 - Documenting High-Availability Solutions