2780 - Maintaining a Microsoft SQL Server 2005 Database

CLASS DATE(s):
9/13/2010 - 9/17/2010
12/6/2010 - 12/10/2010

COURSE LENGTH: 5 Days

COURSE COST: $2495*

COURSE TIMES: 8:30am - 4:00pm


print
register

COURSE OVERVIEW

This 5-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

*Course Cost does not include books. Please contact a VTEC Account Manager for details.

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Those interested in becoming a Microsoft Certified Technology Specialist are also encouraged to enroll in this course. A MCTS is defined as a technology specialist interested in learning about, assessing skills, using reference products, or taking exams to prove his or her knowledge/skills/experience related to Microsoft's SQL Server 2005.

Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.

COURSE TOPICS:

Preparing to install SQL Server

Installing SQL Server

Managing a SQL Server 2005 Installation

Planning databases

Creating databases

Managing databases

Planning a Backup Strategy

Backing Up User Databases

Restoring User Databases

Performing Online Restore Operations

Recovering Data from Database Snapshots

System Database and Disaster Recovery

Overview of SQL Server Security

Protecting the Server Scope

Protecting the Database Scope

Managing Keys and Certificates in SQL Server

Viewing Current Activity

Using System Monitor

Using SQL Server Profiler

Using DDL Triggers

Using Event Notifications

Overview of Data Transfer

Introduction to SQL Server Integration Services

Using SQL Server Integration Services

Features of SQL Server Integration Services

Automating Administrative Tasks in SQL Server 2005

Configuring the SQL Server Agent

Creating Jobs and Operators

Creating Alerts

Managing Multiple Servers

Managing SQL Server Agent Security

Overview of Replication

Implementing Replication

Configuring Replication in Some Common Scenarios

Introduction to High Availability

Implementing Server Clustering

Implementing Database Mirroring

Implementing Log Shipping

Implementing Peer-to-Peer Replication