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 online training series teaches learners how to install SQL Server 2000 and configure advanced options. The series also teaches learners how to manage databases and objects, create a disaster recovery plan, troubleshoot data integrity issues, extract and secure data, automate tasks, and optimize performance.

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

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

Lesson Detail:

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 planning a SQL Server 2000 installation are presented.

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

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 2000, all of which may be included on the certification exam.

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

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) management tool, and the SQL Query Analyzer, allowing the option of either using templates or command-line methods. Additional topics include the maintenance of SQL Server 2000 databases and database objects using the SQL Server Enterprise Manager and command-line functions available in the SQL Query Analyzer utility.

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 transactions and options for checking data integrity using the SQL Server Enterprise Manager or the SQL Query Analyzer for command-line actions.

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 authentication, access authorization, and the assignment and revocation of permissions on a user and role basis. Methods employing the SQL Server Enterprise Manager, as well as command-line options for use within the SQL Query Analyzer, are emphasized.

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

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 capabilities, but the graphical user interface (GUI) management tools access in the SQL Server 2000 Enterprise Manager provides the most robust and rapidly deployed automation options. Additional topics include an overview of the tools and techniques for monitoring SQL Server 2000 operations and a discussion of some of the common SQL Server performance optimization considerations that are included in the exam. There are as many specific configurations for performance optimization as there are installations of SQL Server 2000.

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

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 online training 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:

Internet connection
Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
Authorware and Macromedia Flash player recommended but not required.
JavaScript must be enabled.

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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is a leader in providing online computer training tutorials and online education. We have customers use our online training courses in over 75 countries. StaffKit has been providing e-learning solutions for 10 years.

Web-Based Training Products:

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

Only $59.95

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