Início

Página Principal

Cursos

Citrix Gestão Java Linux Microsoft Novell PHP Virtualização Voip Web

Formações

Gestão de TI Infra de Redes Java Linux Microsoft PHP VoIP Web

Certificações

Cases Linux Microsoft Notícias

Alunos

Cases Fotos das Turmas

Produtos

Licenciamento

Eventos

Academics Fotos de Eventos Palestras RoadShow Seminários

Promoções

Produtos Suporte Treinamentos

Oportunidades

Curriculum Vagas

Imprensa

Mídia

Contato

Canal Direto

Carga Horária: 8 Horas

Conteúdo:
This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information. Course Outline Module 1: Managing and Automating Databases and Servers
This module provides you with the guidelines and considerations for planning automated systems for databases and servers. This module also provides you with the knowledge required to maintain a run book.
Lessons
• Planning an Automated System for Database Maintenance.
• Planning an Automated System Server Maintenance.
• Documenting Administration and Automation Information.

Lab 1: Managing and Automating Databases and Servers
• Creating Maintenance Plans.
• Creating Database Change Control Procedures
. • Configuring And Using the SQL H2 Tool.
After completing this module, students will be able to:
• Plan an automated system for database maintenance.
• Plan an automated system for server maintenance.
• Document administration and automation information in a run book.

Module 2: Managing SQL Server Supporting Services
This module introduces the concept of SQL Server Integration Services (SSIS) packages and provides the guidelines to deploy and manage SSIS packages. This module also provides the guidelines and considerations for maintaining replication and reporting services.
Lessons
• Managing SSIS Packages.
• Managing Replication.
• Managing Reporting Services.
Lab 2: Managing SQL Server Supporting Services
• Moving Packages Between Database Servers.
• Initializing a Transactional Subscription From a Backup
. • Configuring Reporting Services.
After completing this module, students will be able to:
• Manage SSIS packages.
• Manage replication.
• Manage reporting services.


Pre-Requisitos:
In addition, it is recommended, but not required, that students have completed:
• Course 2779, Implementing a Microsoft SQL Server 2005 Database.


Diferencial:
*
Desenvolvedor do Curso:
Microsoft

Cursos de Pre-Requisitos:
MS2779 - Obrigatorio