StarCom Group Software/Networking Training Center
Microsoft Certified Solution Developer (MCSD II)
MS Windows Architecture I & II
Syllabus (24 hrs teaching, 10 hrs test review)

MCSD II - Part I.

Course Objectives:

At the end of this course, the students will be able to:
  • Describe Component Object Model (COM) technology.
  • Compare and contrast ActiveX technologies.
  • Describe the available Microsoft database interfaces (such as DAO, RDO, ADO, ODBC API, and OLE DB).
  • Compare and contrast the different Windows operating systems.
  • Describe how to use Microsoft Office as a development environment.
  • Describe the development tools available in the Microsoft Visual Studio development system.
  • Explain how the Microsoft BackOffice family supports enterprise solutions
  • Describe how to manage development projects using the Microsoft Solutions Framework (MSF).
  • Explain the use of Internet and intranet architectures for solution development.
  • List the available Microsoft application programming interfaces (APIs) and their purpose.
  • Design a user interface that complies with standards for Windows.

Section 1: Windows Operating Systems and Architecture
Windows Operating System Overview
Windows Architecture Overview

Section 2: Network Concepts
Networking Architectures
TCP/IP Protocol
Network Limitations
Developing Network Applications
Section 3: Building Solutions Using Microsoft BackOffice
Microsoft BackOffice
Microsoft Site Server
Section 4: Application Development
Development Platforms
Microsoft Windows Logo Compliance
Application Localization
Section 5: Component Solutions Architecture
COM Architecture
Implementing COM
Object Linking and Embedding
Section 6: Implementing Database Solutions
Database Systems
Client/Server Systems
Open Database Connectivity
Database Normalization
Database Replication
Section 7: Database Interfaces for Developers
Basic Interface Options
Data Access Methods
Choosing a Data Access Method
Section 8: ActiveX Technologies
ActiveX Architecture
ActiveX Controls
ActiveX Documents
ActiveX Code Components
Section 9: Implementing Client-Side Solutions
Introduction to Scripting
Client-Side Scripting
Implementing ActiveX Controls
Section 10: Implementing Server-Side Solutions
Introducing Server-Side Scripting
Authoring Active Server Pages
Reading an HTTP Request
Creating an HTTP Response
Saving User Information
Using ActiveX Server Components
ActiveX Design-Time Controls
Section 11: Other Programming Interfaces
Messaging API (MAPI)
Cryptography API
Telephony API
License Service API
Speech API
Section 12: User Interface Considerations
Windows User Interface Considerations

Standard Windows Controls and Dialogs
Windows Interaction Within an Application
Console and Windowing Applications
The Windows Help System

Section 13: Design Methodologies and Management
Development Design Methodologies and Management
Managing Source Code with Visual SourceSafe
Section 14: Test Questions Review

MCSD II - Part 2

Microsoft Certified Solution Developer Certification (MCSD II)
Microsoft SQL Server 6.5 Database Design and Implementation (Exam 70-027)
Syllabus (36 hrs teaching, 10 hrs test review)

1. Data Modeling
Introduction to Data Modeling Concepts
Implementing Entities and Attributes
Implementing Relationships
Normalizing Database Design

2. System Database and Tables
Define Physical Database Storage
System Databases
System Tables
Using System Stored Procedures
Server Configuration

3. Data Definition
Understanding Databases and Transaction Logs
Managing Databases
Understanding Data Types
Managing Data Types
Using Constraints

4. Retrieving Data
Writing SELECT Statements: An Overview
Choosing Columns
Formatting and Manipulating Data for Output
Using DISTINCT and ALL Keywords
Choosing Rows
Sorting Result Rows

5. Retieving Data (Advanced Topics)
Generating Summary Data
Using Joins
Using Subqueries

6. Modifying Data
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Importing and Exporting Data with BCP
Using the Transfer Tool in Enterprise Manager

7. Indexes
Introduction to Indexes
Characteristics of Indexes
Guidelines for Indexing
SQL Server’s Use of Indexes
Managing Indexes with Transact-SQL
Managing Indexes with Enterprise Manager

8. Using Views, Defaults, and Rules
Understanding Views
Understanding Rules and Defaults

9. Programmability
Control-of-Flow Statements
Implementing Cursors
The Benefits of Using Stored Procedures
The Capabilities of SQL Server and MAPI
Implementing String and Variable Extensions for the EXECUTE Statement
Managing User-Defined Error Messages

10. Triggers
Creating Triggers
Using the Inserted and Deleted Tables
Enforcing Referential Integrity
Nested Triggers
Enforcing Data Integrity

11. Replication
Applying Replication Appropriately
Applying the Appropriate Replication Model
Recognizing Server Roles
Tracing the Replication Process

12. Application Development and Open Datat Services (ODS)
Recognizing and Applying Open Architecture
Recognizing and Applying Open Database Connectivity
The Benefits of Integrating OLE Architecture with SQL Server
Recognizing How SQL Server Takes Advantage of the OLE Architecture

13. Certification Exam Overview