Maricopa Community Colleges  CIS175AH   19994-20035 
Official Course Description: MCCCD Approval: 03/23/99
CIS175AH 19994-20035 L+L 3 Credit(s) 4 Period(s)
Mastering Enterprise Development
Introduction to enterprise development. Managing business and data services using Microsoft Visual Basic, Component Object Model (COM), Dynamic-Link Libraries (DLL's), Microsoft Transaction Server (MTS), and ActiveX Data Objects (ADO), included. Prerequisites: CIS275AG, or CIS268, or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS175AH   19994-20035 Mastering Enterprise Development
1. Explain client/server architecture. (I)
2. Describe the Component Object Model (COM) and its advantages. (I)
3. Describe the business application used in Enterprise development. (I)
4. Create business services in COM Dynamic-Link Libraries (DLLs) by using Visual Basic. (II)
5. Describe Microsoft Transition Server (MTS) architecture. (III)
6. Create a package with the MTS Explorer. (III)
7. Configure a client computer to use MTS components. (III)
8. Explain MTS transaction services. (IV)
9. Describe the objects in the ActiveX Data Objects (ADO) object hierarchy. (V)
10. Write a MTS component in Visual Basic that retrieves and updates records in a database. (V)
11. Differentiate between data services in MTS objects and a Microsoft Structured Query Language (SQL) Server database. (VI)
12. Implement declarative security for MTS packages. (VII)
13. Implement integrated security by using Windows NT user accounts and Microsoft SQL Security Manager. (VII)
14. Define, create, and implement an interface. (VIII)
15. Create a new message queue. (IX)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS175AH   19994-20035 Mastering Enterprise Development
    I. Business Application
        A. Client/server architecture
          1. Terms
          2. Infrastructure
        B. Component Object Model (COM)
        C. Applications
          1. Island Hopper News
          2. Microsoft Solution Framework
          3. Microsoft Visual Studios
      II. Dynamic-Link Libraries (DLLs)
          A. Class Modules
          B. Methods
          C. Properties
          D. Tests
          E. Register
        III. Microsoft Transition Server (MTS)
            A. Architecture
              1. Multi-user issues
              2. Three-tier applications issues
            B. Components
            C. Packages
            D. MTS Explorer
              1. Views
              2. Packages
            E. Client Application
          IV. MTS Transaction Services
              A. Define
              B. Manage State
              C. Objects
              D. Shared Property Manager
              E. Connections
              F. Debug
            V. ActiveX Data Objects (ADO)
                A. Object Hierarchy
                B. Database
                C. Stored Procedure
                D. Recordset
                E. Batch updates
              VI. Building Stored Procedures
                  A. Data Integrity
                  B. Implementation
                  C. Return Parameters
                  D. Debug
                  E. Conditional Branching
                  F. Looping structures
                  G. Structured Query Language (SQL) Transactions
                VII. Security
                    A. Advantages
                    B. Three-tier vs. two-tier
                    C. Modes
                    D. Permissions
                    E. Best Practices
                  VIII. Interfaces
                      A. Multiple Classes
                      B. Purpose
                      C. Interface Definition Language (IDL)
                      D. Automation
                      E. Binding
                    IX. Messages
                        A. Asynchronous
                        B. Message queue
                    Go to Description    Go to top of Competencies    Go to top of Outline