| 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.
Recommended:
|
| Policies: | inls760_sp18_coursepolicies.pdf |
| 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 |
| 5 | 13-Feb | NO CLASS | NO CLASS |
| 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 Model-View-Controler XML |
Landay slides North slides |
| 4-May | FINAL EXAM – Friday, May 4, 7:00-9:00pm |