• 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-Implementing 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-Implementing

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-Implementing Today!

Video Title Minutes
Need Help Playing Your Videos?
00: Course Introduction 7
01: Installing and Configuring SQL Server 2008 21
02: Configure Additional SQL Server Components 16
03: Maintaining SQL Server Instances 23
04: Define SQL Server Recovery Methods 20
05: Managing SQL Server Security 19
06: Instance Permissions 23
07: Manage Schemas 19
08: Maintaining a SQL Server Database Part 1 17
09: Maintaining a SQL Server Database Part 2 10
10: Database Snapshots 19
11: Performing Data Management Tasks 20
12: Maintaining Indexes 18
13: Monitoring and Troubleshooting SQL Server 22
14: Optimizing SQL Server Performance 18
15: Using Dynamic Management Views 17
16: Use Performance Studio 9
17: Implementing Database Mirroring 16
18: Log Shipping 20
19: Service Broker 15
20: Service Broker Queues 13
21: Sending and Receiving Messages 11
22: Course Summary 7
Course Survey
Total: 6 hours 20 minutes

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

Start Learning Microsoft SQL Server 2008-Implementing Today!

Course Purchase Options

Description

In this Microsoft online training course, you will learn how to install and configure a Microsoft SQL Server 2008 database. Microsoft SQL Server 2008-Implementing online training will cover back-up and recovery methods, and how to configure and design security policies and high availability. You will also learn how to monitor performance for the instance as well as the operating system.

Once you have completed Microsoft SQL Server 2008-Implementing the next course in this series is Microsoft SQL Server 2008-Designing and Maintaining. The Microsoft SQL Server 2008-Designing and Maintaining course will enhance your administration knowledge by discussing how to design and optimize and maintain the SQL server database for high availability and address data distribution. Click here to learn more about Microsoft SQL Server 2008-Designing and Maintaining.

Download the course outline.

Prerequisites

You need to have an IT background and six months of DBA experience. If you do not have this experience, we recommend the following GogoTraining courses:

 

Objectives

As a result of taking this Microsoft SQL server training, you will be able to:

  • Install SQL Server 2008
  • Define SQL Server recovery methods
  • Manage schemas
  • Create and manage database snapshot
  • Backup and recover the database

Related Training

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

Start Learning Microsoft SQL Server 2008-Implementing Today!

Course Purchase Options

Prerequisites

You need to have an IT background and six months of DBA experience. If you do not have this experience, we recommend the following GogoTraining courses:

 

Microsoft SQL Server 2008-Implementing Outline

Module 00: Microsoft SQL Server 2008-Implementing Online Training - Course Introduction

Module 01: Installing and Configuring SQL Server 2008

  • Install SQL Server 2008 and Related Services
  • Configure SQL Server Instances
  • Configure SQL Server Services
  • Lab: Installation

Module 02: Configure Additional SQL Server Components

  • Implement Database Mail
  • Configure Full-Text Indexing

Module 03: Maintaining SQL Server Instances

  • Manage SQL Server Agent Jobs
  • Manage SQL Server Agent Alerts
  • Manage SQL Server Agent Operators
  • Implement the Declarative Management Framework (DMF)

Module 04: Define SQL Server Recovery Methods

  • Bulk Log
  • Simple Log
  • Full Log
  • Lab: Configure Recovery Method

Module 05: Managing SQL Server Security

  • Manage Logins and Server Roles
  • Manage Users and Database Roles

Module 06: Instance Permissions

  • Manage SQL Server Instance Permissions
  • Manage Database Permissions

Module 07: Manage Schemas

  • Manage Schema Permissions and Object Permissions
  • Audit SQL Server Instances
  • Manage Transparent Data Encryption
  • Configure Surface Area
  • Lab: Create Schemas

Module 08: Maintaining a SQL Server Database Part 1

  • Back up Databases
  • Restore Databases
  • Manage and Configure Databases
  • Lab: Backup the Database

Module 09: Maintaining a SQL Server Database Part 2

  • Configure Backups using a Maintenance Plane
  • Configure Backups using a SQL Agent Job

Module 10: Database Snapshots

  • Manage Database Snapshots.
  • Maintain Database Integrity.
  • Maintain a Database by Using Maintenance Plans.
  • Lab: Creating Database Snapshots

Module 11: Performing Data Management Tasks

  • Import and Export Data
  • Manage Data Partitions
  • Implement Data Compression

Module 12: Maintaining Indexes

  • Maintain Indexes
  • Manage Collations

Module 13: Monitoring and Troubleshooting SQL Server

  • Identify SQL Server Service Problems
  • Identify Concurrency Problems
  • Identify SQL Agent Job Execution Problems
  • Locate Error Information

Module 14: Optimizing SQL Server Performance

  • Implement Resource Governor
  • Use the Database Engine Tuning Advisor
  • Collect Trace Data by Using SQL Server Profiler
  • Lab: Gathering performance Information

Module 15: Using Dynamic Management Views

  • Collect Performance data by Using Dynamic Management Views (DMVs)
  • Collect Performance Data by Using System Monitor

Module 16: Use Performance Studio

  • Configure Performance Studio
  • Implement Performance Studio

Module 17: Implementing Database Mirroring

  • Implement Database Mirroring.
  • Implement a SQL Server Clustered Instance
  • Lab: Create a Database Mirror

Module 18: Log Shipping

  • Implement Log Shipping.
  • Implement Replication
  • Lab: Implement Log Shipping

Module 19: Service Broker

  • Service Broker Architecture
  • Service Broker Components
  • Message Types

Module 20: Service Broker Queues

  • Message Queue
  • Creating a Service
  • Creating a Conversation

Module 21: Sending and Receiving Messages

  • Sending Messages
  • Receiving Messages

Module 22: Microsoft SQL Server 2008-Implementing Online Training - Course Summary

 

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

Start Learning Microsoft SQL Server 2008-Implementing 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 Locations and Pricing

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

Start Learning Microsoft SQL Server 2008-Implementing 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-Implementing 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-Implementing Today!

Course Purchase Options

Certification

Microsoft SQL Server 2008-Implementing course will prepare you for taking the Microsoft's Exam 70-433:TS: Microsoft SQL Server 2008: Database Development. This online training course is mapped to Microsoft's official curriculum 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-Implementing 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-Implementing 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 install it, click here 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 on this link, 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 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 NOT the name of an IT Programming language?

Android Programming
C Programming
A swimming pool
Android Programming
A swimming pool
Perl Programming
A swimming pool
C Programming
Perl Programming
Perl Programming
Android Programming
C Programming