Windows 2000 MCSD Certification

กก

 Desktop Applications with Microsoft Visual Basic 6.0

  • 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

Distributed Applications with Microsoft Visual Basic 6.0

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

Analyzing Requirements and Defining Solution Architectures

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

 Microsoft SQL Server 2000 Database Design and Implementation

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

Testing

  • Final Test and/or Makeup Test