Designing Microsoft SQL Server 2005 Infrastructure and Services
Short course
In London
Description
-
Type
Short course
-
Location
London
This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design.This is the first course in the database administration.
Facilities
Location
Start date
Start date
Reviews
Course programme
Lessons
- Estimating Storage Requirements
- EstimatingCPURequirements
- Estimating Memory Requirements
- Estimating Network Requirements
- Gathering Requirements that Impact or Affect Capacity Needs
- Estimating Capacity Needs
- Estimate disk storage requirements
- EstimateCPUrequirements
- Estimate memory requirements
- Estimate network bandwidth requirements
Lessons
- Identifying Requirements that Affect Data Archiving
- Determining the Structure of Archival Data
- Creating a Data Archival Plan
- Designing an Archiving Solution
- Defending Your Archiving Solution
- Identify the requirements that affect data archiving
- Determine the structure of archival data
- Create a data archival plan
Lessons
- Overview of Database Server Consolidation
- Designing a Strategy forSQLServer Instances
- Designing a Database Server Consolidation Plan
- Designing a Consolidation Strategy
- Defending Your Consolidation Strategy
- Identify the benefits of different ways to consolidate database servers
- Design a strategy forSQLServer instances
- Design a database server consolidation plan
Lessons
- Overview of Data Distribution
- Creating a Data Distribution Plan Using Replication
- Designing a Data Distribution Strategy
- Defending Your Data Distribution Strategy
- Select an appropriate tool for data distribution
- Create a data distribution plan using replication
Lessons
- Evaluating the Current Database Server Infrastructure
- Gathering Requirements for Changing a Database Server Infrastructure
- Designing Modifications to a Database Server Infrastructure
- Choosing a Database Server Hardware and Software
- Defending Your Database Server Hardware and Software Choices
- Evaluate the current database server infrastructure
- Gather requirements for changing a database server infrastructure
- Design modifications to a database server infrastructure
Lessons
- Creating a Backup and Restore Strategy
- Creating a Database Disaster Recovery Plan
- Devising a Recovery Strategy
- Sharing Lessons Learned from Disaster Recovery
- Create a backup and restore strategy
- Create a database disaster recovery plan
Lessons
- Establishing Database Naming Conventions
- Defining Database Standards
- Proposing Improved Object Naming Conventions
- Proposing Improved Coding Standards
- Create database naming conventions
- Define database infrastructure standards
Designing Microsoft SQL Server 2005 Infrastructure and Services