Computer
Training
Course
List
Value Packages
Site Map
Microsoft Certification
Free
Training
Online Training Series:
SQL Server 2000 Administration Exam 70-228 Training
|
> SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 > Automation and Performance
This SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training Course on Automation and Performance
is part of a 7 course, 13 hour online training series.
This complete online training series can be purchased
for only $59.95.
Length: 2 Hour
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
Outline:
- Automation basics
- Administration agents
- Creating automation components
- Database maintenance planning wizard
- Optimizing performance
- Index defragmentation
- Bulk copy optimization
Features:
- Online computer glossary
- Online skill assessment testing
Applicability:
This course is for anyone preparing for the Microsoft SQL 2000 Administration 70-228 certification exam or for anyone who wants to learn more about databases.
Prerequisites: None
Technical Requirements: (Minimum)
- Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
- Operating System: Windows 95, 98, NT, ME, 2000, or XP.
- Minimum Connection Speed: 28.8k.
- Browser: Internet Explorer 5.0 or higher required.
- Authorware and Macromedia Flash player recommended but not required.
- JavaScript must be enabled.
- Netscape and AOL browsers not supported.
Need help or have questions about SQL Server 2000 Admin MCDBA MCSA MCSE 70-228? How
about 24x7 access worldwide to our instructors! Now you can get answers
from real experts within minutes via our online chat service. For just
$40.00 additional you add our Instant Mentoring service and get your
SQL Server 2000 Administration Exam 70-228 training courses questions quickly answered anytime from anywhere.
You might also be interested in our Microsoft Certifications Package which includes all of our
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 courses plus over 800 hours of additional courses.
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), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
StaffKit is a worldwide leader in providing computer training, online
tutorials and career education. StaffKit has satisifed customers in
over 30 countries.
|
Back to Microsoft SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training
Reviews:
"this is a must have resource"
TheTechMag.com
"this is the Ultimate Career Development Package."
MidWest Technology Journal
Great Service and Excellent Training Product - Great People
Kenosha, WI
Excellent program, this is a real winner. Thanks. A+
Arlington, TX
Read more customer reviews about
our e-learning training tutorials.
|
