From Our Students

"I just want to let you know that your professionalism, sense of caring, and listening to the needs of someone who lost their job is deeply appreciated. The job that I now have would not have been possible had I not passed the PMP exam."

-Hector A. Fundora

See more student testimonials

Training That Changes Your Life

We've helped hundreds of people just like you get back to work. Attend our seminar to learn how to get the grants to pay for training.
Register now for this free two-hour class

About MicroTrain

MicroTrain Technologies gives you the computer skills and knowledge you need by applying the perfect combination of expert hands-on instruction, superior customer service and convenient training locations.

Find your classes now:

2780 Maintaining a Microsoft SQL Server 2005 Database Training | Chicago

Summary

Course Logistics

This is a 5 day course
Pricing
- Instructor Led: $2195
- Onsite: Call for details
View our facilities
Ask a Question

This course provides students with product knowledge and skills needed 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.

About This Course

Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database. At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability. Pre-requisite(s):
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

Outline

Lesson 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.

Lesson 2: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.

Lesson 3: Managing Security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Implementing Cryptography in SQL Server.

Lesson 4: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.

Lesson 5: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.

Lesson 6: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.

Lesson 7: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security

Lesson 8: Maintaining High Availability
Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.

Lesson 9: Introduction to Replication
Overview of Replication.

Course Schedule

Date	Time	Days
Chicago, IL
09/27/10 - 10/01/10	9:00am-5:00pm	Mon Tue Wed Thu Fri
03/14/11 - 03/18/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
06/13/11 - 06/17/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
09/12/11 - 09/16/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
11/14/11 - 11/18/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
Lombard, IL
10/18/10 - 10/22/10	9:00am-5:00pm	Mon Tue Wed Thu Fri
02/14/11 - 02/18/11	9:00am-5:00pm	Mon Tue Wed Thu
05/09/11 - 05/13/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
08/08/11 - 08/12/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
10/24/11 - 10/28/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
Deerfield, IL
01/17/11 - 01/21/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
04/11/11 - 04/15/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
07/11/11 - 07/15/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
09/26/11 - 09/30/11	9:00am-5:00pm	Mon Tue Wed Thu Fri
12/12/11 - 12/16/11	9:00am-5:00pm	Mon Tue Wed Thu Fri