INLS 760_001 – Web Databases
Spring 2015

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: Wednesdays, 5:15pm - 8:00pm
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Tuesdays, 2:00-3:00pm, and by appointment
Prerequisites: INLS 572 or equivalent, INLS 523 and programming experience
Textbook: 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_sp2015_coursepolicies.pdf
Schedule: The following schedule is subject to change:

Lecture Date Topic(s) Readings Assigned Due
1 07-Jan Introduction, HTTP/HTML
sample code
Nixon 1, 2
Demystifying the Browser
Learning HTTP
   
2 14-Jan Unix Nixon 3, 4, 7 P1
data.txt
 
3 21-Jan PHP Intro Nixon 5, 6; WT 4    
4 28-Jan PHP and MySQL Nixon 10    
5 04-Feb PHP and MySQL Nixon 10 P2 P1
6 11-Feb Security and User Input Nixon 11    
7 18-Feb Session Control and User Authentication Nixon 12    
8 25-Feb SNOW DAY     P2
9 04-Mar MID-TERM EXAM
lecture after exam: Database search

WT 18, 19
P3  
10 11-Mar SPRING BREAK      
11 18-Mar Javascript and DOM Nixon 13, 14, 15    
12 25-Mar HTML5 (html5rocks slides)
Ajax
Nixon 17   P3
13 01-Apr JQuery
lect10_ex.zip
JQuery tutorial P4  
14 08-Apr JQuery      
15 15-Apr Model-View-Controler
XML
Landay slides
North slides
   
16 22-Apr Looking Forward/Review     P4
  30-Apr FINAL EXAM April 30, 7:00pm