About Apex InfoTech Information Services Products Consulting Online Courses Certifications Course Schedule Reserve your seat Search Apex InfoTech Home Page
Course ScheduleSearch by Course NumberPrint this documentEmail this documentRegister for this course

Building Microsoft Transaction Server Components with Microsoft Visual C++ 6

Course 1596: Three days; Instructor-led

Introduction

This course will teach Microsoft® Visual C++™ programmers, who currently build two-tier applications to access corporate databases, to build and deploy Microsoft Transaction Server (MTS) components as part of a three-tier architecture.


At Course Completion

At the end of the course, students will be able to:

  • Describe the architecture of an enterprise solution by using the Microsoft Windows® Distributed interNet Application (DNA) architecture.
  • Identify the key tools and technologies in Microsoft's Enterprise Strategy.
  • Create Component Object Model (COM) objects that use MTS transaction, activation, and security services.
  • Use programming techniques to utilize just-in-time activation, handling of object state, and connection pooling to increase the scalability of an enterprise application.
  • Implement MTS objects that access data from a data source by using ActiveX Data Objects (ADO) and OLE DB consumer templates.
  • Use disconnected recordsets to return data to a client.
  • Apply security techniques such as MTS role-based security, Windows NT™ security, and SQL Server security to three-tier applications.
  • Debug MTS object errors by using tools such as MTS Spy.
  • Implement error handling in MTS objects.
  • Use MTS Administration Objects to automate deployment of MTS packages and components.


Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exam:

  • Exam 70-015: Designing and Implementing Distributed Applications with Microsoft Visual C++ 6.0


Prerequisites

This course assumes that the student has intermediate programming competency with the Microsoft Visual C++ product. Before attending this course, students must be able to demonstrate the following skills:

  • Experience using COM and ATL
  • RDBMS familiarity, including stored procedures, SQL, triggers, tables, and Microsoft SQL Server
  • A basic understanding of the principles of client/server and multitier architectures
  • Familiarity with building client/server software
  • Familiarity with basic principles of enterprise development
  • Familiarity with SQL language
  • Familiarity with Microsoft SQL Server 7.0
  • Experience accessing data sources by using ADO and OLE DB templates

Prerequisite courses:

  • Course 1304, Component Development Using the Active Template Library 3.0
  • Course 1595, Accessing Data with Microsoft Visual C++ 6

      • or

  • Course 1015, Mastering MFC Development Using Microsoft Visual C++ 6

Recommended courses:

  • Course 1016, Mastering Enterprise Development Using Microsoft Visual Basic 6
  • Course 1017, Mastering Web Application Development Using Microsoft Visual InterDev 6
  • Course 1298, Mastering Distributed Application Design and Development Using Microsoft Visual Studio 6
  • Course 1588, Building E-Commerce Solutions: Business-to-Consumer


Course Outline

Day 1

Module 1: Microsoft's Enterprise Development Strategy

Topics

Introduction to Enterprise Development
Island Hopper News Sample Application

Skills

Students will be able to:

  • Explain the general terms related to client/server architecture.
  • Describe the high-level architecture of an enterprise solution by using Microsoft's Enterprise Development Strategy.
  • Describe the Component Object Model (COM) and its advantages.
  • Describe the Island Hopper News sample application used as the business problem in this course.
  • List the Microsoft development tools, products, and technologies that will be used to build the solutions to the course labs.


Module 2: Introduction to Microsoft Transaction Server

Topics

Overview of MTS
MTS Architecture Using the MTS Explorer
Deploying an MTS Component

Lab

Deploying an MTS Package on a Client Computer

Skills

Students will be able to:

  • List the issues related to developing multiuser, three-tier applications and explain how MTS addresses these issues.
  • Describe the MTS architecture.
  • Create a package by using the MTS Explorer.
  • Add an existing component to an MTS package.
  • Configure a client computer to use MTS components.


Module 3: Creating MTS Components

Topics

Overview of MTS Transaction Services
Building MTS Components

Lab

Creating an MTS Component

Skills

Students will be able to:

  • Describe what a transaction is and how it conforms to the ACID properties.
  • Describe how MTS manages context for objects.
  • Participate in transactions by calling the SetComplete, SetAbort, EnableCommit, or DisableCommit methods of the MTS ObjectContext object.


Day 2

Module 4: Debugging and Error Handling

Topics

Handling Errors in MTS
Debugging a Component
Debugging and Monitoring Tools
Analyzing Application Performance by Using Microsoft Visual Studio Analyzer

Lab

Using Microsoft Visual Studio Analyzer

Skills

Students will be able to:

  • Debug an MTS object at run time.
  • Use MTS Spy to monitor component activity.
  • Analyze the performance of an application by using Microsoft Visual Studio Analyzer.


Module 5: Managing Component State

Topics

Overview of Managing Component State
Just-in-Time Activation
The IObjectControl Interface
Storing Object State
The Shared Property Manager

Lab

Using the Shared Property Manager

Skills

Students will be able to:

  • Explain how just-in-time activation affects object state.
  • Use the IObjectControl interface to define context-specific initialization and cleanup procedures.
  • Explain the usefulness of storing state and sharing state between components.
  • Use the Shared Property Manager to store the shared state of MTS components.


Module 6: Advanced Data Access

Topics

Using Stored Procedures
Using ADO and OLE DB in a Distributed Environment
Disconnected Recordsets
Converting an OLE DB Rowset to an ADO Recordset
Session Pooling
Data Access Best Practices
ADO Best Practices
OLE DB Best Practices

Labs

Creating a Disconnected Recordset
Converting OLE DB Data to ADO

Skills

Students will be able to:

  • Choose the appropriate cursor locations, cursor types, and lock types for different enterprise scenarios.
  • Create a disconnected recordset and perform batch updates.
  • Convert an OLE DB rowset into an ADO recordset.
  • Manage database connections efficiently through session pooling.


Day 3

Module 7: Implementing Security

Topics

Introduction to Security
Implementing Declarative Security in MTS Applications
Implementing Programmatic Security in MTS Applications
Implementing Security in SQL Server
Security Best Practices

Labs

Implementing Declarative Security in MTS Applications
Implementing Programmatic Security in MTS Applications
Implementing Security in SQL Server

Skills

Students will be able to:

  • List the advantages of three-tier security over two-tier security in enterprise solutions.
  • Implement declarative security for MTS packages by using MTS roles and Windows NT user and group accounts.
  • Implement programmatic security for MTS packages by using the security methods of IObjectContext and IsecurityProperty.
  • Assign permissions to login by using SQL Server Enterprise Manager.
  • List best practices associated with implementing security in enterprise solutions.


Module 8: Using MTS Administration Objects

Topics

MTS Administration Objects
Scriptable Object Hierarchy
Working with Packages
Working with Components
MTS Administration Programming Best Practices

Lab

Creating a Deployment Program for a Package

Skill

Students will be able to:

  • Create, delete, and modify packages and components by using the MTS Administration objects.


For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100