Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 (Certificate)

New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.

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.

Prerequisite(s) or equivalent knowledge:
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

Prerequisite Comments:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience


Outline: Top
Lesson 1: Selecting the Appropriate High-availability Solution
Identifying High-availability Requirements and Constraints
Analyzing High-availability Requirements and Constraints
Determining Appropriate High-availability Solutions

Top
Lesson 2: Designing a Clustering Solution
Designing the Platform for Clustering
Designing the SQL Server Cluster Implementation
Designing Recovery Strategies and Test Plans for Database Clustering
Migrating and Upgrading SQL Server Clusters
Designing an Operations Plan for Clustering


Lesson 3: Designing a Highly Available Database Storage Solution
Determining Storage Requirements for SQL Server Databases
Determining Storage Requirements for SQL Server Components and Files
Designing Storage Solutions for SQL Server Databases
Designing a Backup and Restore Strategy


Lesson 4: Designing a Log Shipping Solution
Introduction to Designing a Log Shipping Solution
Designing Log Shipping Server Roles and Topology
Designing a Log Shipping Upgrade Strategy
Designing an Operations Plan for Log Shipping


Lesson 5: Designing a Database Mirroring Solution
Introduction to Designing a Database Mirroring Solution
Designing Database Roles and Topology for Database Mirroring
Converting High-availability Solutions to Database Mirroring
Designing an Operations Plan for Database Mirroring

Top
Lesson 6: Designing a Highly Available Solution Based on Replication
Introduction to Designing a Replication Solution
Designing a Replication Solution
Designing a Replication Upgrade Strategy
Designing an Operations Plan for Replication


Lesson 7: Combining High-availability Technologies
Evaluating Weaknesses in Each High-availability Technology
Maximizing Availability by Combining High-availability Technologies


Lesson 8: Documenting and Testing a High-availability Strategy
Documenting High-availability Solutions
Creating a Test Plan for High-availability Solutions
...''

Elements of this syllabus are subject to change.

Phone:+ 603-26946455

School Address:

3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia


Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,

Search other schools for Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 training resources.

Updating Your Database Development Skills to Microsoft SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
implementing and maintaining microsoft sql server 2008 reporting services
SQL Server Business Intelligence
oracle database 10g - introduction to sql

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.