INLS 760_001 – Web Databases
Spring 2018

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

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

Policies: inls760_sp18_coursepolicies.pdf


The following schedule is subject to change:

Lecture Date Topic(s) Readings
1 16-Jan Introduction, HTTP/HTML Nixon 1, 2
Demystifying the Browser
Learning HTTP
2 23-Jan Unix
PHP Intro
Nixon 3, 4, 7
3 30-Jan PHP Nixon 5, 6; WT 4
4 06-Feb PHP and MySQL Nixon 10
6 20-Feb Security and User Input Nixon 11
7 27-Feb Session Control and User Authentication Nixon 12
8 06-Mar MID-TERM EXAM  
9 13-Mar Spring Break  
10 20-Mar Database search WT 18, 19
11 27-Mar Javascript and DOM Nixon 13, 14, 15
12 03-Apr HTML5/JQuery (html5rocks slides)
13 10-Apr JQuery JQuery tutorial
14 17-Apr JQuery JQuery tutorial
15 24-Apr Guest lecture: Dr. Miranda Capra – Accessibility
Landay slides
North slides
  4-May FINAL EXAM – Friday, May 4, 7:00-9:00pm