Career Training >> Information Technology Training >> Microsoft Exchange Training >> 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services Training Seminar
Course ID: 15147 | Course Duration: 2 Days
Course Dates: 
 
Career Training
 

2786 Designing Microsoft SQL Server 2005 Infrastructure and Services Training Class

Course ID: 15147 		 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

2786 Designing Microsoft SQL Server 2005 Infrastructure and Services Training Seminar

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.

At Course Completion:
After completing this course, students will be able to: - Analyze storage, CPU, memory, and network capacity needs. - Design a strategy for data archiving. - Design a strategy for database server consolidation. - Design a strategy for data distribution. - Design a database server infrastructure. - Design a strategy for data recovery. - Establish database conventions and standards.

  
     
     
  Course Details  
     
     
  Agenda  
 
Outline:
Lesson 1: Analyzing Capacity Needs
Estimating Storage Requirements
Estimating CPU Requirements
Estimating Memory Requirements
Estimating Network Requirements

Lesson 2: Designing a Strategy for Data Archiving
Identifying Requirements that Affect Data Archiving
Determining the Structure of Archival Data
Creating a Data Archival Plan

Lesson 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

Lesson 4: Designing a Strategy for Data Distribution
Overview of Data Distribution
Creating a Data Distribution Plan Using Replication

Lesson 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

Lesson 6: Designing a Strategy for Data Recovery
Creating a Backup and Restore Strategy
Creating a Database Disaster Recovery Plan

Lesson 7: Establishing Database Conventions and Standards
Creating Database Naming Conventions
Defining Database Infrastructure Standards
 
     
     
  Audience  
  Who Should Attend:
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

  
     
  Pre-requisites  
  Pre-requisite(s):
2780 Maintaining a Microsoft SQL Server 2005 Database
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
 
     
     
 
On-Site Training Bring this 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services training class in-house at your facility. Request More Information Request More Information On 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services
 
Career Training
 
 
Career Training
  2786 Designing Microsoft SQL Server 2005 Infrastructure and Services Training Course Dates and Locations  
     
  Course ID: 15147 | Course Duration: 2 Days  
     
  Locations:  
     
  User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info		   Print/Fax
Register
01/12/2009 $1,000.00    Wausau, WI Register Online For The 01/12/2009 Event Request More Information   Register By Fax For The 01/12/2009 Event
01/12/2009 $1,000.00    Wauwatosa, WI Register Online For The 01/12/2009 Event Request More Information   Register By Fax For The 01/12/2009 Event
01/22/2009 $975.00    Boston, MA Register Online For The 01/22/2009 Event Request More Information   Register By Fax For The 01/22/2009 Event
01/26/2009 $900.00    Blue Ash, OH Register Online For The 01/26/2009 Event Request More Information   Register By Fax For The 01/26/2009 Event
01/26/2009 $1,000.00    Madison, WI Register Online For The 01/26/2009 Event Request More Information   Register By Fax For The 01/26/2009 Event
02/02/2009 $1,000.00    Wauwatosa, WI Register Online For The 02/02/2009 Event Request More Information   Register By Fax For The 02/02/2009 Event
02/02/2009 $1,000.00    Troy, MI Register Online For The 02/02/2009 Event Request More Information   Register By Fax For The 02/02/2009 Event
02/02/2009 $1,000.00    Troy, MI Register Online For The 02/02/2009 Event Request More Information   Register By Fax For The 02/02/2009 Event
02/09/2009 $1,000.00    Holmen, WI Register Online For The 02/09/2009 Event Request More Information   Register By Fax For The 02/09/2009 Event
02/09/2009 $1,000.00    Holmen, WI Register Online For The 02/09/2009 Event Request More Information   Register By Fax For The 02/09/2009 Event
02/26/2009 $900.00    King of Prussia, PA Register Online For The 02/26/2009 Event Request More Information   Register By Fax For The 02/26/2009 Event
03/09/2009 $1,000.00    Eau Claire, WI Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
03/09/2009 $1,000.00    Wauwatosa, WI Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
03/23/2009 $1,000.00    Madison, WI Register Online For The 03/23/2009 Event Request More Information   Register By Fax For The 03/23/2009 Event
03/30/2009 $1,000.00    Wausau, WI Register Online For The 03/30/2009 Event Request More Information   Register By Fax For The 03/30/2009 Event
03/30/2009 $1,000.00    Wausau, WI Register Online For The 03/30/2009 Event Request More Information   Register By Fax For The 03/30/2009 Event
04/06/2009 $1,000.00    Wauwatosa, WI Register Online For The 04/06/2009 Event Request More Information   Register By Fax For The 04/06/2009 Event
04/23/2009 $900.00    Philadelphia, PA Register Online For The 04/23/2009 Event Request More Information   Register By Fax For The 04/23/2009 Event
05/11/2009 $1,000.00    Wauwatosa, WI Register Online For The 05/11/2009 Event Request More Information   Register By Fax For The 05/11/2009 Event
05/26/2009 $1,000.00    Madison, WI Register Online For The 05/26/2009 Event Request More Information   Register By Fax For The 05/26/2009 Event
05/26/2009 $1,000.00    Wausau, WI Register Online For The 05/26/2009 Event Request More Information   Register By Fax For The 05/26/2009 Event
06/01/2009 $1,000.00    Wauwatosa, WI Register Online For The 06/01/2009 Event Request More Information   Register By Fax For The 06/01/2009 Event
06/08/2009 $1,000.00    Holmen, WI Register Online For The 06/08/2009 Event Request More Information   Register By Fax For The 06/08/2009 Event
08/06/2009 $900.00    King of Prussia, PA Register Online For The 08/06/2009 Event Request More Information   Register By Fax For The 08/06/2009 Event
10/29/2009 $900.00    Philadelphia, PA Register Online For The 10/29/2009 Event Request More Information   Register By Fax For The 10/29/2009 Event
 
     
 
On-Site Training Bring this 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services training class in-house at your facility. Request More Information Request More Information On 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

  
     
  Or, select a category to view more Information Technology courses

  
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

  
     
Career Training
 
   
 
 
Career Training
   
Career Training
 
 
 
 


Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace