Website: www.pgrocer.net
Email: Priscilla.Grocer@bristolcc.edu.
The class is an online course this semester.
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 | Project | |
Week #15 | Wrapup |