INLS 760_001 – Web Databases
Spring 2017

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_sp17_coursepolicies.pdf

Schedule

The following schedule is subject to change:

Lecture Date Topic(s) Readings Assigned Due
1 12-Jan Introduction, HTTP/HTML Nixon 1, 2
Demystifying the Browser
Learning HTTP
   
2 19-Jan Unix
PHP Intro
Nixon 3, 4, 7    
3 26-Jan PHP Nixon 5, 6; WT 4 P1  
4 02-Feb PHP and MySQL Nixon 10    
5 09-Feb PHP and MySQL Nixon 10 P2 P1
6 16-Feb Security and User Input Nixon 11    
7 23-Feb Session Control and User Authentication Nixon 12   P2
8 02-Mar Javascript and DOM Nixon 13, 14, 15    
9 09-Mar MID-TERM EXAM      
10 16-Mar SPRING BREAK      
11 23-Mar Database search
Javascript and DOM
WT 18, 19
Nixon 13, 14, 15
   
12 30-Mar Ajax
JQuery
Nixon 17    
13 06-Apr JQuery JQuery tutorial    
14 13-Apr HTML5 (html5rocks slides)
JQuery
     
15 20-Apr Model-View-Controler
XML
Landay slides
North slides
   
16 27-Apr Review      
  8-May FINAL EXAM May 8, 12noon