• Course Overview - Introductions
  • Overview of Windows 2000
  • Introductions of Students/Instructors
  • Testing Procedures and Locations

Chapter 1: Planning the Design of an Application

• Using the Microsoft Solutions Framework
• Designing a System Architecture
• Using Visual SourceSafe

Chapter 2: Using Interface Design Principles

• User Interface Design Principles
• Managing Forms
• Using Controls
• Using Menus

Chapter 3: Validating and Processing User Input

• Overview of Validation
• Implementing Form-Level Validation
• Implementing Field -Level Validation

Chapter 4: Using the Debugging Tools

• Debugging Your Application
• Testing Your Application

Chapter 5: Implementing Error Handling

• Creating an Error Handler
• Using Inline Error Handling
• Implementing Centralized Error Handling

Chapter 6: Introduction to Class Modules

• Introduction to COM
• Using Class Modules
• Creating Class Modules
• Using the Class Builder

Chapter 7: Introduction to ActiveX Documents

• How Visual Basic Accesses Data
• Introduction to OLE DB and ADO
• Overview of Structured Query Language
• The ADO Data Control
• Coding the ADO Data Control

Chapter 8: Developing Solutions Using ADO

• Introducing the ADO Object Model
• Connecting to a Data Source
• Retrieving Data
• Navigating Records
• Modifying Data
• Using the Data Environment

Chapter 9: Connecting to COM Servers

• Connecting to COM Components
• Managing COM Components
• Calling Win32 APIs

Chapter 10: Creating and Managing COM Components

• Overview of Creating COM Components
• Creating ActiveX Controls
• Creating ActiveX Code Components
• Using the Visual Component Manager

Chapter 11: Creating Internet Applications

• Creating DHTML Applications
• Creating ActiveX Documents
• Creating IIS Applications Using WebClasses

Chapter 12: Packaging and Deploying an Application

• Implementing Online Help
• Creating an Executable
• Using the Package and Deployment Wizard

Chapter 1: Application Design Concepts

• Planning a Distributed Solution
• Selecting an Application Architecture
• Using Visual Database Tools

Chapter 2: Creating the User Interface

• Overview of User Interface Elements
• Navigation and Validation

Chapter 3: Creating COM DLLs with Visual Basic

• Creating Class Modules
• Using Class Modules
• Creating COM DLLs and EXEs

Chapter 4: Advanced COM Programming with Visual Basic 6.0

• Creating Custom Interfaces
• Developing a Custom Object Model

Chapter 5: Introducing ActiveX Data Objects

• Overview of Universal Data Access
• Introduction to the ADO Object Model
• Using the Data Environment

Chapter 6: Accessing Data with ActiveX Data Objects

• Managing Connections to Date Source
• Returning Records from a Data Source
• Navigation Records
• Modifying Records

Chapter 7: Advanced Database Topics

• Introduction to Transactions
• Using Disconnected Recordsets
• Asynchronous Operations

Chapter 8: Using Stored Procedures

• Overview of Stored Procedures
• Using Stored Procedures

Chapter 9: Using Microsoft Transaction Server

• Overview of Microsoft Transaction Server
• Installing and Configuring Microsoft Transaction Server
• Creating Solutions Using Microsoft Transaction Server

Chapter 10: Implementing Security in the Enterprise

• Overview of Security
• Implementing SQL Server Security
• Implementing Security in Microsoft Transaction Server
• Implementing COM Security Using DCOMCNFG

Chapter 11: Debugging and Error Handling

• Handling Errors in an application
• Testing and Debugging Middle-Tier Components

Chapter 1: Enterprise Architecture

• What is Architecture?
• Microsoft Solutions Framework (MSF)
• MSF Enterprise Architecture Model
• Creating an Enterprise Architecture

Chapter 2: Enterprise Applications

• Features of Enterprise Applications
• Enterprise Application Architecture
• Guiding Software Principles
• Enterprise Application Model
• MSF Application Model for Development

Chapter 3: Project Teams

• Team Model vs. Hierarchical Models
• Project Responsibilities
• The MSF Development Team Model
• Adapting Team Size to Project Size
• Building Successful Teams

Chapter 4: Development Process

• Models for Application Development
• Waterfall Model
• Spiral Model
• Unified Process
• MSF Development Process Model
• The Four MSF Phases and Their Major Milestones
• MSF Development Process Model Principles
• Using Versioned Processes
• Team Roles in the MSF Development Process Model
• Artifacts and Deliverables
• Relationships Between Models

Chapter 5: Project Vision

• Overview of Project Envisioning
• Envisioning Process
• Risk Management Process
• Vision Approved Milestone and Its Deliverables
• Communicating the Vision
• Expanding the Envisioning Process

Chapter 6: Project Plan

• Overview of Project Planning
• MSF Design Process
• Ongoing Risk Management Process
• Project Plan Approved Milestone and Its Deliverables

Chapter 7: Using Service Layer Technologies

• Determining the User Interface
• Basics of Interface Design
• Creating the UI
• Connecting the User and Business Service Layers

Chapter 8: Business Service Layer Technologies

• Overview of Business Services
• Component Object Model (COM)
• Automation
• COM Support in Distributed Environments
• Packaging with MTS
• Designing MTS Package
• Windows 2000 COM+ Services

Chapter 9: Data Service Layer Technologies

• What is the Data Service Layer?
• Data Modeling
• Microsoft Data Access Components (MDAC)
• Choosing the Right Data Access Technology
• Choosing a Data Access Strategy
• Accessing Host-Based Data
• DCOM Connector for SAP
• COM+ In-Memory Database (IMDB)

Chapter 10: Testing and the Production Channel

• Managing the Development Environment
• Testing Enterprise Applications
• Performance Validation
• Scaling the Production Environment
• Bug Management

Chapter 11: Application Security

• Authentication Security
• Encryption
• Access Security
• Auditing

Chapter 12: Development Deliveries

• Overview of the Developing Phase
• Development Process
• Ongoing Risk Management Process
• Scope Complete Milestone and Deliverables

Chapter 13: Product Stabilization:

• Overview of Stabilization
• Stabilization Process
• Ongoing Risk Management Process
• Release Milestone and Its Deliverables
• Product Deployment

Chapter 14: Project Review

• Case for Project Review
• Project Review Considerations
• Preparation for a Project Review Meeting
• Organizing a Project Review Team
• Capturing Feedback
• Accountability

Chapter 1: Introduction to Microsoft SQL Server 2000

• Overview of SQL Server 2000
• Components of SQL Server 2000
• Overview of SQL Server 2000 Architecture

Chapter 2: Using Transact-SQL on a SQL Server Database

• SQL Server Programming Tools
• Introduction to Transact-SQL
• Transact-SQL Syntax Elements
• Executive Transact-SQL Statements

Chapter 3: Designing a SQL Server Database

• Introduction to Database Design
• Planning a SQL Server Database
• Identifying System Requirements
• Developing a Logistical Data Model

Chapter 4: Implementing SQL Server Databases and Tables

• Creating and Managing a SQL Server Database
• Identifying Data Types
• Creating and Managing Tables

Chapter 5: Implementing Data Integrity

• Introduction to Data Integrity
• Implementing Integrity Constraints

Chapter 6: Accessing and Modifying Data

• Accessing Data in a SQL Server Database
• Using Advanced Query Techniques to Access Data
• Modifying Data in a SQL Server Database

Chapter 7: Managing and Manipulating Data

• Importing and Exporting Data
• Using Distributed Queries to Access External Data
• Using Cursors to Retrieve Data
• Retrieving XML Data

Chapter 8: Implementing Stored Procedures

• Introduction to Stored Procedures
• Creating, Executing, Modifying and Deleting Stored Procedures
• Programming Stored Procedures

Chapter 9: Implementing Triggers

• Introduction to Triggers
• Creating and Managing Triggers
• Programming Triggers

Chapter 10: Implementing Views

• Introduction to Views
• Creating, Modifying and Deleting Views
• Accessing Data through Views

Chapter 11: Implementing Indexes

• Index Architecture
• Index Creation and Administration

Chapter 12: Managing SQL Server Transactions and Locks

• Transaction and Locking Architecture
• Managing SQL Server Transactions
• Managing SQL Server Locking

Chapter 13: Designing and Administering SQL Server 2000 Security

• Overview of SQL Server 2000 Security
• Designing a Database Security Plan
• Database Security Implementation and Administration

Chapter 14: SQL Server Monitoring and Tuning

• Monitoring Databases with SQL Profiler
• Index Tuning and Database Partitioning

• Final Test and/or Makeup Test