CourseMonster
To speak to a training advisor please call
0800 40 848 40
training@coursemonster.co.uk
Browse Microsoft Training Courses

Maintaining a Microsoft SQL Server 2005 Database

Course Code: MS2780 (Also known as: M2780, MOC 2780)      Days: 5
Show all Microsoft Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
London (WC1) 22/03/10 £ 1,395
London (WC1) 12/04/10 £ 1,395
London (WC1) 26/04/10 £ 1,395
London (WC1) 10/05/10 £ 1,395
London (WC1) 24/05/10 £ 1,395
London (EC1) 07/06/10 £ 1,495
London (WC1) 14/06/10 £ 1,395
London (WC1) 28/06/10 £ 1,395
London (WC1) 12/07/10 £ 1,395
London (WC1) 26/07/10 £ 1,395
London (E1) 09/08/10 £ 1,495
London (E1) 23/08/10 £ 1,495
Greater London
London (EC3) 22/03/10 £ 1,550
London (EC3) 19/04/10 £ 1,550
England
Berkshire
Reading (RG1) 10/05/10 £ 1,495
Reading (RG1) 05/07/10 £ 1,495
Wokingham (RG41) 24/05/10 £ 1,495
Wokingham (RG41) 26/07/10 £ 1,495
Bristol
Almondsbury (BS32) 10/05/10 £ 1,495
Almondsbury (BS32) 02/08/10 £ 1,495
Buckinghamshire
Milton Keynes (MK9) 12/04/10 £ 1,495
Milton Keynes (MK9) 16/08/10 £ 1,495
Devon
Exeter (EX2) 26/04/10 £ 1,495
Dorset
Poole (BH17) 19/04/10 £ 1,450
Hampshire
Fareham (PO16) 17/05/10 £ 1,495
Leicestershire
Hinckley (LE10) 15/03/10 £ 1,495
Hinckley (LE10) 10/05/10 £ 1,495
Hinckley (LE10) 12/07/10 £ 1,495
Manchester (Greater)
Manchester (M1) 15/03/10 £ 1,495
Manchester (M1) 26/04/10 £ 1,495
Manchester (M1) 10/05/10 £ 1,495
Manchester (M1) 24/05/10 £ 1,495
Manchester (M1) 21/06/10 £ 1,495
Manchester (M1) 23/08/10 £ 1,495
Merseyside
Liverpool (L3) 19/04/10 £ 1,195
Midlands (West)
Birmingham (B3) 15/03/10 £ 1,495
Birmingham (B3) 22/03/10 £ 1,495
Birmingham (B3) 19/04/10 £ 1,495
Birmingham (B3) 26/04/10 £ 1,495
Birmingham (B3) 17/05/10 £ 1,495
Birmingham (B3) 24/05/10 £ 1,495
Birmingham (B3) 14/06/10 £ 1,495
Birmingham (B3) 21/06/10 £ 1,495
Birmingham (B3) 28/06/10 £ 1,495
Birmingham (B5) 05/07/10 £ 1,495
Somerset
Bath (BA1) 19/04/10 £ 1,550
Tyne and Wear
Washington (NE38) 24/05/10 £ 1,495
Yorkshire (West)
Leeds (LS12) 22/03/10 £ 1,495
Leeds (LS2) 12/04/10 £ 1,495
Leeds (LS1) 19/04/10 £ 1,495
Leeds (LS2) 10/05/10 £ 1,495
Leeds (LS2) 07/06/10 £ 1,495
Leeds (LS1) 12/07/10 £ 1,495
Scotland
Aberdeenshire
Aberdeen (AB10) 05/07/10 £ 1,495
Edinburgh
Edinburgh (EH7) 19/04/10 £ 1,495
Edinburgh (EH7) 17/05/10 £ 1,495
Edinburgh (EH12) 07/06/10 £ 1,495
Edinburgh (EH7) 14/06/10 £ 1,495
Edinburgh (EH7) 28/06/10 £ 1,495
Glasgow
Glasgow (G1) 22/03/10 £ 1,495
Glasgow (G2) 24/05/10 £ 1,495
Wales
Glamorgan (South)
Cardiff (CF24) 12/04/10 £ 1,495
Cardiff (CF24) 14/06/10 £ 1,495
Europe / International
Leeds - Regus-Princes Exchange 06/09/10 £ 1,495
Manchester Abbey Business Centre 16/08/10 £ 1,495
St Helier
St Helier 14/06/10 £ 1,695
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
No suitable dates?
I'd like a different date/location

Please click above and we will take care of the rest.

I’d like an onsite/bespoke course

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

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.

This course has been classified as IT Technical Training.

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 techniques 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.

Contact us to also find out about onsite/in-house delivery.

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


How to make a booking for the MS2780 course
 

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.