Microsoft Certified Systems Engineer
Microsoft Certified Database Administrator
Microsoft Certified Systems Administrator
Microsoft Office User Specialist
CompTIA Certification for PC Hardware with Windows Specialty
CompTIA Certification for Computer Networking
CompTIA Certification for Internet Specialists
CompTIA Linux+ Certification
CompTIA Certified Document Imaging Architect
Cisco Certified Network Associate
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:
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
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
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
Perform disaster recovery operations
Perform integrity checks. Methods include configuring the Database
Maintenance Plan Wizard and using the Database Consistency Checker (DBCC).
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
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
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.
Optimize and troubleshoot SQL Server system activity. Activities include cache hits, connections, locks, memory allocation, recompilation, and transactional throughput.
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:
Price and Ordering