|
This set of training videos 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. Price: $395
|
| Meet
The Certified Instructor:
|
Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+) Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.
|
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 |
