main | forum
March 14th, 2024    

CP207
Main
Overview
Forum

Notes
0001
0002
0003
0004
0005
0006
0007
0008
0009
0010
0011
0012
0013
0014
0015
0016

Tests/Quizes
quiz1
quiz2
quiz3
quiz4
quiz5
midterm
northwoods db
midterm ans
final

Katharine Gibbs School

CP207AN – Oracle Database Development
Course Outline

Course Length: 11 weeks/110 hours
Credits: 7
Course Description: This course teaches Oracle Database Development

Books: TBA

Prerequisites: CP101, CP102, CP202, CP206

Objective: To learn SQL, how to design databases, and write code to use databases; using Oracle.

Requirements: You will have several quizes, tests, homeworks, and projects.

Grading: (tentative) 40% final, 30% midterm, 15% homework, 15% quizes.

  • Week 1
    • Introduction
  • Week 2
    • Database Concepts
  • Week 3
    • Relational Databases
    • SQL
  • Week 4
    • Tables
      • Creating
      • Modifying
  • Week 5
    • Adding and retrieving data
  • Week 6
    • Intro to PL/SQL
  • Week 7
    • Connecting to DB
  • Week 8
    • Using Oracle from other applications
  • Week 9
    • Schema Generation
  • Week 10
    • Administration
      • General administration
      • Backups
      • Etc.
  • Week 11
    • Review
    • Final Exam




































© 2006, Particle