New Horizons Computer Learning Center of Syracuse

Course Cart

Search Courses:
New Horizons of Syracuse
 

Want to take this class from the comfort and convenience of your own office? We can offer a customized version of most courses right at your office, when you need it. Read more about our on-site learning or contact us to get specific information.

2072 Administering a Microsoft SQL Server 2000 Database

Home > Courses > 2072 Administering a Microsoft SQL Server 2000 Database

Upcoming Classes

Start DateTimeDurationLocationCostPurchase

Don't see dates for this class? Please contact us or request that we add it to our schedule.

Methods of Delivery

This course can be delivered via the following learning methods:

Overview

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 Course Completion

Upon successful completion 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.

Pre-Requisites

2151 Microsoft Windows 2000 Network and Operating System Essentials
2152 Implementing Microsoft Windows 2000 Professional and Server
2071 Querying Microsoft SQL Server 2000
 
shadow

New Horizons of Syracuse, NY
Glacier Creek Office Park
6711 Towpath Road, Suite 100
East Syracuse, NY 13057
Phone: 315-449-3290
Email: info.syracuse@newhorizons.com

New Horizons of Rochester, NY
Calkins Road Business Park
50 Methodist Hill Drive, Suite 50
Rochester, NY 14623
Phone: 585-427-2150
Email: info.rochester@newhorizons.com

Copyright © 2010 New Horizons Computer Learning Center of Syracuse and Rochester. All rights reserved.
Links to the New Horizons Corporate website are denoted with an arrow (→)