Module 1 - Analyzing Capacity NeedsLesson 1: Storage Requirements
Determining Current Storage Capacity
Determining the Impact of Regulatory Requirements
Estimating Projected Storage Requirements
Lesson 2: CPU Requirements
Analyzing Current CPU Performance
Choosing a Processor Type
Forecasting CPU Needs
Lesson 3: Memory Requirements
Determining Current Memory Usage
Forecasting Memory Needs
Lesson 4: Network Requirements
Identifying the Database Components of the Topology
Analyzing Current Database Network Traffic
Estimating Network Traffic Growth for Database Servers
Lab 1 Introduction
Module 1 - Review
Module 2 - Data ArchivingLesson 1: Requirements That Affect Data Archiving
Reasons for Archiving Data
Determining How Much Data Can Be Archived
Determining the Accessibility Requirements of Archived Data
Lesson 2: Structure of Archival Data
Structuring Archival Data
Structure of Archival Data
Lesson 3: Creating a Data Archival Plan
Creating a Data Archival Plan
Deciding What Data to Archive
Selecting a Storage Format for Archival Data
Developing an Archival Data Movement Strategy
Lab 2 Introduction
Module 2 - Review
Module 3 - Database Server ConsolidationLesson 1: Overview
Benefits
Risks
Lesson 2: Strategy for SQL Server Instances
Installing Multiple Instances
Multiple Instance Design
Lesson 3: Database Server Consolidation Plan
Designing a Consolidation Plan
Creating a Consolidation Plan
Lab 3 Introduction
Module 3 - Review
Module 4 - Data Distribution
Lesson 1: Data Distribution Tools
Why Distribute Data?
Considerations
Tools
Lesson 2: Data Distribution Plans Using Replication
Creating a Data Distribution Plan
Gathering Requirements for Data Distribution
Guidelines for Creating a Data Distribution Plan
Lab 4 Introduction
Module 4 - Review
|
|
Module 5 - Designing a Database Server InfrastructureLesson 1: Determining the Current
Infrastructure
Assessing the Quality of Database Designs
Assessing the Quality of Database Server Configurations
Assessing Database Storage
Lesson 2: Gathering Requirements for Changing an Infrastructure
Technical Requirements
Business Requirements
Gathering Infrastructure Requirements
Lesson 3: Designing Modifications to an Infrastructure
Database Server Infrastructure Design
Selecting Database Server Hardware and Software
Establishing Database Design and Implementation Policies
Establishing Administrative Policies
Lab 5 Introduction
Module 5 - Review
Module 6 - Data RecoveryLesson 1: Backup and Restore Strategies
Designing a Backup and Restore Strategy
Analyzing Business Requirements for Data Recovery
Categorizing Databases for Backup and Restore
Protecting Backups
Lesson 2: Creating Disaster Recovery Plans
Recommended Components of a Disaster Recovery Plan
Creating a Disaster Recovery Decision Tree
Documenting a Decision Tree
Best Practices
Lab 6 Introduction
Module 6 - Review
Module 7 - Establishing Database Conventions and StandardsLesson 1: Database Naming Conventions
Problems with Common Naming Conventions
Establishing Database Naming Conventions
Lesson 2: Database Standards
Types of Standards
SQL Coding Standards
Database Access Standards
Deployment Process Standards
Lab 7 Introduction
Module 7 - Review
Closure
|