On-line training course catalogue
Maintaining a Microsoft SQL Server 2005 Database
Type of course: Classroom
| Fee | £1545 |
|---|---|
| Days | 5 |
| Course code | MS2780 |
| Location | Nov | Dec | Jan | Feb | Mar | Apr |
|---|---|---|---|---|---|---|
| Altrincham Manchester | |- | |- | |19 | |16 | |16 | |- |
| Hinckley East Midlands | |24 | |- | |- | |2 | |9 | |- |
| Leeds Yorkshire | |- | |- | |26 | |- | |9 | |- |
| London King William Street | |- | |- | |- | |2 | |2 | |- |
| Washington Tyne and Wear | |- | |1 | |19 | |- | |2 | |27 |
Booking: click a course date | View location: click location name | Print this page | Download as Word document |
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 is intended for IT Professionals who want 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:
- MS50027: Querying and Processing SQL Server 2005 Data with SQL Statements
- MS2779: Implementing a Microsoft SQL Server 2005 Database.
Delegates will learn how 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.
Course Outline
- Module 1: Installing and Configuring SQL Server 2005
- Module 2: Managing Databases and Files
- Module 3: Disaster Recovery
- Module 4: Managing Security
- Module 5: Monitoring SQL Server
- Module 6: Transferring Data
- Module 7: Automating Administrative Tasks
- Module 8: Implementing Replication
- Module 9: Maintaining High Availability
Related Certifications
This course forms part of the following certification track(s):
Link to this page: http://www.xpertise.co.uk/MS2780
Xpertise – Maintaining a Microsoft SQL Server 2005 Database training courses
Xpertise provides Maintaining a Microsoft SQL Server 2005 Database training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.
Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.