Microsoft Windows Architecture I: Component and Database Technologies

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Description

This course is the first part of the four part series for the Microsoft Windows Operating Systems and Services Architecture (WOSA) exams I and II.

Audience

This course is intended for experienced application developers who will use Microsoft tools and technologies to design, build and implement business solutions. Participants should have a working knowledge of the Microsoft Visual Basic programming system, Visual Basic for Applications and the Microsoft Office suite.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify factors for the emergence of WOSA, the benefits of WOSA and WOSA components and interfaces.
• Identify the COM model, OLE and ActiveX technologies and structured storage.
• Identify database access technologies.

Topics Include

Unit 1: WOSA: An Introduction

• Identify the need for WOSA.
• Identify the benefits of WOSA.
• Sequence the steps for a front-end Windows application to communicate with a back-end service in WOSA.

Unit 2: Component Technologies

• Identify the reasons for the emergence of Component Object Model (COM).
• Identify the advantages of using components in software applications.
• Identify the requirements a component must meet for application development.
• Match the component architectures with their performance, maintainability, and extensibility features.
• Identify the features of the Component Object Model.
• Identify the benefits of using Component Object Model (COM) for application development.
• Identify the benefits of COM interfaces.
• Identify the uses of the OLE technology as an implementation of the COM.
• Identify the usage of linking and embedding in OLE.
• Identify the advantages of using the OLE drag-and-drop functionality as compared to the copy paste sequence.
• Identify the advantages of OLE compound documents.
• Identify the benefits of OLE custom controls.
• Identify the advantages of using UDT to exchange data between applications.
• Identify the means by which Automation is implemented in WOSA.
• Identify situations in which Remote Automation is used.
• Identify the uses of the ActiveX technology as an implementation of the COM.
• Identify the benefits of ActiveX Documents.
• Identify the facilities provided by ActiveX Scripting.
• Identify which ActiveX technology is appropriate for use in a given business solution.
• Identify the functions performed by ActiveX server components.
• Identify the advantages of compound files as an implementation of structured storage as compared to the conventional file system.
• Identify the features of structured storage.
• Identify the features of the structured storage model.

Unit 3: Database Access Technologies

• Identify the benefits of ODBC.
• Identify how ODBC solves the interoperability problem.
• Match solutions that use ODBC for performance, maintainability, and interoperability with the problems they address.
• Identify the benefits of using ADO.
• Identify the benefits of RDO.
• Identify the advantages of using DAO as compared to ODBC, when working with Microsoft Jet (.MDB) databases.
• Compare DAO with RDO when accessing data on the basis of accessibility and performance.
• Identify the benefits of SQL-DMO.
• Match the appropriate data access tool with the situations in which it is used.
• Compare OLE DB and ODBC API on the basis of data retrieving capabilities.
• Compare OLE DB and native APIs on the basis of data retrieving capabilities.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and XXMB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

© Copyright Serebra Learning Corp., 2002