|
PACKAGE INCLUDES7 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components Printable courseware Step-by-step hands-on-labs Comprehensive, understandable, and reusable as reference material Focused on practical solutions to real-world development problems
COURSE INTRODUCTIONSchedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed. This instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 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.
|
COURSE OUTLINE
|
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 DistributionLesson 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
|
|