• Advance Your Career Today
  • Learn New Skills
  • Save Money
  • Save Time
  • Get Certified
  • Get Promoted
  • Learn More
  • Advance Your Career Today

Microsoft SQL Server 2008-Designing and Maintaining Enroll Today!

Select The Package That's Right for You
Standard Deluxe Premium
Videos
1 Year Access to Course
Transcript
Course Materials
Instructors Answer Your Questions
Course Completion Certificate
$195 $425 $695
Add to Cart Add to Cart Add to Cart

Microsoft SQL Server 2008-Designing and Maintaining

Key Course Benefits

  • Achieve Workplace Success by Learning from Real World Experts
  • Learn and Implement New Skills Faster With Real World Examples
  • Take High Quality Classroom Courses Without the Hassles of Travel
  • Student Guide Makes it Easy for You to Take Notes and Increase Learning
  • Course Demos and Exercises Help You Learn More
  • Eliminate Scheduling Conflicts by Training Anytime 24/7 for 1 year
  • Video Training with Materials, Exercises, and Instructor Support Maximizes Learning
  • 1 Year Course Access Gives You Time to Learn and Master Concepts
  • Use Your Course Completion Certificate to Build Your Resume
  • Responsive Customer Service Makes Independent Learning Easy and Smooth
  • Save Money and Learn More

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

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
Course Survey
Total: 5 hours 51 minutes

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

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

Course Purchase Options

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.

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:

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

Related Training

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

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

Course Purchase Options

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:

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!

Course Purchase Options

Course Materials

Want to be able to access these helpful materials? Contact Us!

  • Student Guide
  • Lab Setup and Exercise Guide

Important 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!

Course Purchase Options

When you purchase a Premium course from GogoTraining, you can submit comments or questions to our expert instructors.

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

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

Course Purchase Options

System Requirements

Hardware:

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

Software:

 

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

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

Course Purchase Options

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!

Course Purchase Options

When you purchase a Deluxe or Premium course from GogoTraining, you can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript, or print a course completion certificate.


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

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

Course Purchase Options

We show that you have been logged out, probably due to automatic session limits. Please Login to continue viewing content.

Sign up today for your FREE GogoTraining account to access hundreds of free resources.

Security Question

Answer this question to complete your registration.

Signing up for a FREE account on GogoTraining is?

FREE
$10000
FREE
$100
$10000
$10
$10
FREE
$100
$10000
$100
$10