Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








SQL Server 2000 Admin
MCDBA MCSA MCSE 70-228
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes: Time Needed
Basic Concepts and Installation   2 hours
Advanced Installation   2 hours
Creating and Managing Databases   2 hours
Disaster Recovery and Data Integrity   2 hours
Extracting and Securing Data   2 hours
Automation and Performance   2 hours
Practice Exam 1 hour
Estimated time needed to complete entire course 13 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Microsoft Pack, and receive this course plus many more, for only $197



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
The SQL Server 2000 Admin MCDBA MCSA MCSE 70 228 online training course 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 course teaches learners how to install SQL Server 2000 and configure advanced options. The online training course 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.




Basic Concepts and Installation
  • Understand basic database structure and terminology
  • Identify basic requirements for installing the various editions of SQL Server 2000 
  • Understand the file path structure
  • Select an installation type and desired components
  • Identify the network libraries used for connection to an instance
  • Install a named instance



Advanced Installation
  • Add and remove components
  • Uninstall an instance of SQL Server 2000
  • Perform a remote installation
  • Perform SQL Server 2000 upgrades
  • Create an unattended installation file for deployment on multiple servers
  • Add and remove nodes from a virtual server



Creating and Managing Databases
  • 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



Disaster Recovery and Data Integrity
  • 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



Extracting and Securing Data
  • 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



Automation and Performance
  • Manage a multiserver administration configuration
  • Configure the SQL Server Agent
  • Create automated Jobs, Alerts, and Operators
  • Optimize bulk copy process performance
  • Monitor system performance
  • Create and use a performance baseline to identify performance variance
  • Defragment indexes on tables and indexed views 



Practice Exam
  • Practice for the MCDBA/MCSA/MCSE 70 228 Exam
  •  







 

 

Copyright © 2007 TrainingCenter.com