Module 1 - Analyzing Capacity Needs
Storage Requirements
Determining Current Storage Capacity
Determining the Impact of Regulatory Requirements
Estimating Projected Storage Requirements
CPU Requirements
Analyzing Current CPU Performance
Choosing a Processor Type
Forecasting CPU Needs
Memory Requirements
Determining Current Memory Usage
Forecasting Memory Needs
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 Archiving
Requirements That Affect Data Archiving
Reasons for Archiving Data
Determining How Much Data Can Be Archived
Determining the Accessibility Requirements of Archived Data
Structure of Archival Data
Structuring Archival Data
Structure of Archival Data
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 Consolidation
Overview
Benefits
Risks
Strategy for SQL Server Instances
Installing Multiple Instances
Multiple Instance Design
Database Server Consolidation Plan
Designing a Consolidation Plan
Creating a Consolidation Plan
Lab 3 Introduction
Module 3 - Review
Module 4 - Data Distribution
Data Distribution Tools
Why Distribute Data?
Considerations
Tools
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 Infrastructure
Determining the Current
Infrastructure
Assessing the Quality of Database Designs
Assessing the Quality of Database Server Configurations
Assessing Database Storage
Gathering Requirements for Changing an Infrastructure
Technical Requirements
Business Requirements
Gathering Infrastructure Requirements
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 Recovery
Backup and Restore Strategies
Designing a Backup and Restore Strategy
Analyzing Business Requirements for Data Recovery
Categorizing Databases for Backup and Restore
Protecting Backups
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 Standards
Database Naming Conventions
Problems with Common Naming Conventions
Establishing Database Naming Conventions
Database Standards
Types of Standards
SQL Coding Standards
Database Access Standards
Deployment Process Standards
Lab 7 Introduction
Module 7 - Review
Closure |
