| 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:
|
| Policies: | inls760_sp17_coursepolicies.pdf |
| 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 |