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

Black Friday Special - 3 Ways to Save + Cash Back

  • Standard Courses $49: Use Coupon Code BLACKFRIDAY49 - 5 Amazon Dollars with every course
  • Deluxe Courses $99: Use Coupon Code BLACKFRIDAY99 - 10 Amazon Dollars with every course
  • Premium Courses $149: Use Coupon Code BLACKFRIDAY149 - 15 Amazon Dollars with every course
  • Rules: Offer cannot be combined with other offers. Multiple purchases permitted. Amazon gift card given for total purchase. Offer does not apply to Certified IT Asset Management courses. Amazon dollars will be issued by Dec 10, 2014. Special offer is valid through Monday, Dec 1, 2014.

    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 Completion Certificate
    Course Materials
    Instructors Answer Your Questions
    $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
    Need Help Playing Your Videos?
    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

    What should I do if my video will not play?

    There are many things that can affect the quality of your video so we have put together these instructions to help you review all the things that need to be tested in order to trouble-shoot video quality.

    The first thing we want to assure you is that we have done everything possible to make sure that our videos will play well.  Our videos are hosted in the cloud by Akamai.  Akamai has servers around the world to make sure that your videos are sent from the server that is closest to you.  By hosting our videos with Akamai we make sure that you receive the highest video quality. If you are experiencing video buffering or freezing at home or at the office there are a number of things you can do to help us troubleshoot.

    • Buffering: We provide you with three (3) speed choices that you can select when watching a video.  If the video is buffering then the first thing you want to click on a slower speed option found at the bottom of the video window. Try clicking on Medium and Low and see if that allows the video to play without buffering. If it does not, please read through the rest of this FAQ and follow the steps outlined below.
    • Video will not play: In order to play our videos, you have to have Adobe Flash Player installed. If you click on the video and nothing happens, then you do not have Adobe Flash Player installed.  Click on this link to download and install it.
      • If you have Adobe Flash Player installed and your video is not playing, complete the following steps:
        • Go to your course page, select a video, and click play.
        • Once the video begins playing, place your mouse over the video and right click.
        • You will see the several links and the last link has the words “About Adobe Flasher Player xx.xx.xx” (version # you have).
        • Click here , where you will see your version and what is the latest version. You need to have the latest version installed.
        • If you do not have Adobe Flash Player, click here to download and install it.
    • Your Connection Speed: Internet speed needs to be 2.0 Mbps upload and download to successfully watch the videos.  You will want to check and see if your connection speed is 2.0 Mbps or higher.  You can do this by clicking on this link and running a speed test.
    • Jitter and Packet Loss: Your Jitter rate lets us know if your connection speed is consistent while your Packet Loss rate lets us know if your internet connection could be losing pieces of the video.
      • Go to www.pingtest.net to determine if there is any Jitter or Packet Loss on your connection.
      • This is measured by a letter scale with A being the best.
        • If your Packet Loss is below a B, your connection is losing pieces of the video and causing the video to skip.
        • If your Jitter is below a B, your connection speed is very inconsistent and may be changing while you are watching the video which will result in buffering issues.
        • If either of these is the case you will need to contact your internet provider.
    • Ports: You will need to have ports 1935, 443 and 80 open. You can run a port test at this link.
      • If you are watching from work and those ports are not open, check with your IT department.
    • Shared Internet Connection: If you are on a shared internet connection, test playing videos during non-peak hours when usage by others on your network is low.
    • Other things to check:
      • At home or at work, test using different browsers and computers to see if you get the same result.
        • Make sure you have the latest version of the browser you are using.
      • If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset.
      • Try from a different location using a different network.
      • If you are on a wireless connection try a wired solution.
      • If you are on a home network:
        • Test playing the videos when you are the only user on the network.
        • Try by-passing your router to eliminate it as the point of failure. A direct plug from your ISP to your computer will take care of this and will make sure that neither your router nor other users are affecting your connection.
    • Make sure you do not have any other programs open. File sharing and peer to peer sharing programs, even when limited to low bandwidth, can make it almost impossible to stream properly.

    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.

    Which one is a DB2 course?

    Red Had Linux Essentials
    SQL for DB2
    SQL for DB2
    Red Had Linux Essentials
    Google Web Toolkit
    SQL for DB2
    Google Web Toolkit
    AIX Fundamentals
    AIX Fundamentals
    Red Had Linux Essentials
    AIX Fundamentals
    Google Web Toolkit