MS SQL Server Training - MS SQL Server 2005: Designing a Infrastructure (2786B)

Loading

MS SQL Server Training - MS SQL Server 2005: Designing a Infrastructure (2786B) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.


1400.-/d
ID : 572

Goal : This training provides database administrators the knowledge and skills to design a MS SQL ServerT 2005 database infrastructure. and focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The training also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design.

Audience : Current professional database administrators.

Prerequisites : Experience in administering SQL Server database solutions in an enterprise environment.

Goals :
  • Introduction
  • Analyzing Capacity Needs
  • Estimating Storage Requirements
  • Estimating CPU Requirements
  • Estimating Memory Requirements
  • Estimating Network Requirements
  • Designing a Strategy for Data Archiving
  • Identifying Requirements that Affect Data Archiving
  • Determining the Structure of Archival Data
  • Creating a Data Archival Plan
  • 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
  • Designing a Strategy for Data Distribution
  • Overview of Data Distribution
  • Creating a Data Distribution Plan Using Replication
  • Designing a Database Server Infrastructure
  • Evaluating the Current Database Server Infrastructure
Pedagogical method : Training based on MS slides and exercises

Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4

Daily price in face-to-face : 1400 CHF
Daily price in remote : 672 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 7000 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).


Tags : ms sql server 2005, designing a infrastructure, ms 2786b, ms2786. MS 2786, sql server 2005, sql server infrastructure, sql server 2005 infrastructure.