|
|
|
|
|
Designing High Availability Database Solutions Using SQL Server 2005 Training |
|
|
[to previous page]
[other products in "Other Microsoft Courses"]
|
| |
|
| Product: |
Designing High Availability Database Solutions Using SQL Server 2005 Training
|
Price:
excl. VAT |
|
|
|
| |
Designing High Availability Database Solutions Using SQL Server
Training Package Includes
- 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- Sample Code
- Step-by-step hands-on-labs
- Comprehensive, understandable, and reusable as reference material
Course Introduction
The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.
This instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.
List of Course Features
Designing High Availability Database Solutions Using SQL Server Course Contents
|
| |
Module 1 - Selecting the Appropriate High-Availability Solution
Selecting the Appropriate High-Availability Solution
Minimum Requirements for a High-Availability Solution
Identifying Requirements and Constraints
Identifying Business Needs
Identifying Technical Constraints
Identifying Failback and Failover Policies
Analyzing Requirements and Constraints
Guidelines for Analyzing Requirements
Analyzing Constraints
Analyzing the Potential Cost of a Solution
Module 1 Review
Module 2 - Designing a Highly Available Database Storage Solution
Designing a Highly Available Database Storage Solution
Storage Requirements for Databases
Storage Requirements for System Databases
Storage Requirements for TempDB
Storage Requirements for Components and Files
Storage Requirements for SQL Server Components
Full-Text Indexes
External Files
Trace and Event Log Files
Log Policies
Backup Files
Storage Solutions for Databases
File and Filegroup Structures for Database Data
File Structures for Transaction Logs
Storage Solutions for System Databases
Backup and Restore Strategy
Designing a Restore Strategy
Designing a Recovery Strategy for System Databases
Designing a Recovery Strategy for User Databases
Designing a Database Strategy That Includes Database Snapshots
Module 2 Review
Module 3 - Designing a Failover Clustering Solution
Designing a Failover Clustering Solution
Designing the Platform for Failover Clustering
Overview of Failover Clustering
Scope of Protection
Key Components of a Cluster Environment
Hardware Requirements for Clustering
Selecting the Appropriate Windows Cluster Topology
Single Instance Cluster
Multiple Instance Cluster
N + 1 Cluster
N + M Cluster
Designing a Geo-Clustering Solution
Network Considerations for a Cluster Environment
Designing the SQL Server Cluster Implementation
Instances and Services
Specifying Processor Resource Configurations
Specifying Memory Configurations
Specifying Network Configurations
Designing Recovery Strategies and a Test Plan
Disaster Recovery Strategy for a Cluster
Test Plan for a SQL Server Cluster
Migrating and Upgrading Clusters
Migration Strategy for a Non-Clustered Instance
Applying Service Packs and Hotfixes
Designing an Operations Plan for Clustering
Designing an Operations Plan
Operational Events Affecting Clustering
Managing Security Events
Managing Incorrect Configuration Settings
Technologies That Complement Clustering
Module 3 Review
Module 4 - Designing a Log Shipping Solution
Designing a Log Shipping Solution
Introduction to Designing a Log Shipping Solution
Scope of Protection
Factors That Impact a Log Shipping Design
Designing Log Shipping Server Roles and Topology
Log Shipping Server Roles and Topology
Process of Changing Server Roles
Designing a Log Shipping Upgrade Strategy
Upgrading from SQL Server 2000 to SQL Server 2005
Applying Service Packs and Hotfixes
Designing an Operations Plan
Events Affecting Log Shipping
Managing Security Events
Managing Environment Differences
Technologies That Complement Log Shipping
Module 4 Review
Module 5 - Designing a Database Mirroring Solution
Designing a Database Mirroring Solution
Introduction
Log Shipping vs. Database Mirroring
Scope of Protection
Modes of Database Mirroring
Factors That Impact a Database Mirroring Design
Designing Database Roles and Topology
Database Roles and Topology
Designing a Database Mirroring Topology
Changing Database Roles
The Impact of Database States on Availability
Testing Database Mirroring
Converting High-Availability Solutions to Database Mirroring
Converting Log Shipping to Database Mirroring
Converting Clustering to Database Mirroring
Designing an Operations Plan
Operational Events Affecting Database Mirroring
Managing Environment Differences
Applying Service Packs and Hotfixes
Technologies That Complement Database Mirroring
Module 5 Review
Module 6 - Designing Replication Solutions for High Availability
Designing Replication Solutions for High Availability
Introduction
Scope of Protection
Types of Replication
Factors To Consider
Designing a Replication Solution
Server Roles and Topology
Selecting Replication Type
Designing Replication Strategies
Immediate/Queued Updating
Merge Replication
Replication-Aware Applications
Designing an Upgrade Strategy
Applying Service Packs and Hotfixes
Operation Plan for Replication
Events Affecting Replication
Operational Events Affecting Replication
Managing Security Events
Managing Environment Differences
Technologies That Complement Replication
Module 6 Review
Module 7 - Combining High-Availability Technologies
Combining High-Availability Technologies
Weaknesses in Each High-Availability Technology
Weaknesses in Clustering
Weaknesses in Log Shipping
Weaknesses in Database Mirroring
Weaknesses in Replication
Combining High-Availability Technologies Cont.
Maximize Availability with Log Shipping
Maximize Availability with Database Mirroring
Maximize Database and Server Availability with Replication
Maximize Database Availability with Clustering
Module 7 Review
Module 8 - Documenting and Testing a High-Availability Strategy
Documenting and Testing a High-Availability Strategy
Documenting High-Availability Solutions
Documenting Business Requirements
Validating the Selected Solution
Documenting the Selected Solution
Documenting the Selected Solution Guidelines
Documenting Failover and Failback Strategies
Documenting Threats to the Selected Solution
Test Plan for High-Availability Solutions
Testing a High-Availability Solution
Determining Performance Benchmarks
Business and Regulatory Requirements
Module 8 Review
Course Closure |
|
|
|
 |
|
|
|
|
| Quick Links |
|
|
|
| RCS Newsletter |
|
|
|
| Our Customers |
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language |
|
|
| Copyright 2002-2010 RCS Limited. All rights reserved. More
... |
