Managing and Maintaining a Microsoft Windows Server 2003 Environment

MCSE Exam number: 70-290

This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Network Engineer
Career Programme

Looking for a 2-12 months training?

Choose

Network Engineer career programme

Upcoming dates

There are no open public schedule dates for Managing and Maintaining a Microsoft Windows Server 2003 Environment course. We can offer you a private training or arrange a public course for you. Contact us here and we can make arrangements for your course.

Course Outline

Managing and Maintaining a Microsoft Windows Server 2003 Environment course overview

This course prepares you for MCSE Exam number: 70-290.

When you pass Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment, you complete the requirements for the following certification(s):

Microsoft Certified Professional (MCP) status:

Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment: counts as credit toward the following certification(s):

  • Core credit toward Microsoft Certified Systems Administrator (MCSA) on Windows Server 2003 certification
  • Core credit toward Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003 certification
  • Core credit toward Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 certification


Prerequisites for Managing and Maintaining a Microsoft Windows Server 2003 Environment course

  • CompTIA A+ certification, or equivalent knowledge and skills.
  • CompTIA Network+ certification, or equivalent knowledge and skills.


What will I get?

Delegates will learn:

  • Understand the steps necessary to invoke MySQL client programs
  • Utilize the general-purpose mysql client program and the MySQL Query Browser graphical user interface (GUI) to run queries and retrieve results
  • Select the best data type for representing information in MySQL
  • Manage the structural characteristics of your databases and the tables within your databases
  • Utilize the SELECT statement to retrieve information from database tables
  • Utilize expressions in SQL statements to retrieve more detailed information
  • Utilize SQL statements to modify the contents of database tables
  • Write join expressions in your SQL statements to obtain information from multiple tables
  • Utilize subqueries in your SQL statements
  • Create views utilizing SELECT statements to produce virtual tables of specific data
  • Perform bulk data import and export operations
  • Create user defined variables, prepared statements and stored routines
  • Create and manage triggers
  • Use the INFORMATION_SCHEMA database to access metadata
  • Debug MySQL applications
  • Configure and Optimize MySQL


Managing and Maintaining a Microsoft Windows Server 2003 Environment Course Contents

Managing and Maintaining Physical and Logical Devices

- Monitor server hardware. Tools might include Device Manager, the Hardware Troubleshooting - Wizard, and appropriate Control Panel items.

Manage basic disks and dynamic disks.

- Optimize server disk performance.

- Implement a RAID solution.

- Defragment volumes and partitions.

Install and configure server hardware devices.

- Configure driver signing options.

- Configure resource settings for a device.

- Configure device properties and settings.

Install and configure server hardware devices.

- Configure driver signing options.

- Configure resource settings for a device.

- Configure device properties and settings.

Install and configure server hardware devices.

- Configure driver signing options.

- Configure resource settings for a device.

- Configure device properties and settings.

Managing Users, Computers, and Groups

- Manage local, roaming, and mandatory user profiles.

Create and manage computer accounts in an Active Directory environment.

Create and manage groups.

- Identify and modify the scope of a group.

- Find domain groups in which a user is a member.

- Manage group membership.

- Create and modify groups by using the Active Directory Users and Computers Microsoft Management Console (MMC) snap-in.

Create and modify groups by using automation.

Create and manage user accounts.

- Create and modify user accounts by using the Active Directory Users and Computers MMC snap-in.

- Create and modify user accounts by using automation.

Import user accounts.

Troubleshoot computer accounts.

- Diagnose and resolve issues related to computer accounts by using the Active Directory Users and Computers MMC snap-in.

Troubleshoot user accounts.

- Diagnose and resolve account lockouts.

- Diagnose and resolve issues related to user account properties.

Reset computer accounts.

Troubleshoot user authentication issues.

Managing and Maintaining Access to Resources

- Configure access to shared folders.

- Manage shared folder permissions.

Troubleshoot Terminal Services.

- Diagnose and resolve issues related to Terminal Services security.

- Diagnose and resolve issues related to client access to Terminal Services.

Configure file system permissions.

- Verify effective permissions when granting permissions.

- Change ownership of files and folders.

Troubleshoot access to files and shared folders.

Managing and Maintaining a Server Environment

- Monitor and analyze events. Tools might include Event Viewer and System Monitor.

- Manage software update infrastructure.

- Manage software site licensing.

Manage servers remotely.

- Manage a server by using Remote Assistance.

- Manage a server by using Terminal Services remote administration mode.

- Manage a server by using available support tools.

Troubleshoot print queues.

Monitor system performance.

Monitor file and print servers. Tools might include Task Manager, Event Viewer, and System Monitor.

- Monitor disk quotas.

- Monitor print queues.

- Monitor server hardware for bottlenecks.

Monitor and optimize a server environment for application performance.

- Monitor memory performance objects.

- Monitor network performance objects.

- Monitor process performance objects.

- Monitor disk performance objects.

Manage a Web server.

- Manage Internet Information Services (IIS).

- Manage security for IIS.

Managing and Implementing Disaster Recovery

Perform system recovery for a server.

- Implement Automated System Recovery (ASR).

- Restore data from shadow copy volumes.

- Back up files and System State data to media.

- Configure security for backup operations.

Manage backup procedures.

- Verify the successful completion of backup jobs.

- Manage backup storage media.

Recover from server hardware failure.

- Restore backup data.

- Schedule backup jobs.

View Complete Course outline

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Network Engineer career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them