MCCCD Official Course Competencies:

MST172  20026-20045

Microsoft Visual Basic Distributed Applications

1.

Build Component Object Model (COM) Dynamic-Link Libraries (DLLs) using the Microsoft Visual Basic programming system. (I)

2.

Configure a client to use Microsoft Transaction Server (MTS). (II)

3.

Retrieve and modify records using ActiveX Data Objects (ADO). (III)

4.

Create stored procedures with Structured Query Language (SQL). (IV)

5.

Implement integrated security using Windows user accounts and SQL security. (V)

6.

Create client interfaces with Visual Basic. (VI)

7.

Write a Visual Basic-based application that sends messages to or receives messages from a message queue. (VII)

MCCCD Official Course Outline:

MST172  20026-20045

Microsoft Visual Basic Distributed Applications

I. Enterprise Development

A. Client/server architecture

B. Enterprise development strategy

C. Microsoft development tools

D. Component Object Model (COM) Dynamic-Link Libraries (DLLs)

II. Microsoft Transaction Server (MTS)

A. Overview of MTS

B. MTS architecture

C. MTS Explorer

D. Deploying an MTS component

E. Transaction services

III. Data Access

A. Data access overview

B. Retrieving and modifying records

C. ActiveX Data Objects (ADO)

D. Using ADO and the middle tier

D. Executing stored procedures

IV. Creating Stored Procedures with Structured Query Language (SQL)

A. Microsoft SQL Server overview

B. Implementing business and data services with SQL Server

C. Programming with Transact-SQL

D. Creating stored procedures

V. Security

A. Security in MTS applications

B. Overview of SQL Server security

C. SQL Server integrated security

D. Best practices

VI. Implementing COM with Visual Basic

A. Interfaces

B. Clients and interfaces

C. Binding that Visual Basic uses with objects

D. Interface Definition Language (IDL) files

VII. Advanced Client/Server Technologies

A. Overview

B. Message queuing

C. Server clustering

D. Accessing mainframe data

E. Access to legacy database systems