Career Training >> Information Technology Training >> SQL Server Training >> 2780 Maintaining a Microsoft SQL Server 2005 Database Training Seminar
Course ID: 13858 | Course Duration: 3 Days
Course Dates: 
 
Career Training
 

2780 Maintaining a Microsoft SQL Server 2005 Database Training Class

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

2780 Maintaining a Microsoft SQL Server 2005 Database Training Seminar

Overview:
This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Who Should Attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

At Course Completion:
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability.

 
     
     
  Course Details  
     
     
  Agenda  
 
Outline:

Lesson 1: Installing and Configuring SQL Server 2005

Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.

Lesson 2: Managing Databases and Files

Planning databases.
Creating databases.
Managing databases.

Lesson 3: Managing Security

Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Implementing Cryptography in SQL Server.

Lesson 4: Disaster Recovery

Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.

Lesson 5: Monitoring SQL Server

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

Lesson 6: Transferring Data

Overview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.

Lesson 7: Automating Administrative Tasks

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

Lesson 8: Maintaining High Availability

Introduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.

Lesson 9: Introduction to Replication

Overview of Replication.

  
     
     
  Pre-requisites  
  2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2005 Transact-SQL 		 
     
     
 
On-Site Training Bring this 2780 Maintaining a Microsoft SQL Server 2005 Database training class in-house at your facility. Request More Information Request More Information On 2780 Maintaining a Microsoft SQL Server 2005 Database
 
Career Training
 
 
Career Training
  2780 Maintaining a Microsoft SQL Server 2005 Database Training Course Dates and Locations  
     
  Course ID: 13858 | Course Duration: 3 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
12/08/2008 $2,125.00    Orlando, FL Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/08/2008 $2,500.00    Neenah, WI Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/08/2008 $2,250.00    Tucson, AZ Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/08/2008 $2,695.00    Plantation, FL Register Online For The 12/08/2008 Event Request More Information   Register By Fax For The 12/08/2008 Event
12/15/2008 $2,495.00    Sacramento, CA Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $2,500.00    Green Bay, WI Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $2,500.00    Madison, WI Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $2,495.00    Sacramento, CA Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $2,125.00    Englewood, CO Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/15/2008 $2,195.00    Reno, NV Register Online For The 12/15/2008 Event Request More Information   Register By Fax For The 12/15/2008 Event
12/17/2008 $2,500.00    Wausau, WI Register Online For The 12/17/2008 Event Request More Information   Register By Fax For The 12/17/2008 Event
01/05/2009 $2,250.00    Dallas, TX Register Online For The 01/05/2009 Event Request More Information   Register By Fax For The 01/05/2009 Event
01/12/2009 $2,395.00    Boston, MA Register Online For The 01/12/2009 Event Request More Information   Register By Fax For The 01/12/2009 Event
02/09/2009 $2,250.00    Dallas, TX Register Online For The 02/09/2009 Event Request More Information   Register By Fax For The 02/09/2009 Event
02/09/2009 $2,375.00    Anaheim, CA Register Online For The 02/09/2009 Event Request More Information   Register By Fax For The 02/09/2009 Event
02/16/2009 $2,395.00    Waltham, MA Register Online For The 02/16/2009 Event Request More Information   Register By Fax For The 02/16/2009 Event
03/02/2009 $2,695.00    Miami, FL Register Online For The 03/02/2009 Event Request More Information   Register By Fax For The 03/02/2009 Event
03/30/2009 $2,250.00    Dallas, TX Register Online For The 03/30/2009 Event Request More Information   Register By Fax For The 03/30/2009 Event
04/06/2009 $2,395.00    Boston, MA Register Online For The 04/06/2009 Event Request More Information   Register By Fax For The 04/06/2009 Event
05/11/2009 $2,250.00    Dallas, TX Register Online For The 05/11/2009 Event Request More Information   Register By Fax For The 05/11/2009 Event
 
     
 
On-Site Training Bring this 2780 Maintaining a Microsoft SQL Server 2005 Database training class in-house at your facility. Request More Information Request More Information On 2780 Maintaining a Microsoft SQL Server 2005 Database
 
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