Week |
Date |
Lectures |
1 |
August 30 |
Course Introduction
HTML Review
VBScript Overview |
2 |
September 6 |
Basic ASP Output |
3 |
September 13 |
Using Components with ASP (Browser Capabilities and
Filesystem Objects)
SQL Overview 1 (SELECT, WHERE, IN) |
4 |
September 20 |
Using Forms in ASP
SQL Overview 2 (SELECT and joins) |
5 |
September 27 |
Advanced ASP Forms
SQL Overview 3 (SELECT with GROUP BY) |
6 |
October 4 |
More ASP Components Lab 2
MIDTERM EXAM 1 |
7 |
October 11 |
SQL Overview 4 (INSERT/UPDATE/DELETE)
SQL Server Introduction |
8 |
October 18 |
ADO Introduction/Recordset Object
Firehose cursor
[build pages to display product records] |
9 |
October 25 |
ADO Paging
Commerce site architecture
[build product searching page] |
10 |
November 1 |
ADO Connection Object
Using ADO to Insert/Update/Delete
ADO Tips and Tricks (insert with identity, calling
stored procedures with parameters);
[build customer maintenance pages] |
11 |
November 8 |
Using cookies
MIDTERM EXAM 2
[build cookie-based security page] |
12 |
November 15 |
ASP Error Handling; ASP 3 new features
|
13 |
November 22 |
FileSystemObject -- [optional lecture] |
14 |
November 29 |
ADO Command Object, ASP Applications
|
15 |
December 6 |
Security Alternatives for ASP Programming (Basic, NTLM,
HTTPS, Certificates)
Best Practices Summary
|
Finals |
December 13 |
FINAL EXAM
5:15-7:15 p.m. |