Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training


Summary:

The SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 series is designed to help learners prepare to take and pass Microsoft's exam number 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. This series teaches lear

This SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 online training series provides over 13 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Advanced Installation
2 . Automation and Performance
3 . Basic Concepts and Installation
4 . Creating and Managing Databases
5 . Disaster Recovery and Data Integrity
6 . Extracting and Securing Data
7 . Practice Exams

Lesson Detail:

Advanced Installation
This course covers basic installation procedures and options for both default and named instance installations of SQL Server 2000. Additional topics include advanced installation procedures, configuration options, and upgrade implementations of SQL Server


  • Subinstallations
  • Components
  • Remote installation
  • Unattended installation
  • Uninstalling SQL Server 2000
  • Failover Clustering
  • Upgrading

Automation and Performance
This course covers the capabilities included in SQL Server 2000 for automating routine tasks, allowing the database administrator to concentrate on development and tasks too complex for automation. Command-line options are available for most automation ca


  • Automation basics
  • Administration agents
  • Creating automation components
  • Database maintenance planning wizard
  • Optimizing performance
  • Index defragmentation
  • Bulk copy optimization

Basic Concepts and Installation
This course provides a brief review of database structure, implementation, and the basic databases within SQL Server 2000 installations. It also gives an overview of the available versions of SQL Server 2000 and their uses. The basic requirements for pla


  • Database Basics
  • Client/Server Topologies
  • Editions and Installation Options
  • Instances and Components
  • Network Libraries and Collations
  • Services and Authentication
  • Installation Checklist
  • Basic Installations

Creating and Managing Databases
This course discusses the basic creation of databases and database objects within a SQL Server 2000 instance. The tools provided in SQL Server 2000 installations for creating these are the SQL Server Enterprise Manager, a graphical user interface (GUI) ma


  • Basic Requirements
  • Creating and Deleting Databases
  • The CREATE and DROP DATABASE Commands
  • Creating Objects
  • Managing Databases
  • The ALTER DATABASE Command
  • Managing Objects

Disaster Recovery and Data Integrity
This course explains the processes used in backing up and restoring databases and database files within an instance of SQL Server 2000 using the SQL Server Enterprise Manager and the SQL Query Analyzer. Additional topics include troubleshooting transactio


  • Recovery Planning
  • Backups
  • Restoration
  • Data Integrity
  • Monitoring
  • DBCC Statements

Extracting and Securing Data
This course covers the use of bulk insertion and update tools including both command-line and graphical user interface tools, such as the Data Transformation Services (DTS) utility. Additional topics include SQL Server 2000 security modes, connection auth


  • Importing Individual Records
  • Importing Multiple Records
  • The bcp Utility
  • Data Transformation Services
  • Distributed Data Operations
  • Authentication Basics
  • Creating and Managing Logins
  • Authorization Basics
  • Creating and Managing Roles

Practice Exams
This course provides two practice exams for the Microsoft SQL 2000 Administration 70-228 certification exam.


  • Taking the MCDBA/MCSA/MCSE 70-228 Exam
  • Key Facts
  • Practice Exam

Certification:
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228


Audience:
This series is for anyone preparing for the Microsoft SQL 2000 Administration 70-228 certification exam or for anyone who wants to learn more about databases.


Features:

  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • A skill assessment generates a customized learning path based on the results of a pre-test.

Technical Requirements:


What You Get:

You will receive Unlimited Access to all of the SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.


Web-Based Training Products:


SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Online Training Series

Only $99.95    staffkit

You might also be interested in our Microsoft Certifications Package which includes all of the SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 training courses listed above plus hundreds of hours of related online training courses

 

Microsoft Certifications Package

Only $249.95   staffkit

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228
Training Series
Total Courses: 7
Total Time: 13+ hours
$119.99
Only $99.95
Available in Package only
Total Courses: 829
Total Time: 1776+ hours
$499.99
Only $249.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller

Reviews:

'offers employers an excellent way to train their staff economically and without having to send them out of the office.'
HRMReport.com

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
Package.'
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2014 StaffKit All Rights Reserved