computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228

12 Month Subscription - $70
Live Mentor +$30

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 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.

Certification:
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 glossary
●  A Skill Assessment

Topics included in this course:
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Basic Concepts and Installation
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Advanced Installation
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Creating and Managing Databases
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Disaster Recovery and Data Integrity
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Extracting and Securing Data
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Automation and Performance

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Basic Concepts and Installation
Summary:
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.

Objectives:
After completing this course, students will be able to:
Understand basic database structure and terminology
Identify basic requirements for installing the various editions of SQL Server 2000
Select an installation type and desired components
Understand the file path structure
Identify the network libraries used for connection to an instance
Install a named instance

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

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Advanced Installation
Summary:
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.

Objectives:
After completing this course, students will be able to:
Add and remove components
Uninstall an instance of SQL Server 2000
Perform a remote installation
Create an unattended installation file for deployment on multiple servers
Add and remove nodes from a virtual server
Perform SQL Server 2000 upgrades

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

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Creating and Managing Databases
Summary:
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.

Objectives:
After completing this course, students will be able to:
Plan proper data and log file placement for a new database
Understand how to create and use filegroups
Create and delete a database using GUI and command-line methods
Restrict database access to Single-User Mode and restore normal access
Perform Attach and Detach operations on a database
Use the Enterprise Manager to modify existing database objects, including tables, views and stored procedures

Topics:
Basic Requirements
Creating and Deleting Databases
The CREATE and DROP DATABASE Commands
Creating Objects
Managing Databases
The ALTER DATABASE Command
Managing Objects
top

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Disaster Recovery and Data Integrity
Summary:
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.

Objectives:
After completing this course, students will be able to:
Recognize the differences among the three primary database backup types
Plan database backup scheduling based on backup type and recovery model selection
Determine when each of the three recovery methods should be used
Identify the types of integrity found in database implementations
Use SQL Server 2000 and Windows 2000 tools to troubleshoot transactions and perform integrity checks
Perform system monitoring using the SQL Profiler, Enterprise Manager, and Transact-SQL command-line actions

Topics:
Recovery Planning
Backups
Restoration
Data Integrity
Monitoring
DBCC Statements
top

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Extracting and Securing Data
Summary:
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.

Objectives:
After completing this course, students will be able to:
Import data into a database using the insert and bulk insert commands
Perform bulk imports, exports, and updates using the bcp utility
Create and schedule DTS packages
Create logins under Windows and SQL Server Authentication
Grant, revoke, and deny connections rights and access permissions
Create and remove user-defined database roles

Topics:
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
top

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Automation and Performance
Summary:
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.

Objectives:
After completing this course, students will be able to:
Manage a multiserver administration configuration
Configure the SQL Server Agent
Create automated Jobs, Alerts, and Operators
Monitor system performance
Create and use a performance baseline to identify performance variance
Defragment indexes on tables and indexed views
Optimize bulk copy process performance

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

SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 : Practice Exams
Summary:
This course provides two practice exams for the Microsoft SQL 2000 Administration 70-228 certification exam.

Objectives:
After completing this course, students will be able to:
Practice for the MCDBA/MCSA/MCSE 70-228 Exam

Topics:
Taking the MCDBA/MCSA/MCSE 70-228 Exam
Key Facts
Practice Exam
top

12 Month Subscription - $70
Live Mentor +$30