Back to Search Results

Training Course Summary:

This course will teach Microsoft® Visual Basic® programmers, who currently build desktop applications and access corporate databases, the basics of how to build three-tier client/server solutions.

Pre-Requisites:

This course assumes that the student has intermediate programming competency with the Microsoft Visual Basic programming system. Before attending this course, students must be able to demonstrate the following skills:
• Build and debug a simple Visual Basic-based application
• Invoke and control an Automation server, such as Microsoft Excel or Microsoft Word, from a Visual Basic-based application
• Create COM components using Visual Basic and invoke them from a client application
• Use ActiveX Data Objects to open a database and work with record sets
• Understand and use basic syntax for SQL
Completing either of the following courses satisfies the prerequisite skills listed above:
• Course 1013, Mastering Microsoft Visual Basic 6 Development
• Course 1017, Mastering Web Site Development Using Microsoft Visual InterDev™ 6

Training Course Overview/Content:

At the end of the course, students will be able to:
• Compare traditional client/server development with Internet development and describe Microsoft's enterprise development strategy,
• Use the Application Architecture Model from the Microsoft Solutions Framework to organize applications into user, business, and data services.
• Use the Microsoft Visual Basic programming system to build component object model (COM) dynamic-link libraries (DLLs) and implement them in a multiuser environment using Microsoft Transaction Server (MTS).
• Use MTS to address application infrastructure issues associated with building server-side COM objects that are used by many clients.
• Create COM objects that use MTS services to participate in transactions and that use security.
• Use programming techniques to increase the scalability of COM objects.
• Use ActiveX® Data Objects (ADO) from the middle tier to access data and invoke business and data services implemented in SQL.
• Implement business and data services in a Microsoft SQL Server™ database through the use of stored procedures.
• Apply basic debugging, error handling, and security techniques in a three-tier application.