Training Course
Locations | Schools | Online Courses | MBA | Submit Course | Post Request | Students | Jobs | House Rental


Jobs & Resumes

House Rental

Back | Home

Training Course:

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

School/Trainer:

New Horizons Singapore
Singapore, Singapore

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.

Please go to the school's official website for training price and schedule:
http://www.newhorizons.com/

Phone:+65 6822 8282

School Address:

298 Tiong Bahru Road
Level 18 Central Plaza
Singapore 168730

Jobs & Resumes: Singapore
Houses & Roommates: Singapore
Travel Agencies: Singapore

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




Other training courses offered by New Horizons Singapore:

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:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.



Finding any course, anywhere to learn...
Worldwide training course directory, linking for free
United States - United Kingdom - Australia - Canada - India - SpanishASKEDU.net  © 2003-2009