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_sp16_coursepolicies.pdf |
Lecture | Date | Topic(s) | Readings | Assigned | Due |
---|---|---|---|---|---|
1 | 14-Jan | Introduction, HTTP/HTML sample code |
Nixon 1, 2 Demystifying the Browser Learning HTTP |
||
2 | 21-Jan | Unix | Nixon 3, 4, 7 | ||
3 | 28-Jan | PHP Intro | Nixon 5, 6; WT 4 | P1 data.txt |
|
4 | 04-Feb | PHP and MySQL | Nixon 10 | ||
5 | 11-Feb | PHP and MySQL | Nixon 10 | P2 | P1 |
6 | 18-Feb | Security and User Input | Nixon 11 | ||
7 | 25-Feb | Session Control and User Authentication | Nixon 12 | ||
8 | 03-Mar | Database search | WT 18, 19 | P2 | |
9 | 10-Mar | MID-TERM EXAM | |||
10 | 17-Mar | SPRING BREAK | |||
11 | 24-Mar | Javascript and DOM | Nixon 13, 14, 15 | ||
12 | 31-Mar | Ajax JQuery lect10_ex.zip |
Nixon 17 | P3 | |
13 | 07-Apr | JQuery lect10_ex.zip |
JQuery tutorial | ||
14 | 14-Apr | HTML5 (html5rocks slides) JQuery |
|||
15 | 21-Apr | Model-View-Controler XML |
Landay slides North slides |
P3 | |
5-May | FINAL EXAM | May 5, 12noon |