MCITP Database Administrator 2008 Certification (70-432 & 70-450) Online Training Bundle

MCITP Database Administrator 2008 Certification (70-432 & 70-450) Online Training Bundle

Course Outline

The MCITP: Database Administrator SQL 2008 certification training course enables students with the knowledge and skills needed to manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. It covers exams 70-432 & 70-450.

OUR Price

£240.00

£200.00+ VAT

R.R.P.

£354.00

£295.00+ VAT

 

Key Features

  • 12 Months Unlimited 24x7 Online Access
    • 24x7 online access to the course materials - anytime, anywhere, and on any device. Just log-in online and learn the skills you need - all at your own pace.
  • Self-Paced Navigation
    • With all courses arranged via multiple on-demand sections, comprehensive navigation & controls allow you to fast forward, skip, rewind, restart, and effectively control your learning pace. This makes it easy to stop at any time, and then quickly get back to where you left off.
  • Expert Instructor-Led Multimedia Training
    • Get trained with full multimedia materials by the finest expert instructors in IT today. This creates a truly personal learning experience, and simulates all the benefits of classroom based learning - all from the comfort of your own home/office.
  • Multi-Tiered Exam Preparation
    • Objective Testing : Utilising questions that follow a specific module, focusing on specific key skills within that area of knowledge.
    • Full Practice Exams : Broad-base exams that cover multiple modules, or the entire syllabus.
    • Certification Practice : Learn where your strong & weak points exist. Simulators give you the chance to practice an actual certification exam. These simulators adhere to the same format as the actual exam provided by a testing centre.
    • The flexibility of these exam simulators & practice-tests allows you to monitor what you've learned, giving you the confidence required to pass your exams at the first attempt.
MCITP Database Administrator 2008 Certification (70-432 & 70-450) Online Training Bundle

Course Description

This Microsoft Certified IT Professional: Database Administrator 2008 (MCITP: Database Administrator 2008) certification training course enables students with the knowledge and skills needed to manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting.

Database Administrators design or implement security or server automation and monitor and troubleshoot SQL Server activity. They are typically employed by mid-sized to large organizations.

This course covers the following exams:

Exam 70-432 : Microsoft SQL Server 2008, Implementation & Maintenance

Installing SQL Server
Services and Installation Process
Installing SQL Server
Module Review

Configuring SQL Instances
Common Server Options
Database Mail
Module Review

Managing Databases
Recovery Models
Partitions
Encryption and Compression
Module Review

Disaster Recovery
Backups and Restores
Database Snapshots
Module Review

Security
Authorization
Policies
Database and Server Level Triggers
SQL Server Auditing
Module Review

Indexes
Specialized Indexes
Module Review
Concurrency
Monitoring Locks
Module Review

Optimizing Performance
SQL Server Profiler
Data Collector
Resource Governor
Module Review
Maintaining a SQL Server Database
Automating SQL Tasks
Maintenance Plans
Importing/Exporting Data
Module Review

High Availability
Database Mirroring
Log Shipping
Replication
Module Review

Course Review and Exam Tips
70-432 Demo Scripts

Exam 70-450 : Designing, optimizing & maintaining a database administrative solution using Microsoft SQL Server 2008

Course Introduction
Instructor Introduction
Course Overview

Module 1 - Configuring SQL Server
Module Overview
Hardware Configuration
Windows Configuration
Instance Configuration
Database Configuration
Maintaining SQL Server
Upgrading
Module Review

Module 2 - Designing Secure SQL Server Solutions
Module Overview
Authentication
Authorization
Encryption
Policies
SQL Server Auditing
Module Review

Module 3 - Designing Highly Available SQL Server Solutions
Module Overview
Failover Clustering
Database Mirroring
Log Shipping
Combining Solutions
Module Review

Module 4 - Designing Disaster Recovery Solutions
Module Overview
Backup Strategies
Recovery Strategies
Piecemeal Backup and Restore
Recovering Pages
Media Failure
Database Snapshots
Module Review

Module 5 - Designing Data Distribution
Module Overview
SQL Server Integration Services
Replication
Module Review

Module 6 - Monitoring SQL Server
Module Overview
Windows Resources
SQL Resources
Resource Governor
Module Review
Course Review
Exam Tips

(Any associated exam costs are not included)
FREE : IT Certification & Career Training Guide