#2780 Maintaining a Microsoft SQL Server 2005 Database

Академия -> Курсы -> Базы данных ->#2780 Maintaining a Microsoft SQL Server 2005 Database

Описание курса

Назначение курса

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

Подготовка

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

Цель курса

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

Материалы по курсу

Слушателям выдаются учебные материалы, авторизованные Microsoft.

По окончании курса слушатели получают сертификат компании Microsoft международного образца.

Программа курса

Module 1: Installing and Configuring SQL Server 2005

Preparing to install SQL Server. Installing SQL Server. Managing a SQL Server 2005 Installation.

Module 2: Managing Databases and Files

Planning databases. Creating databases. Managing databases.

Module 3: Disaster Recovery

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.

Module 4: Managing Security

Overview of SQL Server Security. Protecting the Server Scope. Protecting the Database Scope. Managing Keys and Certificates in SQL Server.

Module 5: Monitoring SQL Server

Viewing Current Activity. Using System Monitor. Using SQL Server Profiler. Using DDL Triggers. Using Event Notifications.

Module 6: Transferring Data

Overview of Data Transfer. Introduction to SQL Server Integration Services Using SQL Server Integration Services. Features of SQL Server Integration Services.

Module 7: Automating Administrative Tasks

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.

Module 8: Implementing Replication

Overview of Replication Implementing Replication. Configuring Replication in Some Common Scenarios.

Module 9: Maintaining High Availability

Introduction to High Availability. Implementing Server Clustering. Implementing Database Mirroring Implementing Log Shipping. Implementing Peer-to-Peer Replication.

Академия -> Курсы -> Базы данных ->#2780 Maintaining a Microsoft SQL Server 2005 Database