I. MAJOR PIECES

A.     .NET FRAMEWORK (requires windows 2000 or XP PRO)

1.      ASP.NET

2.      ADO.NET

3.      C#; VB.NET,etc.

B.     VISUAL STUDIO .NET (VS.NET) IDE (IntegratedDevelopmentEnvironment)

C.     WEB BROWSER: IIS

D.     DATABASE: SQL SERVER 2000; MS ACCESS

      II.          WEB APPLICATION OVERVIEW

A.           Client/Server Model

1.      3 tier

a)      browser (client/GUI) - front-end

b)     web server: business logic

c)      database server -back-end

2.      client side scripting

a)      jscript/javascript

b)     vbscript

3.      server-side scripting

a)      vb.net

b)     c#

c)      c++

d)     etc.

e)       

4.      flow of control

a)      Browser –to-web server

b)     Web server-to-browser

c)      Many clients-to-one web server/database server

Performance considerations

d)     Stateless

      III.         ASP.NET

A.     ASP.NET vs HTML

B.     Web Form

1.      Server Controls

a)      Asp controls

b)     Html controls

2.      integrated code

3.      separated code

codebehind

     IV.         ADO.NET

A.     Object set

1.      Connection object

2.      Command object

3.      DataReader object

4.      DataAdapter object

5.      DataSet object

a)      Tables

Rows

Columns

b)     Relations

c)      other

B.     Manipulating databases

1.      reading

2.      searching

3.      maintaining

a)      add

b)     delete

c)      modify

      V.          XML

     VI.         WEB SERVICES

    VII.        DATABASE WAREHOUSING

A.     OLAP (Online Analytical Processing)

SQL Server 2000 OLAP Services

B.     Data Mining

SQL Server 2000 Data Mining Services

    VIII.        NOTES

A.     Postback=page calling itself with control/runat=server/event (onclick,etc)