IS
489: Special Topics
(Database
Application Development using Oracle)
Objective:
This course as implemented in this semester is intended to provide students with an introduction in database programming and database development using Oracle DBMS.
Learning Outcomes:
After completing this course, the student is expected to be able to:
1. Write correct and meaningful SQL programming code.
2. Create database tables and populate them with values using SQL.
3. Write SQL code for searching and retrieving data.
4. Update tables by insertion, deletion, and change.
5. Write simple programming procedures using PL/SQL.
6. Create database forms and reports.
7. Develop integrated database applications.
8. Apply basic database administration functions.
Topics Covered:
1.
Review of Relational Database
Design
Client/Server Databases and the
Oracle 10g Relational Database (Chapter 1)
2.
Creating and Modifying
Database Tables (Chapter 2)
3.
Using SQL Queries to Insert,
Update, Delete, and View Data (Chapter 3)
4.
Introduction to PL/SQL (Chapter
4)
5.
Creating Database Forms
(Chapter 5)
6.
Creating Database Reports
(Chapter 7 )
7.
Creating an Integrated
Database Application (Chapter 8)
8.
Database Administration with
Oracle 10g (Chapter 11)
Assessment:
Major exam I 20%
Major Exam II 20%
Team Project & Participation 20%
Final 40%
Student grades out of 60%
(if you have any question, please come to the office before the final)
Textbook:
·
Joline
Morrison, Mike Morrison, and Rocky Conrad. Guide to Oracle 10g.
Cambridge, MA: Course Technology a
division of Thomson Learning, 2006
Supplementary Material
1.
AnExampleV3
2.
Queries Assignment
3.
Pine Valley Database
5.
Ch5
6.
CH7
7.
CH8 (Integrated Application)
Forms (Student_Logon and Faculty_Logon)
CH8 Text
Major2