Support

SQL Server 2000 Training Course | Upgrading Your DBA Skills to SQL Server 2008 DBA Skills

5 sessions available starting from $2,040.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 6317
Course Duration: 3 days

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills.

Skills Gained

After completing this course students will be able to:

Describe the new features of SQL Server 2008
Plan for a SQL Server 2008 installation, upgrade and migration
Understand SQL Server data types
Manage SQL Server 2008
Secure a SQL Server 2008 database
Prepare for and recover from potential database disasters
Maintain availability to their SQL Server data even through server downtime
Configure replication of SQL Server 2008 databases
Implement policy-based management
Monitor database activity
Monitor and manage database performance...

see more

Course Code: 6317
Course Duration: 3 days

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills.

Skills Gained

After completing this course students will be able to:

Describe the new features of SQL Server 2008
Plan for a SQL Server 2008 installation, upgrade and migration
Understand SQL Server data types
Manage SQL Server 2008
Secure a SQL Server 2008 database
Prepare for and recover from potential database disasters
Maintain availability to their SQL Server data even through server downtime
Configure replication of SQL Server 2008 databases
Implement policy-based management
Monitor database activity
Monitor and manage database performance

Course Modules

Module 1: An Introduction to SQL Server 2008
This module will help students to understand the new features and overall architecture of SQL Server 2008.

Module 2: Installing and Upgrading to SQL Server 2008
This module will help students to understand how to plan for a SQL Server 2008 installation, upgrade and migration.

Module 3: Storage Enhancements in SQL Server 2008
This module will teach students about changes to data storage, including data types, indexes and partitions in SQL Server 2008.

Module 4: SQL Server 2008 Administration Enhancements
This module will help students to understand administration tools that are new or enhanced with SQL Server 2008.

Module 5: Security Enhancements with SQL Server 2008
This module will help students to understand enhancements and additions to SQL Server 2008 Security.

Module 6: SQL Server 2008 Disaster Recovery
This module will teach student how to prepare for and recover from potential database disasters

Module 7: High Availability in SQL Server 2008
This module will teach students how to maintain availability to their SQL Server data even through server downtime.

Module 8: Replication Enhancements in SQL Server 2008
This module helps students to take advantage of the replication enhancements in SQL Server 2008.

Module 9: SQL Server 2008 Policy-Based Management
The students will be introduced to new SQL Server 2008 policy-based management features.

Module 10: SQL Server 2008 Monitoring Enhancements
This module helps students to use SQL Server 2008 monitoring features.

Module 11: SQL Server 2008 Performance
This module helps students to take advantage of the performance enhancements in SQL Server 2008.

Who Should Attend

This course is intended for IT professionals who administer and maintain SQL Server databases.

Prerequisites

Before attending this course students must have:

• Experience developing or administering SQL Server 2000 databases

see less

Choose from 5 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: $2,040.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: $2,040.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: $2,040.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: $2,040.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: $2,040.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 SQL Server 2005 Training Course | Designing an Infrastructure
Microsoft SQL Server 2005 Training Course | Designing an Infrastructure
3 sessions available starting from $1,360.00
Microsoft Dynamics CRM 2011 Course | Sales Management
Microsoft Dynamics CRM 2011 Course | Sales Management
2 sessions available starting from $850.00
Microsoft Excel 2010 Course | Level 3
Microsoft Excel 2010 Course | Level 3
3 sessions available starting from $900.00

see all listings »


Found In