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