KT-2072 Administering a Microsoft SQL Server 2000 Database Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Administering a Microsoft SQL Server 2000 Database


Description: 

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.   

At the end of the course, students will be able to:

  • Describe SQL Server architecture.
  • Plan for a SQL Server installation, and then install an instance of SQL Server.
  • Manage files and databases, including determining resource requirements.
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
  • Perform and automate administrative tasks and create custom administrative tools.
  • Back up databases and implement a backup strategy.
  • Restore databases.
  • Monitor and optimize SQL Server performance.
  • Transfer and migrate data into databases.
  • Maintain the high availability of SQL Server.
  • Describe how to replicate data from one SQL Server to another.

 
Click here to view the Course Outline
     
Prerequisite: 

Before attending this course, students must have experience using the Microsoft Windows® 2000 operating system and familiarity with relational databases and their concepts.

 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

This course qualifies for our Holiday Promotion.

Visit our homepage for details.