Microsoft SQL Server 2008-Implementing

View Your Course Transcript

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

Your Price: $695

Video Title	Minutes
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
Total:	6 hours 20 minutes

Start Learning Microsoft SQL Server 2008-Implementing Today!

Your Price: $695

Course Materials

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

• Student Guide
• Lab Setup and Exercise Guide

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

List Price: $995 Your Price: $695

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.

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

• Course: Microsoft SQL Server 2008-Designing and Maintaining
• Podcast: Differences Between SQL Server 2005 and SQL Server 2008
• Podcast: SQL Server 2008 Agent Jobs
• Podcast: SQL Server 2008 Database Engine Tuning Advisor
• Podcast: SQL Server 2008 New Features
• Podcast: SQL Server 2008 Recovery Models

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

Start Learning Microsoft SQL Server 2008-Implementing Today!

List Price: $995 Your Price: $695

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!

List Price: $995 Your Price: $695

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:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL

 

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

Start Learning Microsoft SQL Server 2008-Implementing Today!

List Price: $995 Your Price: $695

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

List Price: $995 Your Price: $695

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!

List Price: $995 Your Price: $695

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