TRAINING CONTENTS
Module 1: Analyzing Capacity Needs
· Estimating Storage Requirements
· Estimating CPU Requirements
· Estimating Memory Requirements
· Estimating Network Requirements
Lab : Analyzing Capacity Needs
· Gathering Requirements that Impact or Affect Capacity Needs
· Estimating Capacity Needs
Module 2: Designing a Strategy for Data Archiving
· Identifying Requirements that Affect Data Archiving
· Determining the Structure of Archival Data
· Creating a Data Archival Plan
Lab : Designing a Strategy for Data Archiving
· Designing an Archiving Solution
· Defending Your Archiving Solution
Module 3: Designing a Strategy for Database Server Consolidation
· Overview of Database Server Consolidation
· Designing a Strategy for SQL Server Instances
· Designing a Database Server Consolidation Plan
Lab : Designing a Database Server Consolidation Strategy
· Designing a Consolidation Strategy
· Defending Your Consolidation Strategy
Module 4: Designing a Strategy for Data Distribution
· Overview of Data Distribution
· Creating a Data Distribution Plan Using Replication
Lab : Designing a Data Distribution Strategy Using Replication
· Designing a Data Distribution Strategy
· Defending Your Data Distribution Strategy
Module 5: Designing a Database Server Infrastructure
· Evaluating the Current Database Server Infrastructure
· Gathering Requirements for Changing a Database Server Infrastructure
· Designing Modifications to a Database Server Infrastructure
Lab : Designing a Database Server Infrastructure
· Choosing a Database Server Hardware and Software
· Defending Your Database Server Hardware and Software Choices
Module 6: Designing a Strategy for Data Recovery
· Creating a Backup and Restore Strategy
· Creating a Database Disaster Recovery Plan
Lab : Designing a Data Recovery Solution
· Devising a Recovery Strategy
· Sharing Lessons Learned from Disaster Recovery
Module 7: Establishing Database Conventions and Standards
· Establishing Database Naming Conventions
· Defining Database Standards
Lab : Establishing Database Conventions and Standards
· Proposing Improved Object Naming Conventions
· Proposing Improved Coding Standards