Announcements
- 12/04 - Final review sheet is posted
- 11/16 - Implementation homework 7 and 8 are posted
- 11/02 - Implementation homework 6 and problem set 5 are posted
- 10/23 - Midterm review sheet is posted
- 10/9 - Implementation Homework 4 and 5 and Problem Set 4 are posted
- 10/2 - SQL Demo with Aqua Data Studio by Hamid from the last semester is posted[Link]
- 10/2 - "How to set up your Aqua Data Studio" is posted
- 09/30 - Problem Set 3 is posted.
- 09/28 - Problem Set 2 is posted.
- 09/28 - Implementation Homework 2 is posted.
- 09/13 - An article about constraints is added in Supplementary Reading.
- 09/12 - Implementation Homework 1 is posted.
- 09/12 - Magic Draw Gotchas is posted.
- 09/12 - Please refer to this page to turn in your homework
- 09/09 - Lecture note 2 is posted. Lecture notes are not mostly posted here. You should attend the classes to get the lecture notes.
- 09/09 - An email about Homework is posted[Link]
- 09/01 - Tentative Schedule is posted.
Readings
Required ReadingsRecommended Readings
Supplementary Readings
- Oracle
- Oracle 10g Installation [Link]
- Oracle Concepts - Gathering Oracle CBO Statistics [Link]
- Oracle statistics? [Link]
- Aqua Data Studio
- How to set up your Aqua Data Studio(This is from the last year and ignore everything else except the last page) [Link]
- You may download packages of Aqua Data Studio from this
- You may find documentation for Aqua Data Studio from this
- You may view demonstration videos for Aqua Data Studio from this
- Constraints[Link]
- Magic Draw Gotchas[Link]
Homework
- Implementation Homework 7 and 8[Link]
- Implementation Homework 6 and Problem set 5[Link]
- Implementation Homework 4 and 5 and Problme set 4[Link]
- Problem Set 3 [Link] is due 10/7
- Problem Set 2 [Link] is due 9/30
- Implementation Homework 2 [Link] is due 10/23
- Implementation Homework 1 [Link] is due 9/16