About This Training Course

"This five-day training 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. "

Subjects Covered

"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 "

Training Course Outcomes

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

Other Information

"This course can also be completed by the Walk-In Classroom Learning method. The New Horizons Walk-In Learning methodology was developed by industry professionals and certified trainers to provide a method of training that combines the least amount of time away from the office, with the most time dedicated to learning what they need to know.

The Walk-In Learning Approach: When students arrive at a New Horizons Walk-In centre, they are greeted by the mentor (a certified trainer with industry expertise) who will be mentoring and guiding them through their training. They are then assigned their own networked workstation containing two monitors. This environment allows for simultaneous access to the lecture delivered via recorded audio and video, and a live lab environment.

Why Walk-In Learning?

Flexible Scheduling: Flexible course schedules allow the student to determine when they attend training. The training schedule can be built around a work schedule so productivity in the workplace is maintained.

Focus on and learn relevant modules: Not every course is entirety relevant to a student’s needs. The Walk-In classroom allows you to focus on modules which are more relevant to the technology environment you work in and to your specific learning needs.

Time away from the office now reduced to ONE day blocks: Traditional ILT (Instructor Led Training) courses involved IT staff taking five continuous days out of the office to attend the course. This impacted the business and service levels. In the Walk-In classroom you can pick the days of training and create a custom attendance schedule to suit your calendar, projects and convenience."