INLS 760_001 – Web Databases
Spring 2016

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 14: Thursdays, 2:00pm - 4:45pm
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Tuesdays, 2:00-3:00pm, and by appointment
Textbooks: Strongly recommended:
Learning PHP, MySQL, JavaScript, & CSS, Second Edition. Nixon, R.

Recommended:
PHP and MySQL Web Development, Fourth Edition. Welling, L. and Thomson, L.

Policies: inls760_sp16_coursepolicies.pdf

Schedule

The following schedule is subject to change:

Lecture Date Topic(s) Readings Assigned Due
1 14-Jan Introduction, HTTP/HTML
sample code
Nixon 1, 2
Demystifying the Browser
Learning HTTP
   
2 21-Jan Unix Nixon 3, 4, 7    
3 28-Jan PHP Intro Nixon 5, 6; WT 4 P1
data.txt
 
4 04-Feb PHP and MySQL Nixon 10    
5 11-Feb PHP and MySQL Nixon 10 P2 P1
6 18-Feb Security and User Input Nixon 11    
7 25-Feb Session Control and User Authentication Nixon 12    
8 03-Mar Database search WT 18, 19   P2
9 10-Mar MID-TERM EXAM      
10 17-Mar SPRING BREAK      
11 24-Mar Javascript and DOM Nixon 13, 14, 15    
12 31-Mar Ajax
JQuery
lect10_ex.zip
Nixon 17 P3  
13 07-Apr JQuery
lect10_ex.zip
JQuery tutorial    
14 14-Apr HTML5 (html5rocks slides)
JQuery
     
15 21-Apr Model-View-Controler
XML
Landay slides
North slides
  P3
  5-May FINAL EXAM May 5, 12noon