Date | Section | Lecture | Topic | Due |
---|---|---|---|---|
Wed, Jan 15 | Ch. 1, 2 | 1 | Introduction to Databases | |
Fri, Jan 17 | Ch. 3 | 2 | Relational Databases | |
Mon, Jan 20 | Sec 4.1 | 3 | Creating a Database | |
Wed, Jan 22 | Sec 1.4.3 | 4 | Selections | |
Fri, Jan 24 | Sec 2.1 - 2.4 | 5 | Insertions, Deletions, and Updates | |
Mon, Jan 27 | Sec 4.3.2, 5.1.5 - 5.1.6 |
6 | Joins | Assgn 1 |
Wed, Jan 29 | Sec 5.1.7 - 5.1.8 | 7 | Aggregation | |
Fri, Jan 31 | 8 | Examples | Assgn 2 | |
Mon, Feb 3 | Sec 15.1 - 15.4 | 9 | Normal Forms | |
Wed, Feb 5 | Sec 15.5 | 10 | Boyce-Codd Normal Form | Assgn 3 |
Fri, Feb 7 | Sec 5.1.1 - 5.1.5 | 11 | Subqueries | |
Mon, Feb 10 | Sec 5.1.1 - 5.1.5 | 12 | More Subqueries | Assgn 4 |
Wed, Feb 12 | Sec 4.2 | 13 | Integrity Constraints | |
Fri, Feb 14 | Sec 26.1 | 14 | Triggers (Test 1) | Assgn 5 |
Mon, Feb 17 | Sec 5.3 | 15 | Views | |
Wed, Feb 19 | 16 | Basic HTML | ||
Fri, Feb 21 | 17 | Basic CSS | Assgn 6 | |
Mon, Feb 24 | 18 | CSS Classes | ||
Wed, Feb 26 | 19 | CSS Positioning | Assgn 7 | |
Fri, Feb 28 | 20 | Basic PHP | ||
Mon, Mar 3 | 21 | PHP Arrays | ||
Wed, Mar 5 | 22 | HTML Forms | Assgn 8 | |
Fri, Mar 7 | 23 | PHP Querying | ||
Mon, Mar 17 | 24 | Javascript | ||
Wed, Mar 19 | 25 | Form Validation | Assgn 9 | |
Fri, Mar 21 | 26 | AJAX | ||
Mon, Mar 24 | 27 | AJAX Examples | Assgn 10 | |
Wed, Mar 26 | 28 | Webpage Navigation | ||
Fri, Mar 28 | 29 | XML | Assgn 11 | |
Mon, Mar 31 | 30 | DTDs and XML Elements | ||
Wed, Apr 2 | 31 | |||
Fri, Apr 4 | 32 | XML Attributes | ||
Mon, Apr 7 | 33 | DTDs and XML Attributes | ||
Wed, Apr 9 | 34 | jQuery | ||
Fri, Apr 11 | 35 | jQuery | ||
Mon, Apr 14 | 36 | jQuery and AJAX | ||
Wed, Apr 16 | 37 | XPath | ||
Fri, Apr 18 | 38 | XPath Functions | ||
Mon, Apr 21 | 39 | XSLT | ||
Wed, Apr 23 | 40 | XSLT Exercises | ||
Fri, Apr 25 | 41 | TBA | ||
Mon, Apr 28 | 42 | TBA |