Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Microsoft Training Courses

SQL Server 2005: Updating your Administration Skills to SQL Server 2005

Course Code: MS2733 (Also known as: M2733, MOC 2733)      Days: 3
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
England
Leicestershire
Hinckley (LE10) 26/01/09 £ 1,060
Hinckley (LE10) 02/03/09 £ 1,060
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.

Audience

This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.

Skills Gained

  • Describe the architecture of SQL Server 2005
  • Install SQL Server 2005
  • Use SQL Server 2005 administrative tools and utilities
  • Maintain SQL Server 2005 servers and databases
  • Secure a SQL Server 2005 server and database
  • Monitor SQL Server 2005
  • Implement a Backup and Restore solution for SQL Server 2005
  • Implement a data availability solution with database mirroring or clustering
  • Use enhanced SQL Server 2005 replication features

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 2072, Administering a Microsoft SQL Server 2000 Database.

Course Outline

  • Module 1: Overview of SQL Server 2005 Architecture
  • Module 2: Installing SQL Server 2005
  • Module 3: SQL Server 2005 Administrative Tools
  • Module 4: Monitoring SQL Server 2005
  • Module 5: Maintaining Databases and Indexes
  • Module 6: Securing SQL Server 2005
  • Module 7: Disaster Recovery
  • Module 8: Data Availability in SQL Server 2005
  • Module 9: SQL Server 2005 Replication


How to make a booking for the MS2733 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.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership