Search Courses
Dates for this class:
No dates are available for this class.

Course Details    [choose new course]     [printable version]
Maintaining a Microsoft SQL Server 2005 Database (MOC2780)
Course Number: MOC2780
Category: Database & Collaboration Tools
Duration: 5.00 days
Description

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

Target Audience

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for 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.
Objectives

After completing this course, students will be able to:

  • Install and configure SQL Server 2005.
  • Manage database files.
  • Back up and restore databases.
  • Manage security.
  • Monitor SQL Server.
  • Transfer data into and out of SQL Server.
  • Automate administrative tasks.
  • Replicate data between SQL Server instances.
  • Maintain high availability.
Outline
  • Module 1: Installing and Configuring SQL Server 2005
    • Preparing to install SQL Server
    • Installing SQL Server
    • Managing a SQL Server 2005 Installation
    • Lab 1: Installing and Configuring SQL Server 2005
      • Performing an Installation
      • Managing SQL Server
  • Module 2: Managing Databases and Files
    • Planning databases
    • Creating databases
    • Managing databases
    • Lab 2: Creating and Managing Databases
      • Creating a Database
      • Monitoring and Managing Filegroups
      • Viewing Database Metadata
  • Module 3: Disaster Recovery
    • Implementing a Backup Strategy
    • Restoring and Recovering a Database
    • Performing Piecemeal Backup and Restore Operations
    • Restoring the Master Database
    • Lab 3: Disaster Recovery
      • Implementing a Backup Strategy
      • Restoring Databases
      • Rebuild The Master Database
  • Module 4: Managing Security
    • Overview of SQL Server Security
    • Protecting the Server Scope
    • Protecting the Database Scope
    • Managing Keys and Certificates in SQL Server
    • Lab 4: Managing Security
      • Creating Logins
      • Creating and Managing Users
      • Using a Certificate to Protect Data
  • Module 5: Monitoring SQL Server
    • Viewing Current Activity
    • Using System Monitor
    • Using SQL Server Profiler
    • Using DDL Triggers
    • Using Event Notifications
    • Lab 5: Monitoring SQL Server
      • Monitoring SQL Server Performance
      • Tracing SQL Server Activity
      • Implementing DDL Trigger
  • 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
    • Lab 6: Transferring Data
      • Creating an SSIS Package
      • Deploying an SSIS Package
  • 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
    • Lab 7: Automating Administrative Tasks
      • Configuring SQL Server Agent
      • Creating Operators and Jobs
      • Creating Alerts
  • Module 8: Implementing Replication
    • Overview of Replication
    • Implementing Replication
    • Configuring Replication in Some Common Scenarios
    • Lab 8: Implementing Replication
      • Creating a Publication
      • Creating a Subscription
      • Implementing HTTP Merge Replication
  • Module 9: Maintaining High Availability
    • Introduction to High Availability
    • Implementing Server Clustering
    • Implementing Database Mirroring
    • Implementing Log Shipping
    • Implementing Peer-to-Peer Replication
    • Lab 9: Configuring Database Mirroring

      • Configuring Database Mirroring to Support Failover

      • Implementing Distributed High Availability