Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLE * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade (70-649)
MCSE 2003 Corp Training Suite
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Cisco CCNA
Cisco CCNP
CISSP 2007
Certified Ethical Hacker (CEH)

View Complete List...
*

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
PRINCE2 Foundation
PRINCE2 Practioner Complete
IT Infrastructure Library ITIL

View Complete List...
*

GRAPHICS & LAYOUT
Creative Suite 3: Design Bundle
PhotoShop CS3 Essentials
Illustrator CS3 Essentials
InDesign CS3 Essentials
Photoshop Elements 5

View Complete List...
*

MULTIMEDIA & ANIMATION
After Effects CS3 Essentials
CS3: Production Bundle
Encore DVD Pro 2.0
Final Cut Studio
Premiere Pro CS3 Essentials

View Complete List...
*

CAD & 3D
AutoCAD 2008
AutoCAD Architecture 2008
AutoCAD LT 2008
3ds max 9 and VIZ
Civil 3D 2007

View Complete List...
*

SOFT SKILLS TRAINING
Assertiveness
Communication Series
Customer Service Series
Effective Presentation Skills
Telephone Courtesy and Customer Service

View Complete List...
*

WEB DESIGN & INTERNET
Creative Suite 3: Web Bundle
Dreamweaver CS3 Bundle
Flash CS3 Bundle
Expression Studio Bundle
E-Commerce Introduction

View Complete List...
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

MOC 2788: Designing High Availability Database Solutions Using SQL Server 2005
By CareerAcademy
MOC 2788 - Designing High Availability Database Solutions Using SQL Server 2005
MOC 2788: Designing High Availability Database Solutions Using SQL Server 2005
Single User CD Course £248.00 + VAT
Buy Now
Single User Online Course £198.00 + VAT
Buy Now
Multi User CD Course £496.00 + VAT
Buy Now
 

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.


    View CareerAcademy Demo Videos

    • COURSE OUTLINE
    Course Introduction
    Course Introduction

    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
     
    Print Image Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST   PROVIDERS   CONTACT US   SITEMAP  
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk
    red arrow Website design by Aimpro UK red arrow Terms