UNC
School of Information and Library Science
INLS760 – Web Databases, Spring 2009
INLS 760

Main Page

Announcements

Calendar/Notes

Assignments

Links

Course Policies

Grades

Calendar / Notes
# Date Topic(s) Lecture Notes Readings* Assigned Due  
1 Jan 13 Introduction
Review HTTP, HTML, CGI
Unix and PHP
lect1
Unix
lect2
Read WS 1, 2, & 9.
Ref: WS 3-8, 14-19.
Read Demystifying the Browser
Read Learning HTTP
up to "Server Response Codes"
p0 - Programming
  p0-data.txt
 
2 Jan 20 Class canceled due to weather   Read 1, 2.
Skim 3 & 4.
Read 5.
p1 - HTML and CSS
  home.html
  contact.html
  browse.html
p0
3 Jan 27 MySQL refresher
PHP and MySQL
ex1
lect3
ex2
Skim 8.
Skim/read 9 & 10.
Read 11, 12, & 13.
p2 - Flat file databases
  records.txt
p1
4 Feb 3 PHP & User Input
Security, Ecommerce
lect4 Read 14 & 15 p3 - DL: Retrieve metadata from a DB
  smallrecords.txt
  bigrecords.txt
p2
5 Feb 10 Session control
User Authentication
lect5
ex2b
Read 16
Read 22
p4 - DL: Account types and logins
  p4bigrecords.txt
p3
6 Feb 17 In-class Mid-Term Exam
Lecture: More User Input and Authentication

lect5b
     
7 Feb 24 File upload
Time and dates
Secure transactions
lect6
ex4
Read 18
Skim 19 & 20
Read 17
p5 - DL: File upload p4
8 March 3 Database search lect7
ex5
  p6 - DL: Metadata and full-text search p5
  March 10 Spring Break        
9 March 17 ASP lect8
ex6
  p7 - ASP p6
10 March 24 Javascript and DOM lect9
ex7
Read WS 20, 21,
22, & 23
p8 - Javascript and DOM p7
11 March 31 Ruby on Rails (part 1) ex8     p8
12 April 7 Ajax lect11   p9 - Ajax  
13 April 14 Ruby on Rails (part 2)     p10 - Ruby on Rails p9
14 April 21 Ruby on Rails
Course Review
       
  April 28 NO CLASS - Schedule demo for project 10 before 5:00pm April 28       p10
  TBA Final Exam (optional)        
* All readings are in the PHP and MySQL book unless noted otherwise.
"WS" indicates a reading in the Web Standards book.
Read = read this material
Ref = reference material
Skim = skim this material