Maricopa Community Colleges  MST172   20002-20025 
Official Course Description: MCCCD Approval: 11/23/99
MST172 20002-20025 L+L 3 Credit(s) 4 Period(s)
Microsoft Visual Basic Distributed Applications
Knowledge and skills to build three-tier client/server solutions. Use of Microsoft Visual Basic to build Component Object Model (COM) Dynamic-Link Libraries (DLLs). Retrieve and modify records using ActiveX Data Objects (ADO). Create stored procedures with Structured Query Language (SQL). Preparation for Microsoft Certified Solutions Developer (MCSD) examination. Prerequisites: MST170 or permission of instructor.
 
Course Note:Under the terms and conditions specified in the legal agreement between Microsoft Corporation and each AATP campus in the Maricopa Community College District, Microsoft requires that "all instructors of Microsoft Official Curriculum and Microsoft Approved Study Guides pass the Microsoft Certified Professional exam in the product area of the courseware being delivered."
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
MST172   20002-20025 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)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST172   20002-20025 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
                Go to Description    Go to top of Competencies    Go to top of Outline