• Microsoft Gold Certified Partner
  • Cisco Partner Learning Associate
  • Better Business Bureau

Questions? Call us at (919) 336-1000

2789 Administering and Automating Microsoft SQL Server 2005 Databases and Servers - Details

Return to All courses

Description:

This course provides students with the knowledge and skills to administer and automate Microsoft® SQL ServerT 2005 databases and servers. Elements of this syllabus are subject to change.

More Information  

Duration

1 day

Who Should Attend

This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

Prerequisites

2780 Maintaining a Microsoft SQL Server 2005 Database. 2779 Implementing a Microsoft SQL Server 2005 Database. 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.

Outline

Lesson 1: Managing and Automating Databases and Servers
Planning an Automated System for Database Maintenance
Planning an Automated System Server Maintenance
Documenting Administration and Automation Information

Lesson 2: Managing SQL Server Supporting Services
Managing SSIS Packages
Managing Replication
Managing Reporting Services

Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.

Contact us to learn more about our courses and certifications.

Return to Top

 
 

News and Events

View all news

Top Certifications

"75 percent of managers believe that certified individuals are more productive and that certifications are important to team performance." - MCP Customer Satisfaction Study

Top Certifications in Information Technology Today

Why get certified? The importance of certifications. Read more...

 

What sets us apart

New Horizons Integrated Learning

For training to have a lasting and measurable impact, New Horizons understands that course content has to be designed and delivered in the context of our client’s specific environment and business need.  To achieve this, we blend custom content with leading edge and time honored training approaches, including Traditional Instructor-Led, Mentored Learning, Online Live, and Online Anytime, to meet the specific learning style of the individual and the complex learning objectives of the organization.

New Horizons Integrated Learning guides learners through all stages of the learning lifecycle. It consists of five components - Assess, Learn, Reinforce, Support and Validate - to create the most effective learning experience available in the industry. 

Our Commitment, Guarantee and Promise