Microsoft SQL Server 2005: Maintaining a Microsoft SQL Server 2005 Database

Course Overview

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

Some of the dates shown are delivered using the Mentor method, and the price varies to reflect this. This uses a combination of learning tools and skills and progress is overseen by a mentor working with your personal needs and learning objectives. The dates shown for this course are week commencing dates for each location. Delegates may choose which flexible combination of days they attend from these weeks. Please contact our training specialists for more details.

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

Related Courses

• Microsoft SQL Server 2005: Updating your Administration Skills to Microsoft SQL Server 2005
• Microsoft SQL Server 2005: Designing Microsoft SQL Server 2005 Infrastructure and Services
• Microsoft SQL Server 2005: Designing Security for Microsoft SQL Server 2005
• Microsoft SQL Server 2005: Designing a Reporting Solution Archicture using MS SQL Server 2005
• Microsoft SQL Server 2005: Implementing a SQL Server Database (5 day)
• Microsoft SQL Server 2005: MCITP Developer: Designing Server -side Solutions
• Microsoft SQL Server 2005: MCITP Developer: Designing Databases
• Microsoft SQL Server 2005: MCITP Developer: Tuning and Optimising Queries
• Microsoft SQL Server 2005: MCITP Administrator: Designing High Availability Solutions
• Microsoft SQL Server 2005: MCITP Administrator: Administering and Automating Databases and Services

Audience

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

Skills Gained

After completing this course, students will be able to:

• Install and configure SQL Server 2005.
• Manage database files.
• Backup 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.

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.

Course Outline

Installing and Configuring SQL Server 2005

• Installing SQL Server 2005
• Managing a SQL Server 2005 Installation
• Performing an Installation
• Managing SQL Server
• Preparing to Install SQL Server

Managing Databases and Files

• Viewing Database Metadata
• Creating a Database
• Monitoring and Managing Filegroup Usage

Disaster Recovery

• Implementing a Backup Strategy
• Performing Online Restore Operations
• System Database and Disaster Recovery
• Restoring User Databases
• Backing Up User Databases
• Planning a Backup Strategy
• Recovering Data from Database Snapshots

Managing Security

• Protecting the Database Scope
• Creating and Managing Users
• Using a Certificate to Protect Data
• Managing Keys and Certificates in SQL Server
• Protecting the Server Scope
• Overview of SQL Server Security
• Creating Logins and Assigning Server-Scope Permissions

Monitoring SQL Server

• Monitoring SQL Server Performance
• Using System Monitor
• Implementing DDL Triggers
• Using SQL Server Profiler
• Using DDL Triggers
• Tracing SQL Server Activity
• Viewing Current Activity
• Using Event Notifications

Transferring Data

• Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data
• Deploying an SSIS Package
• Creating an SSIS Package
• Features of SQL Server Integration Services
• Using SQL Server Integration Services
• Introduction to SQL Server Integration Services
• Overview of Data Transfer

Automating Administrative Tasks

• Managing SQL Server Agent Security
• Managing Multiple Servers
• Creating Alerts
• Automating Administrative Tasks in SQL Server 2005
• Creating Jobs and Operators
• Configuring the SQL Server Agent

Implementing Replication

• Overview of Replication
• Configuring Replication in Some Common Scenarios
• Creating a Subscription
• Implementing Replication
• Creating a Publication
• Implementing HTTP Merge Replication

Maintaining High Availability

• Implementing Peer-to-Peer Replication
• Configuring Database Mirroring to Support Failover
• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Implementing Log Shipping
• Implementing Distributed High Availability

 

Microsoft SQL Server 2005: Maintaining a Microsoft SQL Server 2005 Database / MS2780 (M2780, MOC 2780)

Request availability or enquire by clicking a date: