Introduction I. WEEK 1. AT A GLANCE. Day 1. Understanding Windows DNA. Defining Windows DNA. Evolution in Application Design. Classic Monolithic.

Client/Server Model. Exploring a Classic Three-Tier Architecture. The Microsoft Commitment. Focusing on Solutions, Not Infrastructure. State Management. Encapsulation. Investigating the Windows DNA Building Blocks. Introduction to the Three-Tiered Windows DNA Model.

The Presentation Tier. The Business Tier. The Data Tier. Multitiered Design Principles. Exploring Components: The New Promise of Software Reusability. Understanding Object Speak. Microsofts Definition of Objects (COM). Windows DNA and the Team Environment.

Partitioning the Work. Development Environment. Source Control Using Source Safe. The Repository. Summary. Q&A. Workshop. Quiz.

Day 2. Building a Windows DNA Application. The Three Tiers Revisited. Presentation Tier. Navigation, Layout, and Scripting. Client-Side Presentation. HTML. Other Types of Markup.

Client-Side Scripting. Server-Side Scripting. Active Server Pages (ASPs). Business Logic Tier. Component Technology. Visual Basic. Server-Side Scriptlets. Data Tier.

Transactions. XML: Use It in All Tiers to Handle Data. Begin with Scalability in Mind. Scalability Is Expensive. Typical DNA Configurations. Development, Staging, and Production Servers. The Future of DNA. Windows 2000.

COM+. Application Center 2000. Summary. Q&A. Workshop. Quiz. Exercises. Day 3.

Architecting a Windows DNA Solution. Performing Analysis. Business Case. A Business Scenario. Analyzing the Problem. Defining Business Processes. Mapping the Solution to the DNA Architecture. Development Frameworks.

Using Microsoft Solution Framework to Generate Business Solutions. Extreme Programming. Summary. Q&A. Workshop. Quiz. Exercises. Day 4.

Exploring Database Fundamentals. The Basics of Database Architecture. Database Tables: The Backbone of Databases. Retrieving Database Information with Indexes. Assigning Data Types. Database Development Language (SQL). Managing Data Input. Exploring SQL Basics.

Creating Tables with Visual Studios Table Designer. SQL DML. Developing Table Relationships. Summary. Q&A. Workshop. Quiz. Exercises.

Day 5. Putting Business Logic in the Data Tier. Ensuring Data Integrity. Entity Integrity. Domain Integrity. Referential Integrity. Stored Procedures. CREATE PROCEDURE Statement.

Triggers. The Stored Procedure Wizard. Where Do You Implement Business Rules? Summary. Q&A. Workshop. Quiz. Exercises. Day 6.

ActiveX Data Objects (ADO). Creating a Data Source Name (DSN). Exploring DSN-Less Connections. Comparing OLE DB and ODBC. Exploring the ADO Object Model. Using the Recordset Object. Commonly Used Properties. Using the Connection Object.

Exploring the Command Object. Performing Inserts, Up20000831s, and Deletes. Calling Stored Procedures. Exploring Other Data Stores. Record and Stream Objects. Summary. Q&A. Workshop.

Quiz. Exercises. Day 7. Database Transactions and the Distributed Transaction Coordinator. Exploring Transactions. Applying Transaction Rules. Atomicity. Consistency.

Isolation. Durability. Working with Database Transactions. Starting a Transaction. Ending a Transaction. Applying Transactions to the SmallTownBank Application. Distributed Transactions. Starting a Distributed Transaction.

Ending a Distributed Transaction. Microsoft Distributed Transaction Coordinator. Managing Transactions with MS DTC. Increasing Transaction Performance. Microsoft Transaction Server. Summary. Q&A. Workshop.

Quiz. Exercises. Week 1. In Review. II. WEEK 2. AT A GLANCE. Day 8.

Introduction to COM and MTS. Component Object Model (COM). A Brief History of COM. COM Basics. Threading Models. Is COM Object Oriented? Microsoft Transaction Server (MTS). Resource Management with MTS. MTS Transaction Support.

Providing Security with MTS. Putting COM Components into an MTS Package. Using the Transaction Monitor. Using Role-Based Security. Declarative Security. Programmatic Security. Summary. Q&A.

Workshop. Quiz. Exercises. Day 9. Building COM Components in VB. Getting Started with COM. Starting a Visual Basic Project. Configuring Your Project.

Importing Your Visual Modeler Components. Using SourceSafe. Developing Your Project. Configuring Project Properties. Adding Public Methods and Properties of Your Class. Private Functionality. Utilizing the Class Builder Add-In. Reverse-Engineering Your Code Back into Visual Modeler.

Creating a Test Harness. Testing Your Components. Running the Test Form for the First Time. Storing Your Finished Code in Microsoft Repository. Summary. Q&A. Workshop. Quiz.

Exercises. Day 10. Adding Transactional Support. Adding Transactional Support to Your Components. Configuring Objects for Transactions. Completing and Aborting Transactions. Working with State and Components. Creating a Package and Installing Components into Transaction Server.

Adding the Components. Adding Transaction Support to the Components. Monitoring Your Components as They Transact. Raising Errors. Handling Updates. Removing and Updating. Considering Design. Summary.

Q&A. Workshop. Quiz. Exercise. Day 11. Interacting with the Database-ADO Revisited. Best Practices for Working with Data. Choosing the Correct Object: Commands Versus Recordsets.

Disconnected Recordsets. Batch Updates. Bringing Data into Your Data Tier Component. Data Interaction Methods. Stored Procedures Revisited. Data Shaping-Hierarchical Recordsets. Sending Data to Requesting Components. Returning a Disconnected Recordset.

Returning an XML String. Receiving Data Back from Another Component. Getting Information Back as a Disconnected Recordset. Getting Information Back as XML. Sending Data Back to the Data Store. Exploring Transactional Properties. Handling Errors. Summary.

Q&A. Workshop. Quiz. Exercises. Day 12. The Power of XML. Microsofts Push to Be a Leader in XML. Introducing Hierarchical Data Structures.

The XML Data Tree. Exploring XML Syntax. Exploring XML Elements. Element Attributes. XML Schemas and Namespaces. Data Type Declaration (DTD). XML Schema. Namespaces.

Using the XML Document Object Model. Client-Side XML. Server-Side XML. Working with XML. Constructing an XML Tree Using the DOM. Loading the XML from a File. Manually Constructing the XML Document. Using ADO to Create an XML File or Stream.

Using an Active Server Page to Create XML. Working with the XMLDOM. Simple API for XML (SAX). Summary. Q&A. Workshop. Quiz. Exercises.

Day 13. The Future: COM+. Activating Objects with Just-in-Time Activation. Activating Client-Side Objects Through JIT. Enabling JIT on Your Components. Reusing Objects via Resource Pooling. Monitoring Pool Usage with Component Services. Queued Components.

Enabling Queuing. Events. Registering a New Event Class. Using Automatic Transactions. Threading: Neutral Apartments. Constructor Strings. Retrieving the String with Visual Basic. Configuring COM+ Application.

Adding Components to Your Applications. Summary. Q&A. Workshop. Qu.