| Date | Lecture | Topics | Assignments | ||
|---|---|---|---|---|---|
| Mon, Jan 15 | 1 | Introduction to Databases | |||
| Wed, Jan 17 | 2 | Relational Databases | Assgn 1 | ||
| Fri, Jan 19 | 3 | Creating a Database | |||
| Mon, Jan 22 | 4 | Selections | Assgn 2 | ||
| Wed, Jan 24 | 5 | Insertions, Deletions, Updates | |||
| Fri, Jan 26 | 6 | Joins | |||
| Mon, Jan 29 | 7 | Aggregation | |||
| Wed, Jan 31 | 8 | Examples | |||
| Fri, Feb 2 | 9 | Subqueries | |||
| Mon, Feb 5 | 10 | More Subqueries | |||
| Wed, Feb 7 | 11 | Practice | |||
| Fri, Feb 9 | 12 | Temporary Tables | |||
| Mon, Feb 12 | 13 | Practice | |||
| Wed, Feb 14 | 14 | Triggers | |||
| Fri, Feb 16 | 15 | Views | |||
| Mon, Feb 19 | 16 | Basic HTML | |||
| Wed, Feb 21 | 17 | Basic CSS | |||
| Fri, Feb 23 | 16 | CSS Classes | |||
| Mon, Feb 26 | 17 | Basic PHP | |||
| Wed, Feb 28 | 18 | PHP Arrays | |||
| Fri, Mar 2 | 19 | PHP Querying | |||
| Mon, Mar 5 | Spring Break | ||||
| Wed, Mar 7 | |||||
| Fri, Mar 9 | |||||
| Mon, Mar 12 | 20 | HTML Forms | |||
| Wed, Mar 14 | 21 | PHP Queries and HTML Forms | |||
| Fri, Mar 16 | 22 | ||||
| Mon, Mar 19 | 23 | ||||
| Wed, Mar 21 | 24 | Javascript | |||
| Fri, Mar 23 | 25 | Form Validation | |||
| Mon, Mar 26 | 26 | ||||
| Wed, Mar 28 | 27 | ||||
| Fri, Mar 30 | 28 | AJAX | |||
| Mon, Apr 2 | 29 | Webpage Navigation | |||
| Wed, Apr 4 | jQuery | ||||
| Fri, Apr 6 | 30 | ||||
| Mon, Apr 9 | 31 | jQuery and AJAX | |||
| Wed, Apr 11 | 32 | ||||
| Fri, Apr 13 | 33 | ||||
| Mon, Apr 16 | 34 | Normal Forms | |||
| Wed, Apr 18 | 35 | Boyce-Codd Normal Form | |||
| Fri, Apr 20 | 36 | ||||
| Mon, Apr 23 | 37 | XML | |||
| Wed, Apr 25 | 38 | XML Attributes | |||
| Fri, Apr 27 | 39 | ||||
| Thu, May 3 | Final Exam (6:00 pm - 9:00 pm) | ||||