ASP/IIS/SQL/MTS Case Studies

Day

Book

Chapter

Topic

start page

1

2

daurril prospectus

2

22

3382

Chapter 15:

Writing an Application

633

3

3382

Chapter 17:

Introducing Transactions and COM+ (p808)

769

4

3382

Chaps 12-14

Data Store / Recordsets / Advanced Data Handling

474

5

1266

Chapter 20:

A Case Study in Compatibility

709

6

19

1266

Chapter 15:

An Electronic Commerce Case Study

523

3986

7

20

1266

Chapter 16:

Creating Components in the Electronic Commerce Case Studydy

565

8

21

1266

Chapter 17:

Message Queuing in the Electronic Commerce Case Study

601

9

12

107

Chapter 10:

Data-Centric business Objects

437

10

13

107

Chapter 5:

Implementing bObjects using Visual Basic 6.0

183

11

14

107

Chapter 6:

Implementing bObjects Part 2-Parent and Child Objects

235

12

15

107

Chapter 7:

Visual Basic Forms as a User Interface

303

13

16

107

Chapter 8:

Implementing Single-Tier or Two-Tier Data Access

361

14

17

107

Chapter 9:

Microsoft Office as an Interface

415

15

18

107

Chapter 13:

An Active Server Pages Interface

567

16

3

3986

Chapter 2:  

Starting Our Site

21

17

4

3986

Chapter 3:  

Building the Object Model

41

1266

18

5

3986

Chapter 4:  

Presenting Our Online Store

87

19

6

3986

Chapter 5:  

Structuring the Online Store

121

20

7

3986

Chapter 6:  

Building the Product Catalog

153

21

8

3986

Chapter 7:  

The Shopping Basket

205

22

9

3986

Chapter 8:  

The Checkout

233

23

3986

Chapter 16:

Up-sell, Cross Sell, and Recommendations

545

24

10

3986

Chapter 9:  

Order Processing

321

course description:

107

This course will analyze the design and construction of several websites capable of implementation with the advertised properties on home equipment.   Four text are indicated, the particular contribution of each to this course elucidated in the following table.  (1266 and 3382 were introduced to Guild students in MS102.)  Only the first need actually be purchased now,  Students are reminded that all Wrox source materials are freely downloadable.  So even if you might not instantly purchase all of them, you may by successfully installing them want to see why they ran: 

z 3986 chapters 2-8, Jo's Coffee order entry side (populated from Gevalia.com);

z 107x chapter 10, 5-9, 13, Tape Rental model: operation from VB, Excel, and ASP;

3382

abcdefghijklmnopqrstuvwxyz

z 1266 chapters 15-17, the Book Store ;

z 3382 chapter 15, the Wrox Classifieds application;

The course itself does not teach programming, but is intended to prompt constructive dialogue among those who do ("programmer to programmer"). Like Scripture (and why not) the implementations arose at different times and places: yet we know these working out of only one conceptual model, and need to consider in analysis how they are similar and why they are different.  Among our two primary texts (3986 and 107x), the first  represents the model richest in scripting integration and real-time features  Yet in each case a "bedrock" VB DLL  provides the objects from which scripting spins its windows.  At the end of the course they will be able to:

z Install and operate all the case studies, with suggestions as to their functional recombination;

z Comfortably handle routine project reconstructions at the DLL-level;

z Understand and manage MTS packages;

z Students should understand any SQL process incidental to forming the required recordsets.

Vertical Subject Analysis?

In this instructors experience, elementary course content is presented linearly according to a single textbook, and progress is indicated by having done everything by the end  That approach is effectively inverted in master's courses, where a single topic may be explored according to its presentation in several different works.  Where this presentation includes matters of implementation, our principal accomplishment may occur at the beginning, not the end of the course. Once we understand what the first application installation is about, others using the same methods become rather simple.

Your instructor is pleased that you may chose to include yourself in a work in progress. 

Prerequisites:

Completion of Active Server Pages for Non-Programmers, or Introduction to Programming Basics, or programming experience in Java, JavaScript, Visual Basic or VBscript.

While lesser configurations (PWS or Access) may have at first been indicated, in order to guarantee their operation these projects are assembled here to run on Windows 2000 Professional, SQL 7.0, and Enterprise Visual Studio 6.0: which anyone close enough to a purchased MSDL is presumed to possess.  At the same time, both time and budget constraints preclude the elaboration of topics specific to non-MS software.