Visual Studio

Mastering Enterprise Development Using Microsoft Visual Basic 6 (VB) Classroom View
(Microsoft Training Course: 1016) - 5 days - £2640 exc VAT

> Target Audience
This course is intended for Visual Basic programmers building desktop applications and accessing corporate databases.
> Course outline
  1. Introduction to Enterprise Development
  2. Microsoft Solutions Framework
  3. Building COM DLLs
  4. Introduction to Microsoft Transaction Server
  5. MTS Transaction Services
  6. Accessing Data from the Middle Tier
  7. Building Stored Procedures with SQL
  8. Advanced Topics
  9. Conclusion

Supplementary InformationThis course has now retired and is no longer available. We suggest you look at Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2373.aspx}2373: Programming with Microsoft Visual Basic .NET]].
Module 1: Introduction to Enterprise Development
  • Introducing Enterprise Development
  • Introduction to the Microsoft Visual Studio 98 Enterprise Edition’s, Development Studio tools and features
  • Case study using Microsoft technologies, including an introduction to the Island Hopper sample application
  • Describe the architecture of an enterprise solution using the Microsoft Enterprise Development Strategy
  • Select the appropriate Microsoft development tools, products, and technologies to analyze and solve a given business problem
Module 2: Microsoft Solutions Framework
  • Introduction to MSF, including the Team Model, the Process Model, and the Application Architecture Model (Island Hopper)
  • Reviewing the Island Hopper physical design
  • Understand the origins of MSF; and its place in solution development
  • Explain the Solution Development Discipline (SDD) as a part of MSF, for the construction phase of the information technology life cycle
  • Position individual roles in the MSF Team Model, and select the tools for team development
  • List and describe the major phases and deliverables in the MSF Process Model
  • Describe User, Business, and Data services in the MSF Application Architecture Model
  • Differentiate conceptual, logical, and physical design of components, and understand the physical design of the Island Hopper sample application
Module 3: Building COM DLLs
  • Creating/working with COM DLLs
  • Implementing business services with Microsoft Visual Basic
  • Implementing COM interfaces
  • Create Visual Basic class objects
  • Create, debug, and test a COM DLL
Module 4: Introduction to Microsoft Transaction Server
  • Introduction/architecture of MTS
  • Using and deploying a MTS component
  • MTS security architecture
  • Describe MTS architecture, listing issues related to developing multi-user n-tier MTS applications
  • Create a MTS package using MTS Explorer, and set declarative security on a component or package
Module 5: MTS Transaction Services
  • Transactions and the Context Object
  • Component configuration issues
  • Security and Scalability
  • Debugging and Error handling
  • Define a transaction as ACID
  • Understand how MTS uses Two-Phase Commit for a distributed transaction
  • Use MTS Explorer to specify transaction properties for a component
  • Call Context methods from a transacted component
  • Use programmatic security
Module 6: Accessing Data from the Middle Tier
  • Overview and architecture of ActiveX Data Objects (ADO)
  • ADO in the Middle tier
  • ADO Connections and Stored procedures
  • Debugging and Error handling Security Issues
  • Compare and contrast Microsoft data access technologies for enterprise development
  • Write middle-tier components implementing business and data services via ADO
  • Call a stored procedure from ADO
  • Implement ADO error handling
Module 7: Building Stored Procedures with SQL
  • Introduction to Microsoft SQL Server
  • Using data integrity
  • Querying data and writing stored procedures using T-SQL
  • SQL Server security
  • Explain the role of data integrity when implementing Data Services
  • Choose database or MTS services.
  • Implement business and data services using stored procedures written in T-SQL
  • Write and debug stored procedures
  • Review SQL and MTS transactions
Module 8: Advanced Topics
  • Introduction to COM
  • Standard and Custom Interfaces, GUIDs and the Registry
  • COM threading models
  • Define and use COM
  • Create multiple interfaces using Microsoft Visual Basic
  • Use Automation and custom interfaces, and deploy object binding based on performance/flexibility requirements
  • Understand GUIDs and basic Registry settings
  • Describe basic threading concepts, controlling re-entrancy issues when using Apartment Threading
Module 9: Conclusion
  • Review of Microsoft enterprise development and the MSF
  • Alternative design considerations
  • Review and describe the Microsoft Enterprise Development Strategy, through course work
  • Describe alternatives requiring a different approach or different technologies
  • Source information on issues like performance, scalability, or security
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Build/debug simple Visual Basic applications.
  • Invoke and control an Automation server, from Visual Basic.
  • Create/Invoke Visual Basic code components.
  • Use ActiveX Data Objects to open a database and work with Recordsets.
  • Completion of the following courses will satisfy the pre-requisite skills listed above:
  • 1013 - Visual Basic 6.0 Desktop Development
> Purpose
This course will teach programmers the basics of building multiple-tier client/server solutions.
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Course [[{http://www.F1Comp.Co.UK/computer_training/Microsoft_Training_Courses/Visual-Studio-.Net/2373.aspx}2373: Programming with Microsoft Visual Basic .NET]].