Introduction

This five-day instructor-led course provides students with the knowledge and skills 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.

Prerequisites

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.

In addition, it is recommended, but not required, that students have completed:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2779: Implementing a Microsoft SQL Server 2005 Database.

Course Outline

Module 1: Installing and Configuring SQL Server 2005

This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

Lab 1: Installing and Configuring SQL Server 2005

• Performing an Installation
• Managing SQL Server

Module 2: Managing Databases and Files

This module explains how to manage databases and files.

Lab 2: Managing Databases and Files

• Creating a Database
• Monitoring and Managing Filegroup Usage
• Viewing Database Metadata

Module 3: Disaster Recovery

This module explains how to plan and implement a backup and restore strategy.

Lab 3: Disaster Recovery

• Implementing a Backup Strategy
• Restoring and Recovering a Database
• Performing Piecemeal Backup and Restore Operations
• Restoring the master Database

Module 4: Managing Security

This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Lab 4: Managing Security

• Creating Logins and Assigning Server-Scope Permissions
• Creating and Managing Users
• Using a Certificate to Protect Data

Module 5: Monitoring SQL Server

This module explains how to monitor SQL Server performance and activity.

Lab 5: Monitoring SQL Server

• Monitoring SQL Server Performance
• Tracing SQL Server Activity
• Implementing DDL Triggers

Module 6: Transferring Data

This module explains how to transfer and transform data.

Lab 6: Transferring Data

• Creating an SSIS Package
• Deploying an SSIS Package
• Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data

Module 7: Automating Administrative Tasks

This module explains how to use the SQL Server Agent to automate administrative tasks.

Lab 7: Automating Administrative Tasks

• Configuring SQL Server Agent
• Creating Operators and Jobs
• Creating Alerts

Module 8: Implementing Replication

This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Lab 8: Implementing Replication

• Creating a Publication
• Creating a Subscription
• Implementing HTTP Merge Replication

Module 9: Maintaining High Availability

This module explains how to implement high availability technologies with SQL Server 2005.

Lab 9:

• Configuring Database Mirroring to Support Failover
• Implementing Distributed High Availability

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Microsoft Software Assurance

What is Software Assurance?

Software Assurance (SA) provides an easy way for Microsoft's Volume Licensing customers to stay current with the latest and most innovative Microsoft products. Under the SA program, customers acquire the right to install any new release of products covered in the agreement during the term of their coverage. Companies can acquire tomorrow's technology at today's prices and have the ability to spread payments annually instead of paying up front. Visit www.microsoft.com/licensing to learn more about Microsoft's licensing programs.

What is the SA Enhancement Offering?

The SA Enhancement Offering is designed to increase customer satisfaction by giving customers more value from Software Assurance and a better Microsoft product experience. The Enhancement Offering contains tools, training, and support as well as additional licensing benefits which meet different customer needs across product segments and across customer segments. The many benefits include:

• Training vouchers redeemable
• Employee Purchase Program
• Home Use Program
• Problem Resolution Support
• TechNet Subscription
• Technology & Tools

What is the Software Assurance (SA) Training Voucher Program?

Qualifying organizations that purchase Software Assurance receive training credits from Microsoft. Each training credit is worth the equivalent of one day of training at Networking Technologies™. Customers can redeem these credits for SA Training Vouchers for select Microsoft courses from «Networking Technologies»™.

How to Get Started?

Contact the individual in your organization responsible for software purchases to verify that you purchased volume licensing with Software Assurance. We can help you activate your benefits and administer the training vouchers. To register for a training contact Education Center «Networking Technologies»™ directly via e-mail edu@tex.kiev.ua