Designing a High Availability Database Solutions Using Microsoft SQL Server 2005

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

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.
Pre-requisite:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience
Outline:
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
-
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
-
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 ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Linux+ Certification
IBM Lotus Domino Designer 6
Exchanging and Transforming Data Using XML and XSLT
Introduction to C# Programming for the Microsoft .NET Platform
Developing Secure Web Applications
Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET
Programming with the Microsoft.NET Framework (Visual C#.NET)
Upgrading Web Development Skills from ASP to Microsoft ASP.NET
Introduction to C Programming
Designing Microsoft SQL Server 2005 Infrastructure and Services
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.