All Education

On One Long Page

Visual Basic .NET

MOC 2565: Developing Microsoft .NET Applications for Windows (Visual Basic .NET)

This course provides students with the skills required to build Microsoft® Windows® Forms applications by using the Microsoft .NET Framework. The course covers the major topics for Windows client application programming on the .NET Framework. These topics include: Windows Forms, GDI+, simple data access, interoperating with unmanaged code, threading and asynchronous programming issues, simple remoting, Web access, XML Web services consumption, debugging, security, and deployment issues for desktop applications.

Modules include:

Module 1: Introducing Windows Forms
Module 2: Working With Controls
Module 3: Building Controls
Module 4: Using Data in Windows Forms Applications
Module 5: Interoperating with Managed Objects
Module 6: Printing and Reporting in Windows Forms Applications
Module 7: Asynchronous Programming
Module 8: Enhancing the Usability of Applications
Module 9: Deploying Windows Forms Applications
Module 10: Securing Windows Forms Applications

MOC 2557: Building COM+ Applications Using Microsoft .NET Enterprise Services

This course provides students with the knowledge and skills to effectively build scalable, distributed applications that use Microsoft .NET Enterprise Services and the Microsoft .NET Framework. This course covers Enterprise Services such as Just-In-Time activation, Transactions, Object Pooling, Construction Strings, Compensating Resource Managers, Loosely Coupled Events, Queued Components, and COM+ role-based security to implement distribute.

Modules include:

Module 1: Introduction to COM+ Services
Module 2: Configuring Just-in-Time Activation and Synchronization
Module 3: Using ADO.NET to Work With Data
Module 4: Transaction Services
Module 5: Securing Enterprise Applications
Module 6: State Management
Module 7: Compensating Resource Managers
Module 8: Loosely Coupled Events
Module 9: Queued Components
Module 10: Debugging COM+ Applications
Module 11: Deploying and Administering COM+ Applications
Module 12: COM+ 1.5 Enhancements

MOC 2373: Programming with Microsoft Visual Basic .NET

The goal of this course is to provide Microsoft Visual Basic developers with the knowledge and skills needed to develop Microsoft .NET-based applications by using Visual Basic .NET. These changes will allow Visual Basic developers to create enterprise applications for the .NET Platform and to create more traditional Visual Basic applications that can take advantage of the enhancements to the language.

Modules include:

Module 1: Overview of the Microsoft .NET Platform
Module 2: Development Environment Features
Module 3: Language and Syntax Enhancements
Module 4: Object-Oriented Design for Visual Basic .NET
Module 5: Object-Oriented Programming in Visual Basic .NET
Module 6: Using Windows Forms
Module 7: Building Web Applications
Module 8: Using ADO.NET
Module 9: Developing Components in Visual Basic .NET
Module 10: Deploying Applications
Module 11: Upgrading to Visual Basic .NET

MOC 2415: Programming with the Microsoft .NET Framework using Visual Basic .NET

This course provides a behind the scenes tour of the lower level functionality of the Microsoft .NET Framework without the integrated development environment. Tutorials about working with assemblies, versioning, the common type system, memory management, file and network I/O, serialization, remoting, garbage collection, interfaces, specialized constructors and web services are covered in extensive detail. The goal of this course is to help application developers understand the Microsoft .NET Framework features that are used to code, debug, tune, and deploy applications.

Modules include:

Module 1: Overview of the Microsoft .NET Framework
Module 2: Introduction to a Managed Execution Environment
Module 3: Working with Components
Module 4: Deployment and Versioning
Module 5: Common Type System
Module 6: Working with Types
Module 7: Strings, Arrays, and Collections
Module 8: Delegates and Events
Module 9: Memory and Resource Management
Module 10: Data Streams and Files
Module 11: Internet Access
Module 12: Serialization
Module 13: Remoting and XML Web Services

MOC 2310: Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET

This course teaches students how to use Visual Studio .NET to create ASP.NET applications that delivers dynamic content to the Web. This will teach Microsoft Visual Basic programmers and Web developers the fundamentals of Web application site implementation by using Microsoft ASP.NET and Microsoft Visual Basic .NET. This course focuses on using the Microsoft Visual Studio® .NET environment and the Microsoft .NET platform to create an ASP.NET Web application that delivers dynamic content to a Web site.

Modules include:

Module 1: Overview of the Microsoft .NET Framework
Module 2: Using Microsoft Visual Studio .NET
Module 3: Using Microsoft .NET-Based Languages
Module 4: Creating a Microsoft ASP.NET Web Form
Module 5: Adding Code to a Microsoft ASP.NET Web Form
Module 6: Tracing in Microsoft ASP.NET Web Applications
Module 7: Validating User Input
Module 8: Creating User Controls
Module 9: Accessing Relational Data Using Microsoft Visual Studio .NET
Module 10: Accessing Data with Microsoft ADO.NET
Module 11: Calling Stored Procedures with Microsoft ADO.NET
Module 12: Reading and Writing XML Data
Module 13: Consuming and Creating XML Web Services
Module 14: Managing State
Module 15: Configuring, Optimizing, and Deploying a Microsoft ASP.NET Web Application
Module 16: Helping to Protect a Microsoft ASP.NET Web Application
Module 17: Review

MOC 2389: Programming with ADO .NET

This course covers the topics necessary in designing and building data-centric, distributed applications for the enterprise. The course goes over the low-level functionality of the ADO.NET architecture, ADO.NET and XML, connecting to SQL Server and other data sources, performing connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML. Instruction in building a DataSet schema, populating it with data, and modifying the data programmatically is covered as well as using XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.

Modules include:

Module 1: Data-Centric Applications and ADO.NET
Module 2: Connecting to Data Sources
Module 3: Performing Connected Database Operations
Module 4: Building DataSets
Module 5: Reading and Writing XML with ADO.NET
Module 6: Building DataSets from Existing Data Sources
Module 7: Building and Consuming a Web Service That Uses ADO.NET

MOC 2063: Introduction to ASP.NET

The goal of this course is to teach students how to create Microsoft ASP.NET applications that deliver dynamic content to the Web. Topics include input validation, data access, and XML web services.

Modules include:

Module 1: Working with Microsoft ASP.NET
Module 2: Using Web Controls
Module 3: Using Microsoft ADO.NET to Access Data
Module 4: Separating Code from Content
Module 5: Using Trace in Microsoft ASP.NET Pages
Module 6: Using Web Services
Module 7: Creating a Microsoft ASP.NET Web Application

MOC 2559: Introduction to Visual Basic .NET Programming with Microsoft .NET

This course provides students with the knowledge and skills needed to develop applications in Microsoft Visual Basic® .NET for the Microsoft .NET platform. The course focuses on user interfaces, program structure, language syntax, and implementation details.

Modules include:

Module 1: Getting Started
Module 2: Working with Forms and Controls
Module 3: Using Variables and Arrays
Module 4: Working with Procedures
Module 5: Decision Structures and Loops
Module 6: Validating User Input
Module 7: Object-Oriented Programming in Visual Basic .NET
Module 8: Handling Errors and Exceptions
Module 9: Enhancing the User Interface
Module 10: Web Forms and XML Web Services
Module 11: Using ADO.NET
Module 12: Deploying Applications

Clinic 2551: Introduction to Visual Studio 2005 Team System

This clinic will provide both Business Decision Makers (BDMs) and Technical Decision Makers (TDMs), Architects, Developers, Testers, and Project Managers with an introduction to Visual Studio Team System. This introduction will explain what the product is, how it relates to the software development lifecycle and how processes such as MSF fit it. Detailed information about software concepts and principles, and the skills and knowledge required to complete the tasks necessary for your job role. At the end of the course, students will be able to: gain a high-level overview of VSTS.

Introduction to Visual Studio Team System
Managing the Software Development Life Cycle
Introduction to Visual Studio Team System (VSTS)
Using VSTS Tools Across Multiple Roles
Using VSTS Tools to Support the SDL Process
Automating Reporting and Status Using VSTS

Course 2924: Building Data Components in Microsoft Visual Studio 2005

This course provides students with a focused, hands-on environment to experience the new features and functionality related to building Data Components in Microsoft Visual Studio 2005. At the end of the course, students will be able to: describe the new features of ADO.NET 2.0, describe the productivity Enhancements in Visual Studio 2005, describe the productivity Enhancements in .NET Framework 2.0, identify the wizards and designers in Visual Studio 2005.

The Visual Studio Product
Visual Studio 2005 Support for Development
Productivity Enhancements in .NET Framework 2.0
Productivity Enhancements in Visual Studio 2005
Lab (C#): Using Productivity Enhancements
Lab (Visual Basic .NET): Using Productivity Enhancements
Building Data Components in Visual Studio 2005
Visual Studio 2005 Wizards and Designers
Lab: Accessing Data Using ADO.NET

Course 4336: Upgrading from Microsoft Visual Basic 6.0: Introduction to the Microsoft .NET Framework

This online learning course teaches the Visual Basic 6.0 developer about the .NET Framework 2.0 including the Common Language Runtime, the Common Type System, Garbage Collection and COM interoperability. The course also introduces the .NET Framework namespaces and base classes. This training is designed with the Visual Basic 6.0 developer in mind to allow for a simple transition to the .NET Framework. At the end of the course, students will be able to: explain the purpose and components of the .NET Framework 2.0 and the common language runtime (CLR), explain and use the .NET Framework 2.0 common type system (CTS), explain how COM components and the .NET Framework interoperate with each other, identify and use the classes and namespaces in the .NET Framework class library.

Introduction to the Microsoft .NET Framework 2.0 Architecture
Components and Features of the .NET Framework Platform
Using .NET Framework Classes and Namespaces
Lab: Using .NET Framework Classes and Namespaces

Course 2925: Building Managed Code for SQL Server 2005

This course provides students with a focused, hands-on environment to experience the new features and functionality related to building managed code for Microsoft SQL Server™ 2005 using Visual Studio 2005. At the end of the course, students will be able to: develop Managed Code for SQL Server 2005.

Building Managed Code for SQL Server 2005
Managed Code in SQL Server 2005
Lab: Writing Managed Code for SQL Server 2005
Lab: Working with XML in Visual Studio 2005 and SQL Server 2005

Course 2926: Building Windows Forms Applications with Microsoft Visual Studio 2005

This course will provide the student with a focused, hands-on environment to experience the new features and functionality of the Microsoft Visual Studio 2005 product related to building Windows Forms applications. At the end of the course, students will be able to: develop Microsoft Windows Forms applications, use the new and enhanced features of building presentation layer applications, build data-bound forms by using the RAD data-binding features provided by Visual Studio 2005, deploy applications by using ClickOnce Technology.

Developing Microsoft Windows Forms Applications
New and Enhanced Features of Building Presentation Layer Applications
Lab: RAD Data Binding in Windows Forms
Lab: Data Binding to Components and Web Services
Deploying Applications By Using ClickOnce Technology
Lab: Publishing Using ClickOnce

Course 2927: Building Web Applications with ASP.NET 2.0

This course will provide the student with a focused, hands-on environment to experience the new features and functionality of the Microsoft Visual Studio 2005 product related to building Web Applications with ASP.NET 2.0. At the end of the course, students will be able to: use the new and enhanced features of building presentation layer applications, use Visual Studio 2005 support for programming Master Pages, site navigation, and themes, build data-bound forms with ASP.NET 2.0 by using the RAD data-binding features of Visual Studio 2005.

New and Enhanced Features of Building Presentation Layer Applications
New Data-Related Features
Lab: RAD Data Binding with ASP.NET 2.0
Master Pages, Site Navigation, and Themes
Lab: Programming Master Pages, Site Navigation, and Themes
Administration Features
Lab: Membership and Role Management in ASP.NET 2.0

Course 2928: Implementing Data Access and Security in an ASP.NET 2.0 Web Application

This course provides students with the knowledge and skills to create ASP.NET 2.0 applications. Specifically, this course concentrates on the new Web development environment, data-bound controls, and ASP.NET security. The course includes sample code in both Microsoft Visual Basic .NET and Microsoft Visual C#.

At the end of the course, students will be able to: develop Web applications by using the new features and functionalities in ASP.NET 2.0, implement data access in a Web page by using Data Source components and controls, implement the forms-based authentication by using the enhancements provided in ASP.NET 2.0, implement Web application security by using the Membership and Roles, and Security Web controls.

Course 2929: Implementing Wizards, Site Navigation, State Management, and Configuration in ASP.NET 2.0

This course provides students with the knowledge and skills to create ASP.NET 2.0 applications. The course focuses on Application Services, State Management and Configuration and Instrumentation. The course includes sample code in both Microsoft Visual Basic .NET and Microsoft Visual C#. At the end of the course, students will be able to: create ASP.NET 2.0 wizards, implement site navigation, use ASP.NET 2.0 State Management, configure ASP.NET 2.0.

Course 2930: Implementing Master Pages, Personalization, and Web Parts with ASP.NET 2.0

This course provides students with the knowledge and skills to create ASP.NET 2.0 applications. The course focuses on Master Pages, Personalization, and Web Parts. The course includes sample code in both Microsoft Visual Basic .NET and Microsoft Visual C#.

Visual Basic 6

MOC 1016: Mastering Enterprise Development Using Microsoft Visual Basic 6

In this course covers the building and debugging Visual Basic-based applications that interact with a typical three-tier business environment that uses ADO in the middle tier to access data and invoke business and data services implemented in SQL. The course instructs on the use of MTS to address application infrastructure issues associated with building server-side COM objects. The course encompasses issues related to scalability of COM object, business rules and logic, training in the creating of objects that create transactions that conform to ACID (atomicity, consistency, isolation, durability) properties and integrate well with data stores. The use of interfaces and message queuing is discussed as well.

Modules include:

Module 1: Microsoft's Enterprise Development Strategy
Module 2: Building COM DLLs with Visual Basic
Module 3: Introduction to Microsoft Transaction Server
Module 4: Using MTS Transaction Services
Module 5: Accessing Data from the Middle Tier
Module 6: Building Stored Procedures with SQL
Module 7: Implementing Security
Module 8: Implementing COM with Visual Basic
Module 9: Advanced Client/Server Technologies

MOC 1013: Mastering Microsoft Visual Basic 6 Development

This course teaches how to use Microsoft Visual Basic with the component object model to create database and Web applications. This course covers data-bound class modules, cursors, connected and disconnected record-sets, enforcing data integrity, active documents, as well as debugging and error handling. In addition, the course details data store integration in Visual Basic 6 applications.

Modules include:

Module 1: Essentials of Microsoft Visual Basic
Module 2: Using Visual Data Access Tools
Module 3: Using Class Modules
Module 4: Building ActiveX Controls
Module 5: Using ActiveX Data Objects
Module 6: Advanced Data Access Issues
Module 7: Using COM Components
Module 8: Building COM Components
Module 9: Optimizing and Deploying an Application
Module 10: Building Internet Applications

MOC 1303: Mastering Microsoft Visual Basic 6 Fundamentals

This course is designed to teach the skills necessary to create Visual Basic 6 desktop applications. This encompasses event-driven programming, dynamic creation of controls, ActiveX data objects, deployment options, extensive debugging and error handling techniques.

Modules include:

Module 1: Introduction to Application Development Using Visual Basic
Module 2: Visual Basic Fundamentals
Module 3: Working with Code and Forms
Module 4: Variables and Procedures
Module 5: Controlling Program Execution
Module 6: Debugging
Module 7: Working with Controls
Module 8: Data Access Using the ADO Data Control
Module 9: Input Validation
Module 10: Error Trapping
Module 11: Enhancing the User Interface
Module 12: Drag and Drop
Module 13: More About Controls
Module 14: Finishing Touches

MOC 1587: Introduction to Programming With Microsoft Visual Basic 6

This course instructs on how to design program logic and utilize programming constructs. Through this course, students gain a strong, accessible, hands-on foundation in the language skills needed to develop Microsoft Visual Basic business applications. The course covers temporary and permanent data storage, program optimization, the component object model, and methods of interaction with forms.

Module include:

Module 1: Overview
Module 2: Application Development
Module 3: Designing Program Logic
Module 4: Programming Syntax
Module 5: Procedures and Modules
Module 6: Data Storage
Module 7: Advanced Data Storage
Module 8: Operators
Module 9: Decision-Making Constructs
Module 10: Looping Constructs
Module 11: Adding a User Interface to an Application
Module 12: COM Programming
Module 13: Windows NT Services
Module 14: Performance Measurement Tools for Win32-based Applications

Business Software Design

MOC 2710: Analyzing Requirements and Defining Microsoft .NET Solution Architectures

This course provides students with the knowledge and skills needed to design Microsoft .NET-connected solutions to business problems. Students participate in activities and tutorials to gather and analyze information for designing a business solution, create vision/scope documents, create the conceptual design, logical design and physical design for a business solution,.

Modules include:

Module 1: Introduction to Designing Business Solutions
Module 2: Gathering and Analyzing Information
Module 3: Envisioning the Solution
Module 4: Creating the Conceptual Design
Module 5: Creating the Logical Design
Module 6: Creating the Physical Design
Module 7: Designing the Presentation Layer
Module 8: Designing the Data Layer
Module 9: Designing Security Specifications
Module 10: Completing the Planning Phase
Module 11: Stabilizing and Deploying the Solution

MOC 1846: Microsoft Solutions Framework Essentials

This course is designed to expose students to the key elements of the Microsoft Solutions Framework. These key elements include the MSF Team and Process models as well as the Risk Management, Project Management, and Readiness Management Disciplines. The course utilizes a combination of presentation lectures and hands-on activities geared toward utilizing the MSF to provide an improved solution strategy that can alleviate the challenges to delivering technology solutions.

Modules include:

Module 1: Introduction to the Microsoft Solutions Framework
Module 2: Building an MSF Team
Module 3: Managing Project Risks
Module 4: Establishing Your Project Life Cycle
Module 5: Starting Your Project
Module 6: Planning Your Project
Module 7: Developing Your Solution
Module 8: Stabilizing Your Solution
Module 9: Deploying Your Solution

MOC 1585: Gathering and Analyzing Business Requirements

This workshop teaches how to gather, analyze, and present business processes and requirements by developing and communicating a vision document that captures the solution goals. The workshop includes portions about modeling dynamic behavior as well as determining requirements, wants and constraints. The workshop trains on developing designs using the appropriate Microsoft Solutions Framework (MSF) models and processes.

Modules include:

Module 1: Course Overview
Module 2: Identifying Business Processes, Challenges, and Vision
Module 3: Characteristics of Information
Module 4: Gathering Information
Module 5: Analyzing Information: Use Cases and Usage Scenarios
Module 6: Analyzing Information: Rationalizing Information
Module 7: Presenting Information

MOC 1608: Designing Business Solutions

This workshop covers the use of Microsoft Solutions Framework models and processes to create conceptual, logical, and physical designs for a business solution. This involves learning how to select suitable technologies and architectures for solutions based on trade-off analysis, creation of baseline functional specifications, identifying attributes and relationships, and risk mitigation. Clarification on methodologies for assessing the feasibility of proposed solutions within business and technical constraints is also discussed. In addition, the workshop includes dialogue on appropriate types of user interfaces with regard to a complete business solution

Modules include:

Module 1: Course Overview
Module 2: Solution Design Using the MSF
Module 3: A Services-based Approach to Solution Design
Module 4: Business Solution Conceptual Design
Module 5: Business Solution Logical Design
Module 6: Beginning Physical Design
Module 7: Selecting Solution Technologies
Module 8: Solution Design and the Component Object Model
Module 9: Designing Solutions with Microsoft Technologies
Module 10: Completing Physical Design
Module 11: Designing the Presentation Layer
Module 12: Introduction to Functional Specifications

Microsoft SQL Server 2005

Course 2936: Installing and Securing Microsoft SQL Server 2005

This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.

Understanding the SQL Server 2005 Architecture
Overview of SQL Server 2005
Enhancements to SQL Server 2005 Components
Understanding SQL Server 2005 Features
Introducing SQL Server 2005 Extensibility Components
System Enhancements for Administrators
Installing SQL Server 2005
Performing a SQL Server 2005 Installation
Maintaining a SQL Server 2005 Installation
Lab: Installing SQL Server 2005
Securing SQL Server 2005
Managing SQL Server 2005 Security
Managing Schemas and Controlling Execution Context
Managing Permissions
Managing Certificates
Lab: Securing a SQL Server 2005 Database

Course 2937: Administering and Monitoring Microsoft SQL Server 2005

Exploring SQL Server 2005 Administrative Tools
Using SQL Server Management Studio
Using SQL Computer Manager
Using the sqlcmd Utility
Using the SQL Management Objects
Lab: Administering SQL Server 2005
Monitoring SQL Server 2005
Using DDL Triggers
Using Event Notifications
Using Metadata Views
Lab: Monitoring SQL Server 2005
Maintaining Databases and Indexes
Using the Database Tuning Advisor
Lab: Maintaining a Database

Course 2938: Data Availability Features in Microsoft SQL Server 2005

Understanding Disaster Recovery
Using Database Snapshots
Understanding Backup and Restore Operations
Lab: Managing Disaster Recovery in SQL Server 2005
Understanding Data Availability in SQL Server 2005
Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring
Configuring the Mirror Server and Database
Lab: Maintaining Availability in SQL Server 2005
Understanding SQL Server 2005 Replication Features
Overview of Replication Enhancements
Introducing New Types of Replication in SQL Server 2005
Configuring Replication

Course 2939: Programming Microsoft SQL Server 2005

This course will enable database developers experienced with SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.

Working with SQL Server 2005
Exploring Components and Features
Using the SQL Server 2005 Developer Tools
Implementing the Security Features in SQL Server 2005
Lab: Exploring SQL Server 2005
Exploring Transact-SQL Enhancements in SQL Server 2005
Using Data Definition Language Enhancements
Using Data Manipulation Language Enhancements
Using Structured Exception Handling
Lab: Programming with Transact-SQL
Exploring the Use of XML in SQL Server 2005
Using XML Enhancements in SQL Server 2005
Using the xml Data Type
Using XQuery
Lab: Working with XML

Course 2940: Building Services and Notifications Using Microsoft SQL Server 2005

This course will enable database developers experienced in SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.

Using Service Broker
Exploring Service Broker
Exploring Service Broker Architecture
Implementing Service Broker
Lab: Using Service Broker
Using Native HTTP Support
Exploring Native HTTP Support
Configuring Native HTTP Support
Lab: Implementing a Web Service with HTTP Endpoints
Using Notification Services
Module Introduction
Exploring Notification Services Architecture
Exploring the Notification Services Process
Configuring Notification Services Solutions
Lab: Using Notification Services

Course 2941: Creating the Data Access Tier Using Microsoft SQL Server 2005

This course will enable database developers experienced with SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or on the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.

Using the .NET CLR in SQL Server 2005
Exploring SQL Server and the .NET CLR
Creating and Registering Managed Database Objects
Implementing Managed Code in SQL Server 2005
Creating Managed Code in SQL Server 2005
Using Database Objects with Visual Studio 2005
Lab: Implementing Managed Code in the Database
Developing Client Applications
Developing Client Applications with ADO.NET
ADO.NET Enhancements in the .NET Framework 2.0
Using Data Binding in .NET Framework 2.0
Using SQL Management Objects
Exploring the Use of SQL Management Objects
Creating and Modifying Objects
Using Replication Management Objects
Lab: Using SQL Management Objects

Course 2942: New Features of Microsoft SQL Server 2005 Analysis Services

This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The course is designed for either the planning/design phase of technology adoption, or on implementation issues specific to the build, deployment and management phases. The course provides detailed reference content and in-depth practical and hands-on activities.

Exploring SSAS Core Concepts and Architecture
SSAS Core Concepts
New Features in the SSAS Architecture
Designing and Deploying a Unified Dimensional Model
Creating an Analysis Services Project
The Business Intelligence Development Studio
Building a Cube
Implementing Advanced Features of a Cube
Lab: Building a Cube
Administering SSAS
Upgrading and Migrating to SSAS 2005
Configuring Roles, Groups, and Permissions
Managing SSAS
Managing Partitions and Real Time BI
Lab: Administering SSAS
Programming in SSAS 2005
Exploring SQL Server Management Studio
New Features of MDX
Scripting with MDX
New Programming Features
Lab: Programming in SSAS 2005
Working with Data Mining Solutions in SSAS
Data Mining Concepts and New Features
An Introduction to Data Mining
Exploring Data Mining Models
Working with Data Mining Tools
Lab: Working with Data Mining Solutions

Course 2943: Updating Your Data ETL Skills to Microsoft SQL Server 2005 Integration Services

Exploring SSIS Architecture and Core Concepts
SSIS Architecture
SSIS Core Concepts
Designing and Debugging SSIS Packages
Creating Package Control Flow
Creating Package Data Flow
Designing for Scalability and Performance
Debugging SSIS Packages
Lab: Creating and Debugging a Package
Rich Functionality in SSIS
Configuring and Deploying SSIS Packages
Enhancing ETL Operations
Working with Transformations
Lab: Configuring and Deploying a Package
Extensibility
Programmability
Beyond ETL
Lab: Transforming an RSS Feed

Course 2944: Updating Your Reporting Skills to Microsoft SQL Server 2005 Reporting Services

This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The Course is designed for either the planning/design phase of technology adoption, or on implementation issues specific to the build, deployment and management phases. The Course provides detailed reference content and in-depth practical and hands-on activities.

Exploring the Features and Core Concepts of SSRS
Features of SSRS
SSRS Core Concepts
Designing Reports Using Report Designer
Designing Reports Using the Report Wizard
Working with Data Regions
Lab: Designing a Report
Deploying and Managing Reports
Deploying Reports
Managing Reports
Lab: Deploying and Managing a Report
Working with Ad Hoc Reports
Using Report Model Designer
Using Report Builder
Lab: Creating an Ad Hoc Report

Microsoft SQL Server 2000

MOC 2092: Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services

This course provides individuals with the knowledge and skills necessary to design relational star schema structures; to design data extraction, transformation, and loading programs; and to populate relational data marts using Data Transformation Services. This encompasses implementing Data Driven Query solutions, DTS packages, workflow design, data pump tuning and optimization techniques, options of data loading, and ActiveX data transformations.

Modules include:

Module 1: Using DTS in a Data Warehouse
Module 2: Defining Data Warehouse Structures
Module 3: Populating Data Warehouse Structures
Module 4: Using the DTS Import/Export Wizard
Module 5: Understanding DTS Package Elements
Module 6: Copying and Managing Data
Module 7: Performing Data Transformations
Module 8: Extending Transformations
Module 9: Implementing Data Driven Query Solutions
Module 10: Storing DTS Packages and Metadata
Module 11: Executing Packages
Module 12: Managing Package Properties
Module 13: Building Advanced Workflows
Module 14: Applying Best Practices
Module 15: Case Study - Populating the Shipments Star

MOC 2073: Programming a Microsoft SQL Server 2000 Database

This course provides individuals with the technical skills required to program a database solution by using Microsoft SQL Server 2000. This course teaches how to design a SQL Server enterprise application architecture; describe the conceptual basis of programming in Transact-SQL; create and manage databases and their related components; implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers; plan for the use of, create and maintain indexes; create, use, and maintain data views; implement user-defined functions; design, create, and use stored procedures; create and implement triggers; program across multiple servers by using distributed queries, distributed transactions, and partitioned views; optimize query performance; analyze queries; and manage transactions and locks to ensure data concurrency and recoverability.

Modules include:

Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing User-defined Functions
Module 11: Implementing Triggers
Module 12: Programming Across Multiple Servers
Module 13: Optimizing Query Performance
Module 14: Analyzing Queries
Module 15: Managing Transactions and Locks

MOC 2072: Administering a Microsoft SQL Server 2000 Database

This course provides individuals with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. This includes planning for a SQL Server installation, determining hardware requirements, security methods, optimizing performance, replication, maintaining high availability as well as backup and restore procedures and options.

Modules include:

Module 1: SQL Server Overview
Module 2: Planning to Install SQL Server
Module 3: Managing Database Files
Module 4: Managing Security
Module 5: Performing Administrative Tasks
Module 6: Backing Up Databases
Module 7: Restoring Databases
Module 8: Monitoring SQL Server for Performance
Module 9: Transferring Data
Module 10: Maintaining High Availability
Module 11: Introducing Replication

MOC 2071: Querying Microsoft SQL Server 2000 with Transact-SQL.

This course instructs on the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000. This covers the use of and ways to execute the Transact-SQL language particularly stored procedures, functions, triggers, views, and nested queries. Also included instruction on the use SQL query analyzer, OSQL utility, and syntax issues.

Modules include:

Module 1: Introduction to Transact-SQL
Module 2: Using Transact-SQL Querying Tools
Module 3: Retrieving Data
Module 4: Grouping and Summarizing Data
Module 5: Joining Multiple Tables
Module 6: Working with Subqueries
Module 7: Modifying Data
Module 8: Querying Full-Text Indexes
Module 9: Introduction to Programming Objects

MOC 1609: Designing Data Services and Data Models

This workshop teaches participants to derive conceptual data storage and data access requirements from business requirements. This includes developing entity/relationship (ER) models, normalizing a logical data models, creating optimized physical data models, selecting the appropriate types and locations of data integrity requirements given constraints, and selecting appropriate data access and data storage technologies for solutions.

Modules include:

Module 1: Course Overview
Module 2: Solution Design Processes
Module 3: Using a Conceptual Design for Data Requirements
Module 4: Deriving a Logical Data Design
Module 5: Normalizing the Logical Data Design
Module 6: : Deriving a Physical Data Design
Module 7: Implementing Data Integrity
Module 8: Designing Data Services
Module 9: Data Storage Considerations

Introduction to Microsoft SQL and Relational Database Design

This course instructs on the general principles involved in designing a database that complies with the relational database model and how to utilize the Transact-SQL language to access and manipulate data.

Module 1: Introduction to Relational Databases
The Basics of Relational Databases
Planning the Database
Identifying Database Design Issues
Creating Databases
Managing Databases
Module 2: Designing Tables
Deciding on Tables and Fields
Selecting Primary Key Fields
Identifying Table Relationships
More on Keys and Relationships
Design and Create Tables
Maintaining Tables
Module 3: Data Normalization
Solving Data Problems
Higher Normal Forms
Module 4: Data Integrity
Understanding Data Integrity
Implementing Constraints
Referential Integrity
Field-level Integrity
Table-level Integrity
Reviewing and Finalizing the Database Design
Module 5: Query Basics
Performing Queries
Multiple Table Queries
Module 6: More on Queries
Other Types of Queries
SQL
Optimizing Query Performance
Module 7: An Overview of SQL Server
Exploring the Components of SQL Server
SQL Server Database Structure
SQL Server Architecture
Identifying SQL Server Management Tasks
Module 8: Exploring Transact-SQL
Working with Transact-SQL
Transact-SQL Statements
Programming in Transact-SQL
Module 9: Implementing Indexes
Designing Indexing
Implementing Indexes
Maintaining Indexes
Module 10: Joining Tables
Querying Multiple Tables
Implementing Advanced Table Joins
Module 11: Creating Stored Procedures
Designing Stored Procedures
Creating Stored Procedures
Using Parameters in Stored Procedures
Managing Stored Procedures
Module 12: Using Functions
Working with Aggregate Functions
Designing and Creating User-Defined Functions
Module 13: Creating Triggers
Designing and Implementing Triggers
Module 14: Understanding Transactions and Locks
Designing and Implementing Transactions
Managing Locks
Module 15: Optimizing Queries
Exploring the Query Optimizer
Using Indexes to Optimize Queries
Module 16: Analyzing Queries
Analyzing the Performance of Queries

Microsoft Windows 2003

MOC 2210: Updating Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003

This instructor-led workshop provides individuals with the knowledge and new skills that they need to plan and maintain a Microsoft Windows Server 2003 networked environment. This workshop is discovery-based and consists primarily of labs providing hands-on experience focused on the skills required for planning, implementing, and maintaining a Microsoft Windows Server 2003 environment. This includes planning and implementing new security options, cross-forest trusts, group policy options, replication configurations, and otherwise use the new features in Windows Server 2003 that pertain to the systems engineer job role.

Modules include:

Module 1: Introduction to Performing Systems Engineer Skills in Windows Server 2003
Module 2: Planning a DNS Namespace Design
Module 3: Planning Active Directory Deployment
Module 4: Implementing DNS with Active Directory
Module 5: Troubleshooting TCP/IP, Name Resolution, and Group Policy
Module 6: Planning and Implementing Multiple Forests in Active Directory
Module 7: Using Group Policy in Windows Server 2003 to Deploy and Restrict Software
Module 8: Using Group Policy in Windows Server 2003 to Set Advanced Security Settings
Module 9: Planning and Implementing Secure Routing and Remote Access

MOC 2209: Updating Systems Administrator Skills from Microsoft Windows 2000 to Windows Server 2003

This instructor-led workshop provides individuals with the knowledge and skills to manage and maintain a Microsoft Windows Server 2003 networked environment. This workshop is discovery-based and consists primarily of labs that provide hands-on experience focused exclusively on the skills that are required to managing and maintaining a Microsoft Windows Server 2003 environment. This includes managing and supporting new remote server management options, disaster recovery solutions, Active Directory elements, client system management tools, and domain environment management tools.

Modules include:

Module 1: Introduction to Systems Administration in Windows Server 2003
Module 2: Managing Users, Computers, and Groups
Module 3: Using the GPMC to Manage Group Policy
Module 4: Managing Resources and Security
Module 5: Managing DNS
Module 6: Managing Servers
Module 7: Managing Terminal Services
Module 8: Managing IIS 6.0 Web Services
Module 9: Maintaining Software by Using Software Update Services
Module 10: Managing Disaster Recovery

Microsoft Windows 2000

MOC 2151: Microsoft Windows 2000 Network and Operating System Essentials

This course provides individuals with the knowledge and skills necessary to understand and identify the tasks involved in supporting Windows 2000 networks. This course is designed to provide an overview of networking concepts and how they are implemented in Windows 2000. Topics include: security, administration, protocols, data transfer, architecture, remote access, Internet and intranet connectivity.

Modules include:

Module 1: Introduction to Windows 2000 and Networking
Module 2: Administration of a Windows 2000 Network
Module 3: Securing a Windows 2000 Network
Module 4: Examining the Network
Module 5: Examining Network Protocols
Module 6: Examining TCP/IP
Module 7: Examining IP Addressing
Module 8: Optimizing IP Address Allocation
Module 9: Examining Web Services

MOC 2152: Implementing Microsoft Windows 2000 Professional and Server

This course is for individuals who will be responsible for installing, configuring, customizing, and supporting Microsoft Windows 2000 Professional and Windows 2000 Server. This course provides individuals with the knowledge and skills necessary to install and configure Microsoft Windows 2000 Professional on stand-alone and client computers that are part of a workgroup or domain. In addition, this course provides the skills and knowledge necessary to install and configure Windows 2000 Server to create file, print, Web, and Terminal servers.

Modules include:

Module 1: Installing or Upgrading to Windows 2000
Module 2: Configuring the Windows 2000 Environment
Module 3: Connecting Windows 2000 based Clients to Networks
Module 4: Creating and Managing User Accounts
Module 5: Managing Access to Resources by Using Groups
Module 6: Managing Data by Using NTFS
Module 7: Providing Network Access to File Resources
Module 8: Monitoring and Optimizing Performance in Windows 2000
Module 9: Implementing Security in Windows 2000
Module 10: Configuring Printing
Module 11: Configuring Windows 2000 for Mobile Computing
Module 12: Configuring and Managing Disks
Module 13: Implementing Disaster Protection
Module 14: Installing and Configuring Terminal Services
Module 15: Implementing Windows 2000 Clients
Module 16: Implementing Windows 2000 based Servers

MOC 2153: Implementing a Microsoft Windows 2000 Network Infrastructure

This course is for support professionals who will be responsible for installing, configuring, managing, and supporting a network infrastructure that uses the Microsoft Windows 2000 Server products. This course covers the configuration of DNS, WINS, DHCP, IPSec, RIS, IAS, VPNs, IIS, and enabling network connectivity between NetWare, Macintosh, and UNIX networks. Troubleshooting and resolving network issues are stressed along with best practices.

Modules include:

Module 1: Introduction to Microsoft Windows 2000 Networking Infrastructure
Module 2: Automating Internet Protocol (IP) Address Assignment
Module 3: Implementing Name Resolution Using DNS
Module 4: Implementing Name Resolution by Using WINS
Module 5: Configuring Network Security by Using Public Key Infrastructure
Module 6: Configuring Network Security by Using IPSec
Module 7: Configuring Remote Access
Module 8: Supporting Remote Access to a Network
Module 9: Extending Remote Access Capabilities by Using IAS
Module 10: Configuring a Windows 2000–Based Server As a Router
Module 11: Configuring Internet Access for a Network
Module 12: Configuring a Web Server
Module 13: Deploying Windows 2000 Professional by Using RIS
Module 14: Managing a Windows 2000 Network
Module 15: Troubleshooting Windows 2000 Network Services
Module 16: Configuring Network Connectivity Between Operating Systems

MOC 2154: Implementing and Administering Microsoft Windows 2000 Directory Services

This course provides students with the knowledge and skills necessary to install, configure, and administer Windows 2000 Active Directory. The course also focuses on the tasks required to implement Group Policy to centrally manage users and computers. The course covers the specifics of DNS Name Resolution required to support Active Directory, publishing resources, delegating administrative control, creating custom administrative tools, working with group policy objects, administrative templates and managing user environments.

Modules include:

Module 1: Introduction to Active Directory in Windows 2000
Module 2: Implementing DNS to Support Active Directory
Module 3: Creating a Windows 2000 Domain
Module 4: Setting Up and Administering Users and Groups
Module 5: Publishing Resources in Active Directory
Module 6: Delegating Administrative Control
Module 7: Implementing Group Policy
Module 8: Using Group Policy to Manage User Environments
Module 9: Using Group Policy to Manage Software
Module 10: Creating and Managing Trees and Forests
Module 11: Managing Active Directory Replication
Module 12: Managing Operations Masters
Module 13: Maintaining the Active Directory Database
Module 14: Implementing an Active Directory Infrastructure

MOC 2126: Managing a Microsoft Windows 2000 Network Environment

This course provides the knowledge required by individuals to perform installation and configuration tasks, as well as network and operating system management tasks. The course covers the concepts of centralized management and decentralized administration of a Windows 2000 network, publishing resources, troubleshooting the DNS query process, replication, preparing for disaster recovery, configuring and managing user environments.

Modules include:

Module 1: Introduction to Managing a Windows 2000 Network
Module 2: Introducing Active Directory
Module 3: Managing Shared Network Resources
Module 4: Delegating Administrative Control
Module 5: Managing DNS
Module 6: Examining Active Directory Replication
Module 7: Implementing Group Policy
Module 8: Using Group Policy to Manage the Desktop Environment
Module 9: Managing Network Security
Module 10: Managing Web Services
Module 11: Managing Remote Access
Module 12: Implementing and Managing DHCP
Module 13: Implementing Name Resolution
Module 14: Troubleshooting Client Computer Startup and User Logon Problems

MOC 2150: Designing a Secure Microsoft Windows 2000 Network

This course provides individuals with the knowledge and skills necessary to design a security framework for small, medium, and enterprise networks by using Microsoft Windows 2000 technologies. This course contains materials that describe how to provide security-enhanced access to local network users, remote users and remote offices, between private and public networks, and to partners.

Modules include:

Module 1: Assessing Security Risks
Module 2: Introducing Windows 2000 Security
Module 3: Planning Administrative Access
Module 4: Planning User Accounts
Module 5: Securing Windows 2000–Based Computers
Module 6: Securing File and Print Resources
Module 7: Securing Communication Channels
Module 8: Providing Security-Enhanced Access to Non-Microsoft Clients
Module 9: Providing Security-Enhanced Access to Remote Users
Module 10: Providing Security-Enhanced Access to Remote Offices
Module 11: Providing Security-Enhanced Network Access to Internet Users
Module 12: Providing Security-Enhanced Internet Access to Network Users
Module 13: Extending the Network to Partner Organizations
Module 14: Designing a Public Key Infrastructure
Module 15: Developing a Security Plan

MOC 1562: Designing a Microsoft Windows 2000 Networking Services Infrastructure

This course provides individuals with the knowledge and skills necessary to design a networking services infrastructure for Microsoft Windows 2000. Topics include design decisions for TCP/IP, WINS, DNS, DHCP and Proxy Server. This course also provides students with the information and skills needed to support network applications. Some Microsoft Windows® 2000 network solutions require a single technology, such as DHCP, to provide Internet Protocol (IP) address configuration support. In other situations, several technology options exist, such as Open Shortest Path First (OSPF), Routing Information Protocol (RIP), and Internet Group Management Protocol (IGMP), to design an IP routing scheme. This course focuses on designing the network foundation, designing internet connectivity, designing extranet connectivity, and creating an integrated network services infrastructure design.

Modules include:

Module 1: Windows 2000 Networking Overview
Module 2: Designing a TCP/IP Solution
Module 3: Designing an Automated IP Configuration Service Using DHCP
Module 4: Designing a Name Resolution Service Using DNS
Module 5: Designing a NetBIOS Name Resolution Service Using WINS
Module 6: Designing Internet Connectivity Using Network Address Translation
Module 7: Designing Internet Connectivity Using Proxy Server 3.0
Module 8: Designing Connectivity Between Private Networks
Module 9: Designing Remote User Connectivity
Module 10: Designing a Remote Access Solution Using RADIUS
Module 11: Developing a Windows 2000 Network Management Strategy
Module 12: Designing Strategies for Combining Services
Module 13: Creating Networking Service Designs to Support Applications

MOC 1561: Designing a Microsoft Windows 2000 Directory Services Infrastructure

This course provides individuals with the knowledge and skills necessary to design a Microsoft Windows 2000 directory services infrastructure in an enterprise network. Strategies are presented to assist individuals in identifying the information technology needs of an organization, and then designing an Active Directory structure that meets those needs.

Modules include:

Module 1: Introduction to Designing a Directory Services Infrastructure
Module 2: Designing an Active Directory Naming Strategy
Module 3: Designing Active Directory to Delegate Administrative Authority
Module 4: Designing a Schema Policy
Module 5: Designing Active Directory to Support Group Policy
Module 6: Designing an Active Directory Domain
Module 7: Designing a Multiple Domain Structure
Module 8: Designing an Active Directory Site Topology
Module 9: Designing an Active Directory Infrastructure

MOC 2087: Implementing Microsoft Windows 2000 Clustering

This course provides the knowledge and skills necessary to implement and administer server clusters and network load balancing using Windows 2000 Advanced Server. The goal of this course is to provide individuals with the skills to select the appropriate implementation of business solutions that require fault tolerance and high availability. Topics encompass hardware considerations, installation, administration and troubleshooting.

Modules include:

Module 1: Introduction to Windows Clustering
Module 2: Concepts of Server Clusters
Module 3: Preparing for Cluster Service Installation
Module 4: Installing Cluster Service
Module 5: Cluster Administration
Module 6: Creating Cluster Resources
Module 7: Server Cluster Maintenance and Troubleshooting
Module 8: Concepts of Network Load Balancing Cluster
Module 9: Installing and Configuring Network Load Balancing
Module 10: Network Load Balancing Cluster Administration
Module 11: Troubleshooting a Network Load Balancing Cluster
Module 12: Microsoft Windows 2000 Clustering

MOC 2010: Designing a Microsoft Windows 2000 Migration Strategy

This course provides individuals with the knowledge and skills necessary to design a migration strategy for a network running Microsoft Windows NT 4.0 to Microsoft Windows 2000 by describing the planning processes and implications involved. This includes determining possible migration paths, evaluating upgrade decision points, evaluating restructure decision points, as well as considering administration and security plans.

Modules include:

Module 1: Introduction to Developing a Migration Strategy
Module 2: Choosing a Migration Path to Windows 2000 Active Directory
Module 3: Developing a Domain Upgrade Strategy
Module 4: Minimizing the Impact on Network Operations During an Upgrade
Module 5: Restructuring Domains
Module 6: Developing a Domain Restructure Strategy
Module 7: Minimizing the Impact on Network Operations During a Domain Restructure
Module 8: Planning to Deploy a Migration Strategy

MOC 2295: Implementing and Supporting Microsoft Internet Information Services 5.0

This course provides content on the implementation and support of Microsoft IIS 5.0, which includes tasks associated with installing, configuring, administering, monitoring, optimizing and troubleshooting. The course covers the numerous configuration options available and their use to achieve specific outcomes. In addition, instruction is given on how to secure Microsoft Internet Information Services 5.0.

Modules include:

Module 1: Installing Internet Information Services 5.0
Module 2: Configuring Web and FTP Sites
Module 3: Administering Web and FTP Sites
Module 4: Installing and Configuring Web Applications
Module 5: Implementing Security on a Web Server
Module 6: Monitoring and Optimizing a Web Server
Module 7: Configuring IIS to Provide E-Mail Support
Module 8: Managing FrontPage-Extended Webs
Module 9: Implementing IIS 5.0

MOC 2159: Deploying and Managing Microsoft Internet Security and Acceleration Server 2000

The goal of this course is to provide individuals with the knowledge and skills to deploy and manage Microsoft Internet Security and Acceleration (ISA) Server 2000 in an enterprise environment. The course covers the use of ISA Server as a cache server, virtual private network server and as an enterprise firewall.

Modules include:

Module 1: Overview of Microsoft ISA Server
Module 2: Installing and Maintaining ISA Server
Module 3: Enabling Security-Enhanced Internet Access
Module 4: Configuring Caching
Module 5: Configuring Access for Remote Clients and Networks
Module 6: Configuring the Firewall
Module 7: Configuring Access to Internal Resources
Module 8: Monitoring and Reporting
Module 9: Configuring ISA Server for an Enterprise

Microsoft Exchange 2000

MOC 1572: Implementing and Managing Microsoft Exchange 2000

This course provides individuals with the knowledge and skills necessary to install, configure, and manage Exchange 2000 Server. This also includes Exchange’s integration with Active Directory, data conferencing, disaster recovery, auditing and logging. The course goes into substantial detail in troubleshooting issues with Exchange 2000. The course also covers monitoring, optimizing and tuning Exchange for best performance.

Modules include:

Module 1: Introduction to Microsoft Exchange 2000
Module 2: Installing Microsoft Exchange 2000
Module 3: Administering Microsoft Exchange 2000
Module 4: Creating and Managing Storage Groups and Stores
Module 5: Creating and Managing Recipient Objects
Module 6: Creating and Managing Public Folders
Module 7: SMTP in Microsoft Exchange 2000
Module 8: Message Routing in Microsoft Exchange 2000
Module 9: Message Flow in Microsoft Exchange 2000
Module 10: Configuring Internet Protocols
Module 11: Accessing Microsoft Exchange 2000 with Outlook Web Access
Module 12: Configuring Instant Messaging
Module 13: Implementing Microsoft Exchange 2000 Conferencing Server
Module 14: Monitoring Microsoft Exchange 2000
Module 15: Disaster Recovery in Microsoft Exchange 2000
Module 16: The Microsoft Exchange 2000 Challenge

MOC 1573: Designing Microsoft Exchange 2000 for the Enterprise

This course provides individuals with the knowledge and skills necessary to design a Microsoft Exchange 2000 organization for an enterprise environment. This course focuses on designing an environment that is based on the business needs of an organization that requires multiple routing and administrative groups. The course covers how Exchange 2000 uses Active Directory and DSAccess as well as how and why to use all the options that exist for organizations interested in using Exchange.

Modules include:

Module 1: Introduction to Designing Exchange 2000 for the Enterprise
Module 2: Analyzing Active Directory for Exchange 2000
Module 3: Designing an Administrative Plan
Module 4: Designing a Routing Topology
Module 5: Designing a Public Folder Strategy
Module 6: Designing a Security Strategy
Module 7: Planning Server Roles and Placement
Module 8: Designing an Exchange 2000 Management and Operations Plan
Module 9: Designing an Exchange 2000 Clustering Strategy
Module 10: Designing an Exchange 2000 Management and Operations
Module 11: Northwind Traders Design Review

Microsoft Access

Microsoft Access 2000 - Part One

This course covers how to design and create databases, tables, queries, forms, reports and the basic skills necessary to use Access 2000.

Lesson 1: Overview of Access 2000
Introduction to Database Concepts and Terminology
Introduction to Access 2000
Database Planning and Design
Lesson 2: Creating tables
Examining a Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Primary Keys
Lesson 3: Working with tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query
Lesson 5: Creating and Using Forms
Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms
Lesson 6: Creating and Using Reports
Creating a Report With the Report Wizard
Creating a Report That Contains Totals
Lesson 7: Creating and Maintaining a Database
Creating a Database
Managing a Database and Its Objects
Database Maintenance
Lesson 8: Principles of Table Design
Normalizing Data
Normalizing Data for Fourth and Fifth Normal Forms
Lesson 9: Principles of Table Relationships
Analyzing Table Relationships
Establishing and Testing Referential Integrity
Lesson 10: Table Design Techniques
Data Validation Techniques
Indexing Techniques
Lesson 11: Designing Select Queries
Using Calculated Fields in Queries
Creating Multiple-Table Queries
Lesson 12: Customizing Form Designs
Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Lesson 13: Working with Data Access Pages
Creating Data Access Pages
Integrating with Other Applications
Lesson 14: Customizing Reports
Customizing a Report Created by the Report Wizard
Working with Subreports
Creating a Report in Design View

Microsoft Access 2000 - Part 2

This course teaches how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms. In addition, the course covers Internet-related features, including hyperlinks and the Web toolbar.

Lesson 1: Parameter and Action Queries
Creating parameter queries
Creating action queries
Lesson 2: Query Joins and Crosstab Queries
Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets
Lesson 3: Using Advanced Form Techniques
Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform
Lesson 4: Creating Basic Macros to Automate Forms
Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form
Lesson 5: Using Macros to Provide User Interaction and Automate Tasks
Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros
Lesson 6: Using Advanced Report Techniques
Customizing the appearance and functionality of a report
Mailing and other types of labels
Lesson 7: Web Capabilities and Data Integration
Using hyperlinks
Data integration

XML

MOC 2524: Developing XML Web Services Using Microsoft ASP.NET

This course teaches individuals how Web Services can be used in solving common problems in the distributed application domain. The goal of this course is to provide individuals with the knowledge and skills that are required to develop Extensible Markup Language (XML) Web services-based solutions to solve common problems in the distributed application domain. The course focuses on using Microsoft Visual Studio .NET and Microsoft ASP.NET to enable students to build, deploy, locate, and consume Web services.

Modules include:

Module 1: The Need for XML Web Services
Module 2: XML Web Service Architectures
Module 3: The Underlying Technologies of XML Web Services
Module 4: Consuming XML Web Services
Module 5: Implementing a Simple XML Web Service
Module 6: Publishing and Deploying XML Web Services
Module 7: Securing XML Web Services
Module 8: Designing XML Web Services
Module 9: Global XML Web Services Architecture

MOC 1913: Exchanging and Transforming Data Using XML and XSLT

This course teaches individuals techniques for exchanging and transforming data by using the Extensible Markup Language (XML) and Extensible Stylesheet Language Transformations (XSLT). The course describes best practices for XML and XSLT and gives compelling examples of the best ways to solve real-world problems. After completing this course, individuals will be able to define XML Path Language (XPath) expressions to locate and filter the content of an XML document; define XSLT style sheets to transform XML documents at the Web browser and Web server; create and change XML structure by using XSLT; use XSLT to merge differe