Support

Microsoft SQL Server 2005 Course | Maintaining a Database

6 sessions available starting from $3,400.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 2780
Course Duration: 5 days

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.

Skills Gained

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.

Course Modules

Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan...

see more

Course Code: 2780
Course Duration: 5 days

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.

Skills Gained

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.

Course Modules

Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

Module 2: Managing Databases and Files
This module explains how to manage databases and files.

Module 3: Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.

Module 4: Managing Security
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Module 5: Monitoring SQL Server
This module explains how to monitor SQL Server performance and activity.

Module 6: Transferring Data
This module explains how to transfer and transform data.

Module 7: Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate administrative tasks.

Module 8: Implementing Replication
This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Module 9: Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.

Who Should Attend

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:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
• Course 2779: Implementing a Microsoft SQL Server 2005 Database

see less

Choose from 6 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Developing Native Applications for Windows Mobile 6
Developing Native Applications for Windows Mobile 6
2 sessions available starting from $1,360.00
Updating your Applications Infrastructure Technology Skills to Windows Server 2008
Updating your Applications Infrastructure Technology Skills to Windows Server 2008
5 sessions available starting from $2,040.00
Strenghtening Generation Y Managers within your Business Course Code: 	SGY
Strenghtening Generation Y Managers within your Business Course Code: SGY
6 sessions available starting from $980.00

see all listings »


Found In