Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс

#2780 Maintaining a Microsoft SQL Server 2005 Database

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

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

Записаться на курс
Продолжительность: 5 дн.
Стоимость: 25 000 р.

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

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

  
Компьютерная Академия СофтДжойс
   Ваш e-mail: 
Компьютерная Академия СофтДжойс
 
группа вКонтакте Яндекс.Метрика