MCSA 2003: 10 Day Boot Camp Training

Every day, IT professionals are asked to make network infrastructures more efficient, keep everyone productive, and deliver more applications. Earning a Microsoft MCSA certification for Microsoft Windows Server 2003 validates your ability to perform these tasks on Microsoft's latest server operating system and identifies your expertise to employers, clients, and peers.

Our 10 day accelerated Training Camp provides information technology professionals with the knowledge and skills necessary to install, configure, support, and troubleshoot Microsoft Windows 2003-based networks. This is an accelerated course, designed for computer professionals that require effective, real-world skill-building and timely certification.

The MCSA 2003 Training Camp delivers the greatest value on the market for Windows 2003 Certification Training. During the program, students will be able to achieve the following certifications:

Microsoft Certified Professional (MCP)
Certified Technology Specialist (MCTS)
Microsoft Certified Systems Administrator (MCSA)

Our MCSA 2003 Program:

Allows you to achieve your certifications in a fraction of the time of 'traditional training' while delivering industry-leading exam passing percentages
Helps students grasp complex technical concepts more easily by identifying and catering to individual students' learning styles through a visual, and hands-on delivery system
Small Classroom for personalized attention attention
Instructors with extensive experience
Development of real experience via significant hands on practice

MCSA 2003 Certification is appropriate for?

Network Administrators
Network Engineers
Systems Administrators
Information Technology Professionals
Information Systems Administrators
Network Technicians
Technical Support Specialists

THIS Accelerated Certification Program is the most effective, efficient way to learn how to successfully design, plan, and implement a network infrastructure, Active Directory and client deployment on the Windows Server 2003 platform.

Course Materials:

Proprietary Lab Manual & Microsoft Courseware - developed in conjunction with Microsoft

Testing Prep Material

Exam Vouchers

Days	Module Description	Exam
1-2	Installing, Configuring, and Administering Microsoft Windows XP Professional	70-270
3-4	Managing and Maintaining a Microsoft Windows Server 2003 Environment	70-290
5-6	Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure	70-291
7-8	Microsoft SQL Server 2005 - Implementation and Maintenance	70-431
9-10	Exam Strategies and Make up Time

Exam 70-270

Installing, Configuring, and Administering Microsoft Windows XP Professional

Exam 70-270 became available March 4, 2002.

Audience Profile

Candidates for this exam operate in medium to very large computing environments that use Microsoft Windows XP Professional as a desktop operating system. They have a minimum of one year's experience implementing and administering any desktop operating system in a network environment.

Skills Being Measured

This certification exam measures your ability to implement, administer, and troubleshoot information systems that incorporate Microsoft Windows XP Professional. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Official Microsoft Learning Products may help you reach competency in the skills being tested in the exam.

Skills measured by exam 70-270

Installing Windows XP Professional

Perform and troubleshoot an attended installation of Windows XP Professional.

Perform and troubleshoot an unattended installation of Windows XP Professional.

Install Windows XP Professional by using Remote Installation Services (RIS).
Install Windows XP Professional by using the System Preparation Tool.
Create unattended answer files by using Setup Manager to automate the installation of Windows XP Professional.

Upgrade from a previous version of Windows to Windows XP Professional.

Prepare a computer to meet upgrade requirements.
Migrate existing user environments to a new installation.

Perform post-installation updates and product activation.

Troubleshoot failed installations.

Implementing and Conducting Administration of Resources

Monitor, manage, and troubleshoot access to files and folders.

Configure, manage, and troubleshoot file compression.
Control access to files and folders by using permissions.
Optimize access to files and folders.

Manage and troubleshoot access to shared folders.

Create and remove shared folders.
Control access to shared folders by using permissions.
Manage and troubleshoot Web server resources.

Connect to local and network print devices.

Manage printers and print jobs.
Control access to printers by using permissions.
Connect to an Internet printer.
Connect to a local print device.

Configure and manage file systems.

Convert from one file system to another file system.
Configure NTFS, FAT32, or FAT file systems.

Manage and troubleshoot access to and synchronization of offline files.

Implementing, Managing, Monitoring, and Troubleshooting Hardware Devices and Drivers

Implement, manage, and troubleshoot disk devices.

Install, configure, and manage DVD and CD-ROM devices.
Monitor and configure disks.
Monitor, configure, and troubleshoot volumes.
Monitor and configure removable media, such as tape devices.

Implement, manage, and troubleshoot display devices.

Configure multiple-display support.
Install, configure, and troubleshoot a video adapter.

Configure Advanced Configuration Power Interface (ACPI).

Implement, manage, and troubleshoot input and output (I/O) devices.

Monitor, configure, and troubleshoot I/O devices, such as printers, scanners, multimedia devices, mouse, keyboard, and smart card reader.
Monitor, configure, and troubleshoot multimedia hardware, such as cameras.
Install, configure, and manage modems.
Install, configure, and manage Infrared Data Association (IrDA) devices.
Install, configure, and manage wireless devices.
Install, configure, and manage USB devices.
Install, configure, and manage hand held devices.
Install, configure, and manage network adapters.

Manage and troubleshoot drivers and driver signing.

Monitor and configure multiprocessor computers.

Monitoring and Optimizing System Performance and Reliability

Monitor, optimize, and troubleshoot performance of the Windows XP Professional desktop.

Optimize and troubleshoot memory performance.
Optimize and troubleshoot processor utilization.
Optimize and troubleshoot disk performance.
Optimize and troubleshoot application performance.
Configure, manage, and troubleshoot Scheduled Tasks.

Manage, monitor, and optimize system performance for mobile users.

Restore and back up the operating system, System State data, and user data.

Recover System State data and user data by using Windows Backup.
Troubleshoot system restoration by starting in safe mode.
Recover System State data and user data by using the Recovery console.

Configuring and Troubleshooting the Desktop Environment

Configure and manage user profiles and desktop settings.

Configure support for multiple languages or multiple locations.

Enable multiple-language support.
Configure multiple-language support for users.
Configure local settings.
Configure Windows XP Professional for multiple locations.

Manage applications by using Windows Installer packages.

Implementing, Managing, and Troubleshooting Network Protocols and Services

Configure and troubleshoot the TCP/IP protocol.

Connect to computers by using dial-up networking.

Connect to computers by using a virtual private network (VPN) connection.
Create a dial-up connection to connect to a remote access server.
Connect to the Internet by using dial-up networking.
Configure and troubleshoot Internet Connection Sharing (ICS).

Connect to resources by using Internet Explorer.

Configure, manage, and implement Internet Information Services (IIS).

Configure, manage, and troubleshoot Remote Desktop and Remote Assistance.

Configure, manage, and troubleshoot an Internet Connection Firewall (ICF).

Configuring, Managing, and Troubleshooting Security

Configure, manage, and troubleshoot Encrypting File System (EFS).

Configure, manage, and troubleshoot a security configuration and local security policy.

Configure, manage, and troubleshoot local user and group accounts.

Configure, manage, and troubleshoot auditing.
Configure, manage, and troubleshoot account settings.
Configure, manage, and troubleshoot account policy.
Configure, manage, and troubleshoot user and group rights.
Troubleshoot cache credentials.

Configure, manage, and troubleshoot Internet Explorer security settings.

Preparation Guide for Exam 70-290

Managing and Maintaining a Microsoft Windows Server 2003 Environment

Exam News

Exam 70-290 became available August 14, 2003.

Audience Profile

The Microsoft Certified Systems Administrator (MCSA) on Windows Server 2003 credential is intended for IT professionals who work in the typically complex computing environment of medium to large companies. An MCSA candidate should have 6 to 12 months of experience administering client and network operating systems in environments that have the following characteristics:

250 to 5,000 or more users
Three or more physical locations
Three or more domain controllers
Network services and resources such as messaging, database, file and print, proxy server, firewall, Internet, intranet, remote access, and client computer management
Connectivity requirements such as connecting branch offices and individual users in remote locations to the corporate network and connecting corporate networks to the Internet

Skills Being Measured

This certification exam measures your ability to manage and maintain a Microsoft Windows Server 2003 environment. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Official Microsoft Learning Products may help you reach competency in the skills being tested in the exam.

Skills measured by exam 70-290

Managing and Maintaining Physical and Logical Devices

Manage basic disks and dynamic disks.

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

Optimize server disk performance.

Implement a RAID solution.
Defragment volumes and partitions.

Troubleshoot server hardware devices.

Diagnose and resolve issues related to hardware settings.
Diagnose and resolve issues related to server hardware and hardware driver upgrades.

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.
Reset computer accounts.

Troubleshoot user accounts.

Diagnose and resolve account lockouts.
Diagnose and resolve issues related to user account properties.

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.

Preparation Guide for Exam 70-291

Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

Exam News

Exam 70-291 became available August 14, 2003.

Audience Profile

250 to 5,000 or more users
Three or more physical locations
Three or more domain controllers
Network services and resources such as messaging, database, file and print, proxy server, firewall, Internet, intranet, remote access, and client computer management
Connectivity requirements such as connecting branch offices and individual users in remote locations to the corporate network and connecting corporate networks to the Internet

Skills Being Measured

This certification exam measures your ability to implement, manage, and maintain a Microsoft Windows Server 2003 network infrastructure. Before taking the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows which Official Microsoft Learning Products may help you reach competency in the skills being tested in the exam.

Skills measured by exam 70-291
Implementing, Managing, and Maintaining IP Addressing
Configure TCP/IP addressing on a server computer.
Manage DHCP. Manage DHCP clients and leases. Manage DHCP Relay Agent. Manage DHCP databases. Manage DHCP scope options. Manage reservations and reserved clients.
Troubleshoot TCP/IP addressing. Diagnose and resolve issues related to Automatic Private IP Addressing (APIPA). Diagnose and resolve issues related to incorrect TCP/IP configuration.
Troubleshoot DHCP. Diagnose and resolve issues related to DHCP authorization. Verify DHCP reservation configuration. Examine the system event log and DHCP server audit log files to find related events. Diagnose and resolve issues related to configuration of DHCP server and scope options. Verify that the DHCP Relay Agent is working correctly. Verify database integrity.
Implementing, Managing, and Maintaining Name Resolution
Install and configure the DNS Server service. Configure DNS server options. Configure DNS zone options. Configure DNS forwarding.
Manage DNS. Manage DNS zone settings. Manage DNS record settings. Manage DNS server options.
Monitor DNS. Tools might include System Monitor, Event Viewer, Replication Monitor, and DNS debug logs.
Implementing, Managing, and Maintaining Network Security
Implement secure network administration procedures. Implement security baseline settings and audit security settings by using security templates. Implement the principle of least privilege.
Install and configure software update infrastructure. Install and configure software update services. Install and configure automatic client update settings. Configure software updates on earlier operating systems.
Monitor network protocol security. Tools might include the IP Security Monitor Microsoft Management Console (MMC) snap-in and Kerberos support tools.
Troubleshoot network protocol security. Tools might include the IP Security Monitor MMC snap-in, Event Viewer, and Network Monitor.
Implementing, Managing, and Maintaining Routing and Remote Access
Configure Routing and Remote Access user authentication. Configure remote access authentication protocols. Configure Internet Authentication Service (IAS) to provide authentication for Routing and Remote Access clients. Configure Routing and Remote Access policies to permit or deny access.
Manage remote access. Manage packet filters. Manage Routing and Remote Access routing interfaces. Manage devices and ports. Manage routing protocols. Manage Routing and Remote Access clients.
Manage TCP/IP routing. Manage routing protocols. Manage routing tables. Manage routing ports.
Implement secure access between private networks.
Troubleshoot user access to remote access services. Diagnose and resolve issues related to remote access VPNs. Diagnose and resolve issues related to establishing a remote access connection. Diagnose and resolve user access to resources beyond the remote access server.
Troubleshoot Routing and Remote Access routing. Troubleshoot demand-dial routing. Troubleshoot router-to-router VPNs.
Maintaining a Network Infrastructure
Monitor network traffic. Tools might include Network Monitor and System Monitor.
Troubleshoot connectivity to the Internet.
Troubleshoot server services. Diagnose and resolve issues related to service dependency. Use service recovery options to diagnose and resolve service-related issues.

Preparation Guide for Exam 70-431

TS: Microsoft SQL Server 2005—Implementation and Maintenance

Audience Profile

Candidates for this exam are professionals who typically pursue careers as database administrators, database developers or business intelligence developers. Additionally, they can be people who do not work with Microsoft SQL Server as a part of their primary job functions, but who want to show their breadth of technology experience, such as developers, systems administrators, and others.

Candidates have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance their technical expertise, and they can implement and maintain databases by using specific instructions and specifications.

Candidates for this exam should be an expert in following areas:

Tools usage
UI navigation
Wizards usage
Writing code in the appropriate language (Transact-SQL, CLR language, and other scripting languages)
Code debugging or syntactic issue resolution
Troubleshooting
Accomplishing specific focused tasks by using code or UI navigation.

Credit Toward Certification

When you pass Exam 431: TS: Microsoft SQL Server 2005—Implementation and Maintenance exam, you complete the requirements for the following certification:

Microsoft Certified Technology Specialist: SQL Server 2005

Skills Being Measured

This certification exam measures your ability to implement and maintain a SQL Server 2005 database. Before you take the exam, you should be proficient in the job skills listed in the following matrix. The matrix shows the official Microsoft Learning products that may help you reach competency in the skills that you are being tested on in the exam.

Skills measured by exam 70-431
Installing and Configuring SQL Server 2005
Install SQL Server 2005. Verify prerequisites. Upgrade from an earlier version of SQL Server. Create an instance.
Configure SQL Server 2005 instances and databases. Configure log files and data files. Configure the SQL Server DatabaseMail subsystem for an instance. Choose a recovery model for the database.
Configure SQL Server security. Configure server security principals. Configure database securables. Configure encryption.
Configure linked servers by using SQL Server Management Studio (SSMS). Identify the external data source. Identify the characteristics of the data source. Identify the security model of the data source.
Implementing High Availability and Disaster Recovery
Implement database mirroring. Prepare databases for database mirroring. Create endpoints. Specify database partners. Specify a witness server. Configure an operating mode.
Implement log shipping. Initialize a secondary database. Configure log shipping options. Configure a log shipping mode. Configure monitoring.
Manage database snapshots. Create a snapshot. Revert a database from a snapshot.
Supporting Data Consumers
Retrieve data to support ad hoc and recurring queries. Construct SQL queries to return data. Format the results of SQL queries. Identify collation details.
Manipulate relational data. Insert, update, and delete data. Handle exceptions and errors. Manage transactions.
Manage XML data. Identify the specific structure needed by a consumer. Retrieve XML data. Modify XML data. Convert between XML data and relational data. Create an XML index. Load an XML schema.
Implement an HTTP endpoint. Create an HTTP endpoint. Secure an HTTP endpoint.
Implement Service Broker components. Create services. Create queues. Create contracts. Create conversations. Create message types. Send messages to a service. Route a message to a service. Receive messages from a service.
Import and export data from a file. Set a database to the bulk-logged recovery model to avoid inflating the transaction log. Run the bcp utility. Perform a Bulk Insert task. Import bulk XML data by using the OPENROWSET function. Copy data from one table to another by using the SQL Server 2005 Integration Services (SSIS) Import and Export Wizard.
Manage replication. Distinguish between replication types. Configure a publisher, a distributor, and a subscriber. Configure replication security. Configure conflict resolution settings for merge replication. Monitor replication. Improve replication performance. Plan for, stop, and restart recovery procedures.
Maintaining Databases
Implement and maintain SQL Server Agent jobs. Set a job owner. Create a job schedule. Create job steps. Configure job steps. Disable a job. Create a maintenance job. Set up alerts. Configure operators. Modify a job. Delete a job. Manage a job.
Manage databases by using Transact-SQL. Manage index fragmentation. Manage statistics. Shrink files. Perform database integrity checks by using DBCC CHECKDB.
Back up a database. Perform a full backup. Perform a differential backup. Perform a transaction log backup. Initialize a media set by using the FORMAT option. Append or overwrite an existing media set. Create a backup device. Back up filegroups.
Restore a database. Identify which files are needed from the backup strategy. Restore a database from a single file and from multiple files. Choose an appropriate restore method.
Move a database between servers. Choose an appropriate method for moving a database.
Monitoring and Troubleshooting SQL Server Performance
Gather performance and optimization data by using the SQL Server Profiler. Start a new trace. Save the trace logs. Configure SQL Server Profiler trace properties. Configure a System Monitor counter log. Correlate a SQL Server Profiler trace with System Monitor log data.
Gather performance and optimization data by using the Database Engine Tuning Advisor. Build a workload file by using the SQL Server Profiler. Tune a workload file by using the Database Engine Tuning Advisor. Save recommended indexes.
Monitor and resolve blocks and deadlocks. Identify the cause of a block by using the sys.dm_exec_requests system view. Terminate an errant process. Configure SQL Server Profiler trace properties. Identify transaction blocks.
Diagnose and resolve database server errors. Connect to a nonresponsive server by using the dedicated administrator connection (DAC). Review SQL Server startup logs. Review error messages in event logs.
Monitor SQL Server Agent job history. Identify the cause of a failure. Identify outcome details. Find out when a job last ran.
Gather performance and optimization data by using DMVs.
Creating and Implementing Database Objects
Implement a table. Specify column details. Specify the filegroup. Assign permissions to a role for tables. Specify a partition scheme when creating a table. Specify a transaction.
Implement a view. Create an indexed view. Create an updateable view. Assign permissions to a role or schema for a view.
Implement triggers. Create a trigger. Create DDL triggers for responding to database structure changes. Identify recursive triggers. Identify nested triggers. Identify transaction triggers.
Implement functions. Create a function. Identify deterministic versus nondeterministic functions.
Implement stored procedures. Create a stored procedure. Recompile a stored procedure. Assign permissions to a role for a stored procedure.
Implement constraints. Specify the scope of a constraint. Create a new constraint.
Implement indexes. Specify the filegroup. Specify the index type. Specify relational index options. Specify columns. Specify a partition scheme when creating an index. Disable an index. Create an online index by using an ONLINE argument.
Create user-defined types. Create a Transact-SQL user-defined type. Specify details of the data type. Create a CLR user-defined type.
Implement a full-text search. Create a catalog. Create an index. Specify a full-text population method.
Implement partitions.

Contact Us to reserve your spot !