INLS 760_001 – Web Databases
Spring 2014

Description: This course will introduce concepts and techniques for designing and implementing Web-enabled database systems. Topics include: web protocols, development in LAMP environments, security, user authentication, session management, search, client-side technology support (Javascript/DOM), and architectures to support Web database systems (MVC).
Room/Time: Manning 307: Wednesdays, 5:15pm - 8:15pm
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Wednesdays, 2:30-3:30pm, and by appointment
Prerequisites: INLS 572 or equivalent, INLS 523 and programming experience
Textbook: Required: Learning PHP, MySQL, JavaScript, & CSS, Second Edition. Nixon, R.
Recommended: PHP and MySQL Web Development, Fourth Edition. Welling, L. and Thomson, L.
Policies: inls760_sp2014_coursepolicies.pdf
Schedule: The following schedule is subject to change:

Lecture Date Topic(s) Readings Assigned Due
1 08-Jan Introduction, HTTP/HTML Nixon 1, 2
Demystifying the Browser
Learning HTTP
   
2 15-Jan PHP Intro
Unix
Nixon 3, 4, 7    
3 22-Jan PHP and MySQL Nixon 5, 6; WT 4 Ex1
P1
data.txt
Ex1
4 29-Jan PHP and MySQL Nixon 10    
5 05-Feb Security and User Input Nixon 11 Ex2 Ex2
P1
6 12-Feb SNOW DAY!!! Nixon 12    
7 19-Feb Session Control and User Authentication   P2
smallrecords.txt
bigrecords.txt
 
8 26-Feb MID-TERM EXAM      
9 05-Mar File upload & Secure Transactions
Database search
WT 18, 19    
10 12-Mar SPRING BREAK     P2
11 19-Mar Javascript and DOM Nixon 13, 14, 15 P3  
12 26-Mar HTML5 / Ajax Nixon 17    
13 02-Apr JQuery JQuery tutorial/docs P4
p4-ovrecords.txt
p4-keywordphrases.txt
P3
14 09-Apr XML      
15 16-Apr Model-View-Controler Landay slides
North slides
   
16 23-Apr Review     P4
  TBA FINAL EXAM Thursday, May 1, 7:00pm, Manning 307