Course Materials
Updated by Demian Lessa on 01-31-2011.
Materials will posted and udpated here as they become available.
| Title | Resource | Date |
|---|---|---|
| Introductory Material | [lecture] [handout] | 01-21 |
| Relational Model | [lecture] [handout] | 01-26 |
| Relational Algebra | [lecture] [handout] | 01-30 |
| Classwork #1 | [handout] [solutions] | 01-31 |
| Homework #1: Relational Algebra | [handout] [solutions] | 01-31 |
| Classwork #2 | [handout] [solutions] | 02-04 |
| SQL | [lecture] [handout] | 02-11 |
| Recitation #1 | [recitation] | 02-11 |
| Classwork #3 | [handout] [solutions] | 02-13 |
| Homework #2: SQL | [handout] [solutions] | 02-14 |
| Classwork #4 | [handout] [solutions] | 02-16 |
| Project #1: Database Programming | [sources] [handout] [slides] | 02-24 |
| Homework #3: RA and SQL | [handout] [solutions] | 02-14 |
| Classwork #5 | [handout] | 03-20 |
| Classwork #6 | [handout] | 03-20 |
| Relational Design | [lecture] [handout] | 03-20 |
| ER Design | [lecture] [handout] | 03-27 |
| Classwork #7 | [handout] | 03-27 |
| Homework #4: Database Design | [handout] [solutions] | 03-28 |
| XML | [lecture] | 04-06 |
| XML Files | [bib.xml] [phd.xml] | 04-06 |
| Homework #5: XML | [handout] [solutions] | 04-22 |
| Indexing | [index-tests.sql] | 04-26 |
| Homework #6: Indexing | [handout] | 04-26 |
| Stored Procedures | [procs-tests.sql] | 04-28 |
| Homework #7: Stored Procedures | [handout] | 04-28 |
-- Demian Lessa
