Course ID: 16332 | Course Duration: 5 Days
Course Dates: 
 
Career Training
 

SQL Server 2005 Administration Training Class

Course ID: 16332
 
 
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
 
     
 

SQL Server 2005 Administration Training Seminar

Learn to administer and tune SQL Server Databases and Servers.
Get the knowledge and skills you need to maintain a Microsoft SQL Server 2005
database in this 5-day course. Learn how to use SQL Server 2005 product features
and tools related to maintaining a database.

This course incorporates material from the following Official Microsoft
Learning Product (OMLP):


Course 2780: Maintaining a Microsoft?? SQL Server 2005 Database

 
     
     
  Course Details  
     
     
  Agenda  
 

1. Installing and Configuring SQL Server 2005



  • Preparing to Install SQL Server
  • Installing SQL Server 2005
  • Managing a SQL Server 2005 Installation

2. Managing Databases and Files



  • Planning Databases
  • Creating Databases
  • Managing Databases

3. Disaster Recovery



  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery

4. Managing Security



  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates in SQL Server

5. Monitoring SQL Server



  • Viewing Current Activity
  • Using System Monitor
  • Using SQL Server Profiler
  • Using DDL Triggers
  • Using Event Notifications

6. Transferring Data



  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services
  • Using SQL Server Integration Services
  • Features of SQL Server Integration Services

7. Automating Administrative Tasks



  • Automating Administrative Tasks in SQL Server 2005
  • Configuring the SQL Server Agent
  • Creating Jobs and Operators
  • Creating Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security

8. Implementing Replication



  • Overview of Replication

    Implementing Replication
  • Configuring Replication in Some Common Scenarios

9. Maintaining High Availability



  • Introduction to High Availability
  • Implementing Server Clustering
  • Implementing Database Mirroring
  • Implementing Log Shipping
  • Implementing Peer-to-Peer Replication


 
     
     
  Audience  
 

IT professionals who want to become skilled on SQL Server 2005 product
features and technologies for implementing a database.

 
     
  Pre-requisites  
 

  • Basic knowledge of the Microsoft Windows operating system and its core
    functionality

  • Working knowledge of Transact-SQL

  • Working knowledge of relational databases

  • Some experience with database design


 
     
  Comments  
  For all course dates held in Canada, please add 5% GST to the course price. Canadian residents will need to add an additional 7% PST to the course price.  
     
     
 
On-Site Training Bring this SQL Server 2005 Administration training class in-house at your facility. Request More Information Request More Information On SQL Server 2005 Administration
 
Career Training
 
 
Career Training
  SQL Server 2005 Administration Training Course Dates and Locations  
     
  Course ID: 16332 | Course Duration: 5 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/05/2009 $2,995.00    Burlington, MA Register Online For The 01/05/2009 Event Request More Information   Register By Fax For The 01/05/2009 Event
01/12/2009 $2,995.00    POTOMAC, MD Register Online For The 01/12/2009 Event Request More Information   Register By Fax For The 01/12/2009 Event
01/26/2009 $2,995.00    ORLANDO, FL Register Online For The 01/26/2009 Event Request More Information   Register By Fax For The 01/26/2009 Event
01/26/2009 $2,995.00    Denver, CO Register Online For The 01/26/2009 Event Request More Information   Register By Fax For The 01/26/2009 Event
02/02/2009 $2,995.00    Rancho Cordova, CA Register Online For The 02/02/2009 Event Request More Information   Register By Fax For The 02/02/2009 Event
02/02/2009 $2,995.00    San Francisco, CA Register Online For The 02/02/2009 Event Request More Information   Register By Fax For The 02/02/2009 Event
02/16/2009 $2,995.00    Irving, TX Register Online For The 02/16/2009 Event Request More Information   Register By Fax For The 02/16/2009 Event
02/23/2009 $2,995.00    Baltimore, MD Register Online For The 02/23/2009 Event Request More Information   Register By Fax For The 02/23/2009 Event
03/09/2009 $2,995.00    Herndon, VA Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
03/16/2009 $2,995.00    Houston, TX Register Online For The 03/16/2009 Event Request More Information   Register By Fax For The 03/16/2009 Event
03/16/2009 $3,174.70    Kanata, ON Register Online For The 03/16/2009 Event Request More Information   Register By Fax For The 03/16/2009 Event
03/23/2009 $2,995.00    ARLINGTON, VA Register Online For The 03/23/2009 Event Request More Information   Register By Fax For The 03/23/2009 Event
03/30/2009 $2,995.00    King Of Prussia, PA Register Online For The 03/30/2009 Event Request More Information   Register By Fax For The 03/30/2009 Event
03/30/2009 $2,995.00    Dublin, OH Register Online For The 03/30/2009 Event Request More Information   Register By Fax For The 03/30/2009 Event
04/13/2009 $2,995.00    Boise, ID Register Online For The 04/13/2009 Event Request More Information   Register By Fax For The 04/13/2009 Event
04/13/2009 $3,174.70    Toronto, ON Register Online For The 04/13/2009 Event Request More Information   Register By Fax For The 04/13/2009 Event
04/20/2009 $2,995.00    Schaumburg, IL Register Online For The 04/20/2009 Event Request More Information   Register By Fax For The 04/20/2009 Event
04/20/2009 $2,995.00    Irving, TX Register Online For The 04/20/2009 Event Request More Information   Register By Fax For The 04/20/2009 Event
04/27/2009 $2,995.00    ORLANDO, FL Register Online For The 04/27/2009 Event Request More Information   Register By Fax For The 04/27/2009 Event
05/04/2009 $2,995.00    Rancho Cordova, CA Register Online For The 05/04/2009 Event Request More Information   Register By Fax For The 05/04/2009 Event
05/18/2009 $2,995.00    Cary, NC Register Online For The 05/18/2009 Event Request More Information   Register By Fax For The 05/18/2009 Event
05/18/2009 $2,995.00    Chicago, IL Register Online For The 05/18/2009 Event Request More Information   Register By Fax For The 05/18/2009 Event
05/25/2009 $3,174.70    Toronto, ON Register Online For The 05/25/2009 Event Request More Information   Register By Fax For The 05/25/2009 Event
06/01/2009 $2,995.00    POTOMAC, MD Register Online For The 06/01/2009 Event Request More Information   Register By Fax For The 06/01/2009 Event
06/08/2009 $2,995.00    Baltimore, MD Register Online For The 06/08/2009 Event Request More Information   Register By Fax For The 06/08/2009 Event
06/08/2009 $2,995.00    El Segundo, CA Register Online For The 06/08/2009 Event Request More Information   Register By Fax For The 06/08/2009 Event
06/15/2009 $2,995.00    Houston, TX Register Online For The 06/15/2009 Event Request More Information   Register By Fax For The 06/15/2009 Event
06/22/2009 $2,995.00    Irving, TX Register Online For The 06/22/2009 Event Request More Information   Register By Fax For The 06/22/2009 Event
 
     
 
On-Site Training Bring this SQL Server 2005 Administration training class in-house at your facility. Request More Information Request More Information On SQL Server 2005 Administration
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

 
     
  Or, select a category to view more 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