Website: www.pgrocer.net
Office: K-112
Phone: 508-678-2811
ext 2403
Email: Priscilla.Grocer@bristolcc.edu Check with me about
other email address to use for homework.
Class meets at 9:30 on Tues and Thurs.
Course Description (from catalog):
This course is an introduction to the Oracle database. The student will learn to work with Oracle and the structured query language SQL as they design, manipulate and access the database. In addition, the concepts and design of relational databases will be analyzed and implemented.
Course Objectives:Week #1 | Introduction Oracle assignment | Week #2 | Second Oracle assignment, quiz | |
Week #3 | Oracle quiz, function assignment | Week #4 | Oracle quiz, multiple tables and subqueries | |
Week #5 | subquiz | Week #6 | Views and reports in Oracle | |
Week #7 | Oracle keys assignment | Week #8 | Oracle PL/SQL Intro quiz, PL/SQL decision assignment | |
Week #9 | Loop assignment, quiz | Week #10 | scripts and programs in PL/SQL | |
Week #11 | PL/SQL problems to write and execute | Week #12 | Procedure, function assignment | |
Week #13 | Trigger assignment | Week #14 | Wrapup | |
Week #15 | Prepare for final | Final | Final exam and status sheet required |