M2733: Updating Your Database Admininstration Skills to MS SQL Server 2005

Location:
Open registration also available as in-company
Costs:
At request
Total time:
3 days
Logo Perpetual Solutions
Get more info (free!)

Tip: Receive more info about the programme, starting dates, location and prices. Or request proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course M2733: Updating Your Database Admininstration Skills to MS SQL Server 2005 at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

Submit your review
 
Schedule:
Daytime
Run time:
3 days
Location type:
Open, In-house / Incompany
Region(s):
London
Price info:
no VAT information
At request

price, completion, maximum participants, and starting dateplaces are unknown for this course.

Prerequisites:

Before attending this course, students must have:

MCDBA certification or equivalent knowledge.

Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
Knowledge of SQL Server 2000/7.0
Database and server architecture.
Installation and configuration.
Database security.
Database recovery (backup and restore).
SQL Server technologies used for database availability such as log shipping and clustering.
Job automation.
Database and server monitoring.
Troubleshooting.
Replication.

In addition, it is recommended, but not required, that students have completed:

Course MS2072, Administering a Microsoft SQL Server 2000 Database

Course Description:

This course provides deleg…

Read the complete description

Get more info (free!)
More information

Description

Prerequisites:

Before attending this course, students must have:

MCDBA certification or equivalent knowledge.

Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
Knowledge of SQL Server 2000/7.0
Database and server architecture.
Installation and configuration.
Database security.
Database recovery (backup and restore).
SQL Server technologies used for database availability such as log shipping and clustering.
Job automation.
Database and server monitoring.
Troubleshooting.
Replication.

In addition, it is recommended, but not required, that students have completed:

Course MS2072, Administering a Microsoft SQL Server 2000 Database

Course Description:

This course provides delegates with an upgrade path to SQL Server 2005 offering the skills required to administer and troubleshoot.

This course includes the following modules:

Overview of SQL Server 2005 Architecture

  • Overview of SQL Server 2005
  • System Enhancements for Administrators

Installing SQL Server 2005

  • Preparing to Install SQL Server 2005
  • Performing a SQL Server 2005 Installation
  • Maintaining a SQL Server 2005 Installation

SQL Server 2005 Administrative Tools

  • Using SQL Server Management Studio
  • Using SQL Server Computer Manager
  • Using the sqlcmd Utility
  • Using the SQL Management Objects

Administering SQL Server 2005

  • Creating the Personnel database.
  • Populating the Personnel database.
  • Backing Up the Personnel Database.

Monitoring SQL Server 2005

  • Using SQL Profiler
  • Using DDL Triggers
  • Using Event Notifications
  • Using Metadata Views

Maintaining Databases and Indexes

  • Managing Indexes
  • Using the Database Tuning Advisor

Disaster Recovery

  • Disaster Recovery in SQL Server 2005
  • Using Database Snapshots
  • Backup and Restore Operations

Data Availability in SQL Server 2005

  • Introduction to Data Availability
  • Introduction to Database Mirroring
  • Configuring Database Mirroring

SQL Server 2005 Replication

  • Overview of Replication Enhancements
  • New Types of Replication
  • Configuring Replication

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

Submit your review

Submit your review

Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

Were you a participant yourself?
Email address Use another validation method
Only necessary to prevent misuse. We will never share your info with third parties.
(optional)
(optional)
By submitting this form, I agree to the terms of service and the privacy policy

Where should we send the information?

Gender
(optional)
Next

How can we reach you?

(optional)
(optional)
Previous

More courses within this subject:

Compare 25,580 training courses in subjects like Microsoft SQL Server

Subscribe to our newsletter?

Receive news, tips, articles, interviews and education on personal development each month!

Follow us on: Facebook Twitter LinkedIn

Show courses by category

Springest Newsletter

Read all newsletters

Follow us

Grow with us

About Springest

Other Countries

© 2008 – 2013 Springest