Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


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

Microsoft Dynamics CRM 2011 Course | Service Scheduling
Microsoft Dynamics CRM 2011 Course | Service Scheduling
2 sessions available starting from $850.00
SharePoint 2010 SharePoint Designer Course
SharePoint 2010 SharePoint Designer Course
2 sessions available starting from $1,360.00
Visual Studio 2008 Windows Workflow Foundations (WWF)
Visual Studio 2008 Windows Workflow Foundations (WWF)
6 sessions available starting from $1,660.00

see all listings »


Found In