Wk |
Lecture (Tue)
 |
Lecture (Thur)
|
Laboratory
|
Reading
|
Wk 1
1/7 |
Introduction to the Course
Overview server-side technologies
Outside of Class Work:
[ IIS Setup ]
[ Dreamweaver MX Tutorials ]
Lecture 1: | video | |
Overview server-side
technologies
Lecture Notes:
[ ASP Errors ]
[ kewords pdf
| keywords html ]
Lecture 2: | vid hi lo | podcast | notes 6pp | 1pp |
|
Create Accounts
Lab
1 |
ASP pp. 2-3,
30-31,
36,
38-53 |
Wk 2
1/14 |
Overview of ASP
Server side includes
Handling forms
Lecture 3:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
Request and Response Objects
[Some Common Mistakes]
Lecture 4: | vid hi lo | podcast | |
Lab
2 |
ASP pp. 64-69,
96-107,
124-133,
142-143,
174-175,
137 Extra box |
Wk 3
1/21 |
Site Personalization
Session Object
Lecture 5:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
Introduction to Project 1
Scope
{Session, Application, Object}
Cookies {header,body}
Lecture 6:
| vid hi lo | podcast | notes 6pp | 1pp | |
Lab
3
Lab
4 |
ASP pp. 148-155,
122-123,
136-139
Add.
Reading1 |
Wk 4
1/28 |
Intro to Databases
SELECT Statement
Lecture Notes:
includes 12 example queries [ DB ]
Lecture 7:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
Intro to Database Theory
SELECT, Relational DB, Integrity Constraints, Aliasing
Lecture Notes:
[ SQL SELECT ]
Lecture 8:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
Lab
5
Lab
6
Project 1 |
Add.
Reading2
Add.
Reading3 |
Wk 5
2/4 |
SQL INSERT, UPDATE, DELETE
SQL Server & ASP
Objects, Methods, Functions
Connection Strings, DSN
Lecture Notes:
[ Conn to SQL Server in ASP ]
Other useful examples:
[ Conn to Access in ASP ]
[ Set up a DSN ]
Lecture 9:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
SQL INSERT, UPDATE, DELETE
MySQL & PHP
Data Modeling
Lecture Notes:
[ Conn to MySQL in PHP ]
Other useful examples:
[ Conn to MySQL in ASP ]
[ Conn to SQL SERVER in PHP ]
Lecture 10:
| vid hi lo | podcast | notes 6pp | 1pp | ex | |
Lab
6
Project 1
|
Your SQL reference: Relational
Databases, SELECT |
Wk 6
2/11 |
Encryption I: An Introduction
Debugging examples
Concatenation
Using Dreamweaver
Video: [ Lecture 11 ] |
Copyright, Patent, Trademark, Intellectual Property
Application Logic
{Variables, Control Structures, etc.}
Lecture Notes:
[ CopyPat ][ CopyPat 6pp ]
Lecture Notes:
[ Lecture 12 | Lecture 12 6pp ]
Video: [ Lecture 12 ] |
Lab
7
Project 1
[ lab 6 files ] |
ASP pp. 186-201,
SQL: INSERT, UPDATE, DELETE |
Wk 7
2/18 |
Table Creation -- SQL CREATE
Lecture 13:
| vid hi lo | podcast | notes 6pp | 1pp | |
Integration of server-side and client side scripting
Exam Review
Lecture 14:
| video | podcast | notes 6pp | 1pp | |
Project
1 Due Fri before 4PM [ info ]
|
TBA |
Wk 8
2/25 |
Table Creation -- SQL CREATE
Video: [ Lecture 15 ] |
Introduction to Project 2
Table Creation
Relationships
Server Variables
More Table Creation
Lecture 17:
| vid hi lo | podcast | notes 6pp | 1pp |
|
Lab 8
Project 2 |
ASP pp.
127 Extra box,
134-135,
277 |
Wk 9
3/3 |
TBD
|
Midterm Exam: In Class
|
Lab 9
Project 2 |
--- |
Wk 10
3/10 |
No Lecture -- Spring Break |
No Lecture -- Spring Break |
No Lab
Project 2
|
- - - |
Wk 11
3/17 |
Post Exam Review
Log files
More Database Theory
Lecture 18:
| vid hi lo | podcast | Paths | Constants | |
Scalability Issues, N-Tier design,
Web Farms
Lecture 19:
| vid hi lo | podcast | notes 6pp | 1pp | |
Lab 10
Project 2 |
ASP pp.
246-253,
146-147,
234-237
Add. Reading4 |
Wk 12
3/24 |
Overview of XML and XSL
Help on Project 2
Lecture 20 :
| vid hi lo | podcast | notes 6pp | 1pp | |
XSL Concepts
Lecture 22 :
| vid hi lo | podcast | notes 6pp | 1pp | |
Lab 11
Project 2 |
ASP XML:
Ch. 1, 2 |
Wk 13
3/31 |
XSL
How is XML like a database
Lecture 23 Notes:
[ pdf 6pp | pdf 1pp ]
Video: [ Lecture 23 ] |
Introduction to Project 3
XSL & ASP
Lecture 24 Notes:
[ pdf 6pp | pdf 1pp ]
[ imgExample.zip ] [ imgExample2.zip ]
[ Get Xray XML Editor ] |
Lab 12
Project 2 Due by 4PM Fri [info] |
ASP XML:
Ch. 1, 2, 6, 8
pp. 256, 203, 205 |
Wk 14
4/7 |
Really Simple Syndication (RSS)
XSL Variables & Parameters
More advanced XSL topics
Additional XML Examples
Lecture Notes:
[ RSS | RSS 6pp ]
[ pdf 6pp | pdf
1pp ] |
Parsing XML Data
Other XSL related topics
Additional XML Examples |
Lab 13
Project 3 |
ASP XML:
Ch. 6, 8, 5
RSS Article |
Wk 15
4/14
|
Asynchronous JavaScript and XML (Ajax)
Outside of Class Activity
Lecture Notes:
[ Ajax | Ajax
6pp ]
[ Examples ] |
Ajax
Project Questions
|
Lab 14
Lab 15
Instructor Eval
Project 3 |
|
Wk 16
4/21 |
Dead Week
Instructor Evaluations (10pts)
|
Course Wrap-up
Instructor Evaluations (10 pts)
Project 3, sotdev2
Review for Final Exam
[ Final Exam Study Guide ]
Lecture 28 Notes:
[ pdf 6pp | pdf
1pp ] |
Lab 16
Instructor
Eval
Project 3 Due Friday Before 3PM
[ info ] |
--- |
Wk 17
4/28 |
Final Exam
[ Exam Caveats ]
http://www.purdue.edu/Purdue/course_info/ |
|
|
|
