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