Microsoft SQL Server 2005 Administration Training Classes

Are you ready to learn how to administer Microsoft SQL Server 2005? If you have existing relational database skills and are ready to learn about the enhancements that SQL Server 2005 offers as well as how to use them to their fullest, this course is for you. In fact, we can show you all you need to know in just five days of instruction. This Microsoft SQL Server 2005 Administration training class is an instructor-led course held at our facility (or yours if you choose our onsite option) that takes you deep into the content.

You will learn about installing and upgrading to Microsoft SQL Server 2005 as well as how this switch will benefit you as the Database Administrator. The new features are a tremendous enhancement over previous versions and our instructor will help you fully explore them.

The SQL Server 2005 Admin class allows experienced SQL Server developers and administrators prepare for upgrading their existing systems. It also teaches you about the extensive new technologies and features including Online Restores, Database Mirroring, Online Index Operations, Reporting Services, Database Mail, SSIS - DTS redesign, SQL Server Management Studio, SQL Profiler, Database Engine Tuning Advisor, Native Data Encryption, Security models, and quite a bit more.

If you are on the certification track, the Microsoft SQL 2005 training class also prepares you for the (MCTS) Microsoft Technology Specialist: SQL 2005 certification exam as well as the (MCITP) Microsoft IT Professional: Database Administrator certification exam.

onsider the Onsite Microsoft SQL Server 2005 Administration training class if your group has over six students. We can send our instructor to your facility as a cost effective alternative for larger groups.

Number of Days:	5 Days
Course Price:	$2,895

What You'll Learn

By taking this SQL 2005 training class, you will learn about SQL Server 2005's new features and enhancements, the SQL Server Management Studio, scheduling administrative tasks, supporting Online Index Operations, implementing data partitioning and snapshot isolation, performing mirrored backups and online restores, using the new security model, native data encryption, replication enhancements, database mirroring techniques, setting up and using Reporting Services, and using the latest version of DTS (Data Transformation Services). This course is also a preparatory class for the MCTS: SQL Server 2005 and the MCITP: Database Administrator certification exams.

Who Needs to Attend

This is the perfect course for SQL 2000 (or similar relational database) database administrators who want to upgrade their skills as well as take advantage of the capabilities of SQL Server 2005.

Course Schedule:

View Class Schedule
Request Onsite Microsoft SQL Training

Course Outline:

New Features of SQL Server 2005
SQL Server Management Studio
Creating and Managing Databases and Database Files
Scheduling Administrative Tasks
Performance and Tuning
Database Backup
Database Recovery
Protecting and Distributing Your Data
Security
SQL Server Integration Services (SSIS)
Set Up and Use Reporting Services

Locations:

San Francisco, CA
Rockville, MD
Ottawa, ONT
Toronto, ONT
Orlando, FL
Washington, DC
New York, NY
Los Angeles, CA
Chicago, IL
Houston, TX
Dulles, VA
Raleigh, NC
Dallas, TX
Boston, MA
Sacramento, CA
San Jose, CA
Morristown, NJ
Atlanta, GA
Philadelphia, PA
Orlando, FL
Denver, CO