ALLCREDENTIALS.COM
COMPUTER TUTORS & 1 on 1 HELP
Certifications What Students Say Self Study - Why? Talk About Certifications
Computer Tutors

MCSE
Microsoft Certified Systems Engineer

MCDBA
Microsoft Certified Database Administrator

MCSA
Microsoft Certified Systems Administrator

MOUS
Microsoft Office User Specialist

A+ Certification
CompTIA Certification for PC Hardware with Windows Specialty

Network+ Certification
CompTIA Certification for Computer Networking

iNet+ Certification
CompTIA Certification for Internet Specialists

Linux+
CompTIA Linux+ Certification

CDIA Certification
CompTIA Certified Document Imaging Architect

CCNA
Cisco Certified Network Associate

Knowledge Management
Video Training Series

Installing, Configuring & Administering Microsoft SQL Server 2000 Enterprise Edition 70-228

Candidates for this exam operate in medium to very large computing environments that use Microsoft SQL Server 2000 Enterprise Edition. Candidates have at least one year of experience administering SQL Server. They also have at least one year of experience implementing relational databases in environments that contain:

  • Heterogeneous databases
  • SQL Server security integrated with Windows Authentication
  • Client/server configurations of 50 to 5,000 or more users
  • Web configurations that use Microsoft Internet Information Services (IIS) or COM+ Databases as large as 2 terabytes
  • Multiple installations of SQL Server 2000

Skills Being Measured

This certification exam measures your ability to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Before taking the exam, you should be proficient in the job skills listed below.

Installing and Configuring SQL Server 2000

Install SQL Server 2000. Considerations include clustering, default collation, file locations, number of instances, and service accounts.

Upgrade to SQL Server 2000

  • Perform a custom upgrade
  • Upgrade to SQL Server 2000 from SQL Server 6.5
  • Upgrade to SQL Server 2000 from SQL Server 7.0
  • Create a linked server

Configure SQL Mail and SQLAgentMail

Configure network libraries

Troubleshoot failed installations

Creating SQL Server 2000 Databases

Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.

Attach and detach databases

Create and alter databases

  • Add filegroups
  • Configure filegroup usage
  • Expand and shrink a database
  • Set database options by using the ALTER DATABASE or CREATE DATABASE statements
  • Size and place the transaction log

Create and manage objects. Objects include constraints, indexes, stored procedures, triggers, and views.

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases

Optimize database performance. Considerations include indexing, locking, and recompiling.

Optimize data storage

  • Optimize files and filegroups
  • Manage database fragmentation
  • Modify the database schema

Perform disaster recovery operations

  • Perform backups
  • Recover the system state and restore data
  • Configure, maintain, and troubleshoot log shipping

Perform integrity checks. Methods include configuring the Database Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).

Troubleshoot transactions and locking by using SQL Profiler, SQL Server Enterprise Manager, or Transact-SQL.

Extracting and Transforming Data with SQL Server 2000

Set up IIS virtual directories to support XML

Import and export data. Methods include the Bulk Insert task, the bulk copy program, Data Transformation Services (DTS), and heterogeneous queries.

Develop and manage DTS packages

Manage linked servers

  • Manage OLE DB Providers
  • Configure security mapping

Convert data types

Configure, maintain, and troubleshoot replication services

Managing and Monitoring SQL Server 2000 Security

Configure mixed security modes or Windows Authentication. Considerations include client connectivity, client operating system, and security infrastructure.

Create and manage log ons

Create and manage database users.

Create and manage security roles. Roles include application, database, and server.

Add and remove users from roles
Create roles to manage database security
Enforce and manage security by using stored procedures, triggers, views, and user-defined functions

Set permissions in a database. Considerations include object permissions, object ownership, and statement permissions.

Manage security auditing. Methods include SQL Profiler and C2 auditing.

Managing, Monitoring, and Troubleshooting SQL Server 2000

Create, manage, and troubleshoot SQL Server Agent jobs

Configure alerts and operators by using SQL Server Agent

Optimize hardware resource usage. Resources include CPU, disk I/O, and memory.

  • Monitor hardware resource usage by using System Monitor
  • Resolve system bottlenecks by using System Monitor

Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.

  • Monitor SQL Server system activity by using traces
  • Monitor SQL Server system activity by using System Monitor

This course will allow you to study at your own pace through a system of case-study scenarios and tutorials to gain practical experience analyzing, planning and optimizing a network infrastructure for Windows 2000 Server. As you build these real-world design skills, you are also preparing for MCP Exam 70-221 - a core credit on the Windows 2000 MCSE track.

Our dynamic training program includes:

  • 5 Videos or 6 Interactive CD-ROM's
  • 1 Microsoft approved study guide
  • 1 QuickCert Practice Exam Simulator
  • Our Upgrade Policy
  • Compatibility with: NT/95/98/2000
  • One year of educational support

Price and Ordering

Course List Price Your Price
MCSE SQL Server 2000 Enterprise Edition Exam 70-228 CD-ROM $595.00 $476.00
MCSE SQL Server 2000 Enterprise Edition Exam 70-228 Video $595.00 $476.00

 

    FAQs   About Us