Oracle Materials
CIS 211C Oracle - Special Topics in database

• iLearning Setup FAQ (2007)
• Database Design Outline
• Glossary of terms
• Visio tutorial page
• Oracle Application Express resource page
• Log in to iLearning site instructions
• Introduction to Application Express (APEX)
• All of the table in Application Express (APEX)   - Print these out when working on SQL assignments
• Provided database ERDs
  • DJ database
  • Oracle database
  • Global Fast Foods database
• Creating a Table handout
• Updating and Deleting Data
• Null General Functions
• Null Value Notes
• Key Functions in SQL
• SQL command quick reference guide
• Join Lecture Summary/Review Sheet   
  Below are new sheet as of 11/14/06
• Storing Dates
• Number Date Notes
• Character, Number, Dates notes
• Character Case  Notes
  Section 5 & 6
• Group By Rules
• Group Functions
• Subquery notes
  Section 7 & 8
• Timestamp example
• DML Default and Merge Notes
• DML Insert Notes
  Sections 9 & 10
• Constraints Notes
• Constraints Type Notes
• Naming Constraints

Application Builder
Chapter 14

• Introduction to Project
• Grading Rubric
• Part 1
• Part 2
• Part 3
• Part 4
• Part 5
• Amazon Book Store ERD

Chapter 15

• Part 6
• Part 7
• Part 8

Test Review Sheets

• Object Summary Table
• Exam #1 Review   (Answers)
• Exam #2 Review   (Answers)
• Final Exam Review Database Fundamentals Sections 16-18   (Answers)
• Final Exam Review Database Programming Sections 2-5    (Answers)
• Final Exam Review Database Programming Sections 6-9    (Answers)
• Final Exam Review Database Programming Sections 10-13    (Answers)

Student_oracle_resources.htm
last update:  11/04/2008