Formation MS SQL Server - 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.
