Topic-Level Outline
Days: 3
Prerequisites: Windows 95 Basic or Windows 98 Basic, HTML, SQL, Microsoft Visual Basic 6.0, and introductory knowledge of database management systems or equivalent experience
Unit 1: ASP Overview
Topic A:0 The Internet
A-1: Understanding the Internet scenario before ASP
A-2: Understanding the Internet scenario after ASP
Topic B:0 Scripting languages
B-1: Reviewing client-side scripts
B-2: Reviewing server-side scripts
Topic C:0 Working with Web applications
C-1: Understanding Web applications
C-2: Creating a PWS virtual directory
C-3: Creating a simple Web application
C-4: Testing a Web application
Unit 2: Using data
Topic A:0 Working with variables and constants
A-1: Understanding variables and constants
A-2: Using variables and constants in an application
Topic B:0 Working with Modules
B-1: Creating subroutines
B-2: Creating functions
Topic C:0 Working with classes
C-1: Creating a class
C-2: Using classes
Topic D:0 ASP’s object model
D-1: Understanding ASP’s object model
Unit 3: Arrays and collections
Topic A:0 Working with arrays and collections
A-1: Understanding arrays
A-2: Understanding collections
A-3: Reviewing a sample dictionary object
Unit 4: Control structures
Topic A:0 Selection control structures
A-1: Understanding the IFTHENELSE statement
A-2: Understanding the CASE statement
A-3: Reviewing server-side validation
Topic B:0 Repetition control structures
B-1: Understanding the FOR loop
B-2: Understanding the WHILE loop
Unit 5: The FileSystemObject object
Topic A:0 Working with the FileSystemObject object
A-1: Examining drives, folders, and files
A-2: Understanding the FileSystemObject
A-3: Displaying file and folder information
A-4: Opening new and existing files
Topic B:0 Working with the TextStream object
B-1: Reviewing the student contacts application
B-2: Reviewing the ClsForm.cls class for the student contacts application
B-3: Reviewing Form.asp
Topic C:0 Uploading files to the server
C-1: Using the SiteGalaxy Upload component
Unit 6: SQL and databases for data-driven applications
Topic A:0 Database overview
A-1: Understanding the concept of DBMS
A-2: Reviewing database concepts
Topic B:0 Designing database structure
B-1: Understanding the database structure
B-2: Creating a Web application to interact with the database
Topic C:0 Querying databases with SQL
C-1: Reviewing the SQL Select statement
C-2: Reviewing the aggregate functions in Select statement
C-3: Understanding the join condition
Topic D:0 Modifying data
D-1: Using the Insert statement in a Web application
D-2: Understanding the Update and Delete statements
Unit 7: Autogenerating SQL
Topic A:0 Comparing different database programming interfaces
A-1: Comparing different program interfaces
Topic B:0 Understanding ActiveX Data Objects
B-1: Reviewing ActiveX Data Objects
B-2: Changing the data source configuration of ADO connection strings to use OLE DB
B-3: Understanding data query data with ADO
B-4: Data entry using ADO
B-5: Understanding field or column referencing in ADO fields collection
B-6: Understanding how ASP handles run-time errors
Topic C:0 ODBC and OLE DB
C-1: Understanding ODBC and OLE DB
C-2: Reviewing a user-friendly programming interface
Unit 8: Moving your database from Access to SQL server
Topic A:0 Converting data from Access to SQL
A-1: Preparing the SQL shell
A-2: Restoring the database
Topic B:0 Stored procedures
B-1: Reviewing stored procedure
B-2: Creating a stored procedure in SQL server
B-3: Calling a stored procedure with the ADO command object
B-4: Observing the class scheduling application
Unit 9 : ASP and E-Commerce
Topic A:0 The Browser Capabilities Component
A-1: Understanding the Browser Capabilities Component
A-2: Using the Browser Capabilities Component
Topic B:0 Cookies
B-1: Reviewing the working of cookies
B-2: Incorporating cookies into applications
Unit 10: Managing ads and tables of contents of a Web site
Topic A:0 The Ad Rotator component
A-1: How an Ad Rotator component works
A-2: Creating an Ad Rotator component’s schedule file
A-3: Creating an Ad Rotator component’s redirection file
A-4: Viewing the Ad Rotator component in action
Topic B:0 The content linking component
B-1: Reviewing the content linking component
B-2: Creating the content linking list file
Topic C:0 Counters
C-1: Using the PageCounter object
C-2: Using the Counters object
C-3: Reviewing the course tracking information system start page
Unit 11: Creating user-defined components in Visual Basic 6.0
Topic A:0 Components in Web applications
A-1: Understanding the Components object model