Microsoft SQL Server 2008-Designing and Maintaining

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Video Title	Minutes
00: Course Introduction	5
01: Designing a SQL Server Instance and a Database Solution	22
02: Design Migration	25
03: Designing a Database Server Security Solution	23
04: Design a Security and Audit Plan	24
05: Designing a Database Solution for High Availability	22
06: Replication	22
07: Designing a Backup and Recovery Solution	25
08: Designing a Monitoring Strategy	23
09: Design a Solution to Monitor Performance	20
10: Performance Studio	22
11: Designing a Maintenance Strategy	24
12: Resource Governor	20
13: Designing Policy-Based Management	24
14: Designing Strategy for Data Distribution	22
15: Data Replication	20
16: Course Summary	8
Total:	5 Hours, 3 Minutes

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Downloads

NOTE: Click link then select "Save"

• Student Guide
• Lab Setup and Exercise Guide

Related Links

• Course Survey
• Microsoft Exam Requirements
• Exam Location and Pricing

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Description

This Microsoft online training course will teach you how to design and optimize the SQL Server 2008 database. Microsoft SQL Server 2008-Designing and Maintaining training will give you knowledge in how to maintain the SQL Server database for high availability and teach you about address data distribution.

In order to take this course you need to have taken Microsoft SQL Server 2008-Implementing and have six months database administrator experience.

Download the course outline.

Related Training

• Course: Microsoft SQL Server 2008-Implementing
• Podcast: SQL Server 2008 Data Compression
• Podcast: SQL Server 2008 Database Administration Certification
• Podcast: SQL Server 2008 Operating System Requirements
• Podcast: SQL Server 2008 Reporting Services
• Podcast: SQL Server 2008 SSIS

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Microsoft SQL Server 2008-Designing and Maintaining Outline

Module 00: Microsoft SQL Server 2008-Designing and Maintaining Online Training - Course Introduction

Module 01: Designing a SQL Server Instance and a Database Solution

• Design for CPU, Memory, and Storage Capacity Requirements
• Design SQL Server Instances
• Design Physical Database and Object Placement

Module 02: Design Migration

• Migration
• Consolidation
• Upgrade

Module 03: Designing a Database Server Security Solution

• Design Instance Authentication
• Design Instance-Level Security Configurations
• Design Database, Schema, and Object Security Parameters
• Lab: Implementing Database Security

Module 04: Design a Security and Audit Plan

• Design a Security Policy and an Audit Plan
• Design an Encryption Strategy

Module 05: Designing a Database Solution for High Availability

• Design a Failover Clustering Solution
• Design Database Mirroring
• Lab: Implementing Database Mirroring

Module 06: Replication

• Design a High-Availability Solution that is Based on Replication
• Design a High Availability Solution that is Based on Log Shipping

Module 07: Designing a Backup and Recovery Solution

• Design a Backup Strategy
• Design a Recovery Strategy
• Design a Recovery Test Plan
• Lab: Backup and Recover the Database

Module 08: Designing a Monitoring Strategy

• Design a Monitoring Solution at the Operating System Level
• Design a Monitoring Solution at the Instance Level

Module 09: Design a Solution to Monitor Performance

• Instance Performance
• Concurrency
• DAC
• Lab: Using Dedicated Administrator Connection (DAC)

Module 10: Performance Studio

• Design a Tuning Solution using Performance Studio
• Identify Tuning Criteria
• Assign Tuning Solution Goals

Module 11: Designing a Maintenance Strategy

• Design a Maintenance Strategy for Database Servers
• Design a Solution to Govern Resources

Module 12: Resource Governor

• Monitor CPU
• Monitor Response Times
• Assign Resource Governor to Users

Module 13: Designing Policy-Based Management

• Design a Data Compression Strategy
• Design a Management Automation Strategy
• Lab: Defining a Data Compression Strategy

Module 14: Designing Strategy for Data Distribution

• Administer SQL Server Integration Services (SSIS) Packages
• Design a Strategy to Use Linked Servers
• Design a Replication Strategy for Data Distribution

Module 15: Data Replication

• Publisher
• Subscriber
• Agent

Module 16: Microsoft SQL Server 2008-Designing and Maintaining Online Training - Course Summary

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Prerequisites

You need to have an IT background, six months of DBA experience, and have completed Microsoft SQL Server 2008-Implementing. If you do not have this experience, we recommend the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Microsoft SQL Server 2008-Implementing

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Hardware/Software Requirements

Hardware:

• Windows 2008 Server or above
• 4 GB Memory
• 10 GB Free disk space

Software:

• Microsoft® SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals

 

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Objectives

As a result of taking this Microsoft online training course, you will be able to:

• Design SQL Server instances
• Create physical databases and object placement
• Design a high availability solution
• Implement a replication strategy for data distribution

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597

Certification

Microsoft SQL Server 2008-Designing and Maintaining online training course will prepare you for taking the Microsoft's Exam 70-433: TS: Microsoft SQL Server 2008: Database Development. This course is mapped to Microsoft's official curriculums 6231, 6232, and 2778. Once you pass your exam you have completed the requirements for the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development.

For more information about the exam requirements or locations and pricing, select the links located in the related training section for this course.

For more information, contact us or call 1-877-546-4446

Start Learning Microsoft SQL Server 2008-Designing and Maintaining Today!

List Price: $700 Your Price: $597