SQL Server 2005 > MOC 2789: Administering and Automating SQL Server 2005

MOC 2789: Administering and Automating SQL Server 2005


MOC 2789: Administering and Automating SQL Server 2005

PACKAGE INCLUDES

  • 2 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs
  • Comprehensive, understandable, and reusable as reference material
  • Microsoft Authorized MeasureUp Exam Simulation
  • Focused on practical solutions to real-world development problems


    • Single User CD Course
    £ 148
    Single User Online Course
    £ 118
    Multi User CD Course
    £ 296

    COURSE INTRODUCTION

    Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

    This 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. It is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

    Course Outline


    Module 1 - Managing and Automating Databases and Servers

    Lesson 1: An Automated System for Database Maintenance
    Automating Database Administration
    Using SQL Server Agent
    Assessing System Dependencies on the Database
    Identifying Maintenance Needs
    Automating Database Maintenance Plans
    Lesson 2: An Automated System for Server Maintenance
    Implementing Application Database Changes
    Implementing Windows and SQL Server Updates
    Lesson 3: Administration and Automation Information
    Maintaining a Run Book
    The SQL Health and History Tool
    Additional Automation Tools
    Lab 1 Introduction
    Module 1 - Review

         		 

    Module 2 - Managing SQL Server Supporting Services

    Lesson 1: SSIS Packages
    SSIS Packages
    Monitoring SSIS Packages
    Lesson 2: Replication
    Choosing Replication Monitoring Tools
    Lesson 3: Reporting Services
    Managing the Report Server Configuration
    Managing Report Services Databases
    Managing Report Servers
    Module 2 - Review
    Page Execution time is 6.25 seconds.