Duration: 2 Days Instructor Led

This two-day workshop teaches messaging specialists to monitor and troubleshoot an Exchange Server 2007 messaging system. Students will learn how to correlate client and server issues and resolve those issues. They will also learn how to monitor systems and create reports from the monitoring data.
The audience for this course includes people with experience with Exchange Server 2007 or previous versions of Exchange Sever. These people will have experience installing and configuring Exchange Server, configuring recipients and mailboxes, and supporting Exchange Server clients. People coming into the course are expected to have at least three years experience working in the Information Technology field—typically in the areas of network administration or Windows Server administration—and one year of Exchange Server administration experience.

After completing this workshop, students will be able to:

• Use the Microsoft Exchange Server 2007 Management Pack for Microsoft Operations Manager (MOM) 2005 to monitor Exchange servers.
• Monitor and troubleshoot client performance and connectivity.
• Identify and resolve issues related to access of resources and messages.
• Monitor and troubleshoot mail flow.
• Monitor and troubleshoot Mailbox servers.
• Monitor and troubleshoot external and additional services.
• Identify trends in a messaging system.

Prerequisites
This workshop requires that students meet the following prerequisites:

• Fundamental knowledge of network technologies including DNS and firewall technologies.
• Experience administering Exchange Server 2007.
• Experience with the Windows Server 2003 operating system.
• Experience with Active Directory directory service in Windows Server 2003.
• Experience with managing backup and restore on Windows Servers.
• Experience using Windows management and monitoring tools such as Microsoft Management Console, Active Directory Users and Computers, Performance Monitor, Event Viewer, and IIS Administrator.
• Experience using Windows networking and troubleshooting tools such as Network Monitor, Telnet, and NSLookup.

Microsoft Certified Professional Exams
This course will help the student prepare for the following Microsoft Certified Professional exam:
• Exam Exam 70-236: Implementing: Troubleshooting

• Exam and Maintaining a MS Exchange Server 2007 Infrastructure.:

Course Materials
The student kit includes a comprehensive workbook and Student Materials compact disk for this class.

Course Outline
Unit 1: Introduction to Exchange Server Monitoring and Troubleshooting
Unit 2: Monitoring and Troubleshooting Client Performance and Connectivity
Unit 3: Troubleshooting Access to Resources and Messages
Unit 4: Monitoring and Troubleshooting Mail Flow
Unit 5: Monitoring and Troubleshooting Mailbox Servers
Unit 6: Monitoring and Troubleshooting External and Additional Services
Unit 7: Identifying Trends in a Messaging System

 Print this page

Duration: 3 Days Instructor Led

At the end of this three-day course, students who are new to Microsoft Exchange Server will learn how to configure and manage a messaging environment in accordance with technical requirements. Students will learn how to install Microsoft Exchange Server 2007 and manage routing, client access, and the backup and restore of databases. They will also learn how to manage addressing and recipient objects such as mailboxes, distribution groups, and contacts.

After completing this course, students will be able to:

• Describe how Exchange Server 2007 and the Active Directory directory service work together
• Install Exchange Server 2007.
• Configure Mailbox server roles.
• Manage recipient objects.
• Manage e-mail and address lists.
• Manage client access.
• Manage Messaging Transport.
• Manage availability, backup and recovery.
• Maintain the message system.

Prerequisites
This course requires that students meet the following prerequisites:

• Experience using these tools and applications:
• NTBackup command.
• NSLookup command.
• Windows Explorer
• Microsoft Management Console (MMC)
• Active Directory Users and Computers
• Active Directory Sites and Services
• Internet Information Services (IIS) Admin
• Outlook
• Working knowledge of Windows server operating system. For example, how storage is configured, basic backup and restore techniques, and what a client/server application interaction means.
• Working knowledge of network technologies. For example, what Transmission Control Protocol (TCP/IP) and Domain Name System (DNS) do and how to use them, basic routing concepts (Wide Area Networks (WAN) vs. Local Area Network (LAN) router vs. switch vs. hub).
• Working knowledge of Active Directory. For example, how user objects are managed, what is stored in Active Directory partitions, basic architectures (domain, forest, sites, etc.), and how domain controllers are managed. Also, site and site connector configuration, schema and configuration partitions, and Global Catalogs.
• Conceptual understanding of e-mail technologies For example, that Simple Mail Transport Protocol (SMTP) is a protocol used for e-mail and the differences between transport protocols and client access protocols (Post Office Protocol (POP), Internet Access Message Protocol (IMAP), SMTP).

Microsoft Certified Professional Exams
This course will help the student prepare for the following Microsoft Certified Professional exam:
• Exam Exam 70-236: Implementing: Troubleshooting

• Exam and Maintaining a MS Exchange Server 2007 Infrastructure.

Course Materials
The student kit includes a comprehensive workbook and a Student Materials compact disk for this class.

Course Outline
Module 1: Overview of Exchange and Active Directory
Module 2: Installing Exchange Server 2007
Module 3: Configuring Mailbox Server Roles
Module 4: Managing Recipient Objects
Module 5: Managing E-Mail Addresses and Address Lists
Module 6: Managing Client Access
Module 7: Managing Messaging Transport
Module 8: Managing Availability, Backup and Recovery
Module 9: Maintaining the Messaging System

 Print this page

Duration: 4 Days, Instructor-Led

In this course, you’ll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you’ll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You’ll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and how programmers can now use .NET languages like C# and Visual Basic to build database objects. You’ll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML.

Prerequisites
This course assumes that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts.

Course Objectives
In this course, you will:

• Understand basic database design principles and how to implement them in SQL Server.

• Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
• Understand the differences between view, stored procedures, triggers, and user-defined functions.
• Use the new Common Table Expressions for creating hierarchical queries.
• Perform calculations with Visual Basic and Visual C# code rather than T-SQL.
• Discover partitioning with SQL Server.
• Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries.
• Explore advanced techniques for working with complex data.
• Discover new XML capabilities in SQL Server 2005.

Course Outline

• A Tour of SQL Server 2005

• Designing and Creating a Database
• Data Selection Queries
• Modifying Data
• Working with SQL Server Management Studio
• Transact-SQL Programming
• Transactions and Error Handling
• Creating Views
• Creating Stored Procedures and Triggers
• Creating User-Defined Functions
• Using .NET Code in SQL Server 2005
• Advanced Query Techniques
• Implementing SQL Server Partitions
• Complex Querying
• Advanced Techniques
• Working with XML

 Print this page

Duration: 2 Days

Elements of this syllabus are subject to change.

This two-day instructor-led course provides students with the knowledge and skills to successfully implement Microsoft Windows SharePoint Services (WSS) version 3.0 in their organizations. It emphasizes that students should think about the architecture of their entire environment, including business and application needs, during the planning and deployment phases. The course covers how to perform a clean installation of WSS 3.0 and also describes all the prerequisites required to select the most appropriate method for upgrading WSS from 2.0 to 3.0 in a specific scenario. In addition, the course focuses on how to manage WSS after it is configured.

Target Audience
This course is intended for Business Application Administrators (BAAs) who are engaged in the planning, design, and selection of Line of Business (LOB) applications, including Microsoft Office SharePoint Server (MOSS), in conjunction with internal business customers. Their primary responsibility is the deployment, customization, management, and support of LOB applications. They routinely monitor application status and troubleshoot application problems. The audience is expected to have at least two years of experience in implementing, managing, and supporting Microsoft Windows Server 2003, including Internet Information Services (IIS).

Course Outline
Module 1: Introduction to the Windows SharePoint Services 3.0 Platform
Module 2: Planning the Windows SharePoint Services 3.0 Environment
Module 3: Installing Windows SharePoint Services 3.0
Module 4: Upgrading from Windows SharePoint Services 2.0 to 3.0
Module 5: Managing Windows SharePoint Services 3.0

 Print this page

Duration: 3 Days

Elements of this syllabus are subject to change.

This three-day instructor-led course provides students with the knowledge and skills required to implement Microsoft Office SharePoint Server 2007 successfully in their organization

Target Audience
The audience for this course is Business Application Administrators (BAAs), Web Administrators and Server Administrators who are engaged in the planning, design, and selection of line-of-business (LOB) applications (including Office SharePoint Server) in conjunction with internal business customers. Their primary responsibility is the deployment, customization, management, and support of LOB applications. They routinely monitor application status and troubleshoot application problems.

Prerequisites
Before attending this course, students must have:
• Experience in implementing, managing, and supporting a Microsoft Windows SharePoint Services 3.0 environment.
• Basic knowledge of Windows SharePoint Services and Microsoft Office SharePoint Server 2007 interoperability.
• At least 2 years of experience implementing, managing, and supporting Microsoft Windows Server 2003.
• At least 2 years of experience implementing, managing, and supporting Internet Information Services (IIS).
• Working knowledge of networking. For example TCP/IP and Domain Name System (DNS).
In addition, it is recommended, but not required, that students have completed:
• 5060 - Implementing Windows SharePoint Services 3.0.
• 3370 - First Look: Getting Started with Microsoft Office SharePoint Server2007.
• 2553 - Administering Microsoft SharePoint Portal Server 2003.

Course Outline
Module 1: Overview of Microsoft Office SharePoint Server 2007
Module 2: Planning and Designing for Microsoft Office SharePoint Server 2007
Module 3: Deploying Microsoft Office SharePoint Server 2007
Module 4: Administering Microsoft Office SharePoint Server 2007
Module 5: Implementing Portal Solutions
Module 6: Implementing Content Management Solutions
Module 7: Implementing Business Intelligence Solutions
Module 8: Implementing Search and Indexing
Module 9: Maintaining and Optimizing Microsoft Office SharePoint Server 2007

 Print this page

Duration: 2 Days

This course is designed for individuals who use Microsoft Office Project Professional 2003. The
topics in this course cover the critical skills necessary to create and modify a project plan file
that contains tasks, resources, and resource assignments.

Target Audience
This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Prerequisite(s)
- An understanding of project management concepts.
- Windows XP (New Version) - Level 1

Course Outline
Lesson 1
Creating a Project Plan File
Create a Project Plan File
Create and Assign a Project Calendar
Add Tasks to the Project Plan File
Add a Project Summary Task
Add a Recurring Task
Enter Task Duration Estimates

Lesson 2
Creating a Work Breakdown Structure
Outline Tasks
Link Dependent Tasks
Identify Deliverables in the Project Plan File
Constrain Tasks
Set a Task Deadline

Lesson 3
Creating and Assigning Resources
Create Resources
Create a Resource Calendar
Assign Resources
Assign Additional Resources to a Task
Resolve Resource Conflicts

Lesson 4
Finalizing the Project Plan
View the Critical Path
Shorten the Project Duration
Set a Baseline
Display Project Summary Information

 Print this page

Duration: 1 Day

In Microsoft Project 2003 Level 2, students used project management skills to create a project
plan. This course will build upon that knowledge, and give you the opportunity to work with a project plan once it has entered the project implementation phase.

Who Should Attend
This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans. It is also intended for a person who has a basic understanding of Microsoft Project 2003.

Prerequisites

• An understanding of project management concepts.
• Project 2003 - Level 1

At Course Completion
You will exchange project plan data with other applications, update project plans, create custom reports, and reuse project plan information.

Lesson 1
Exchanging Project Plan Data with Other Applications
Import a Task List from an Excel File into a New Project Plan
Create a Custom Import Map
Export Project Plan Cost Data into Excel
Copy a Picture into a Word Document
Save Project Plan Information as a Web Page

Lesson 2
Updating a Project Plan
Enter Task Progress Information
View Task Progress
Split a Task
Reschedule a Task
Filter Tasks in a Project Plan
Save an Interim Project Plan
Create a Custom Table

 Print this page

Duration: 2 Days

This course is designed for individuals who use Microsoft Office Project Professional 2003. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments.

Target Audience
This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Prerequisites

• An understanding of project management concepts.
• Windows XP (New Version) - Level 1

At Course Completion
You will create a project plan file containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan.

Course Outline
Lesson 1
Creating a Project Plan File
Create a Project Plan File
Create and Assign a Project Calendar
Add Tasks to the Project Plan File
Add a Project Summary Task
Add a Recurring Task
Enter Task Duration Estimates

Lesson 2
Creating a Work Breakdown Structure
Outline Tasks
Link Dependent Tasks
Identify Deliverables in the Project Plan File
Constrain Tasks
Set a Task Deadline

Lesson 3
Creating and Assigning Resources
Create Resources
Create a Resource Calendar
Assign Resources
Assign Additional Resources to a Task
Resolve Resource Conflicts

Lesson 4
Finalizing the Project Plan
View the Critical Path
Shorten the Project Duration
Set a Baseline
Display Project Summary Information

 Print this page

Duration: 1 Day / 2 Evenings
In this course, you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Target Audience
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

At Course Completion
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Outline
Lesson 1: Creating and Applying Templates
Lesson 2: Creating and Modifying Charts
Lesson 3: Working with Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Lesson 5: Sorting and Filtering Data
Lesson 6: Using Excel with the Web

Prerequisite
Excel 2003 - Level 1

 Print this page

Duration: 1 Day / 2 Evenings

In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Target Audience
This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format and print basic Microsoft® Office Excel 2003 worksheets.

At Course Completion
You will create and edit basic Microsoft Office Excel worksheets and workbooks.

Course Outline
Lesson 1: Getting Started with Excel
Lesson 2: Modifying a Worksheet
Lesson 3: Performing Calculations
Lesson 4: Formatting a Worksheet
Lesson 5: Developing a Workbook
Lesson 6: Printing Workbook Contents
Lesson 7: Customizing Layout

Prerequisite:
Windows XP (New Version) - Level 1

 Print this page