::Computeach:: Technology training for the real world
navbar
This text is replaced by the Flash movie.




Course: SQL Server 2000 Installation and Configuration

Overview
This course covers the installation, configuration and administration of MS SQL Server 2000. The material focuses on the features that are essential for Database Administrators. This course will prepare students for the MCDBA certification.

Topics Included in Training:

Installation and Configuration
• Upgrades
• Clustering
Database Creation and Management
• SQL Commands and Options
Objects, Creation and Management
• User and System Objects
• Tables
• Views
• Stored Procedures
• Triggers
• Functions
• Schemas
Security
• Logins, Roles and Object
Permissions
• Auditing
Administration
• Enterprise Manager
• Monitoring and Troubleshooting
• DSN (ODBC) Connections
• Optimization
• System Management
• File Groups
• Network Libraries
Backup and Restores
• SQL Server Agent
Linked Servers
Data Import, Export and Manipulation
• Data Type Conversions
• Import/Export Wizard
• DTS
• BCP
• Query Analyzer
XML Interfaces using IIS
Replication Service

Prerequisite: MCSE Core II (Server 2003)
Certification Tests: Offered in our Vue Testing Center
MS 70-228 Installing, Configuring, and Administering Microsoft SQL Server
2000 Enterprise Edition
Format: 40 Hours (5 Days) Instructor Led Training
Daytime and Evening/Saturday Classes Available

Course Content Subject to Change without Notice
Version 014-303A


::Computeach:: Technology training for the real world