Discipline: Computer Information Systems Degree Credit  [ ]
Non Credit  [ ]
Nondegree Credit  [ ]
Comm Service  [ ]
 

Riverside Community College District
Integrated Course Outline of Record

Computer Information Systems 29A


COURSE DESCRIPTION
29A Introduction to Oracle Units: 3.00
 
Prerequisite(s): None.

Advisory: Working knowledge of the Structured Query Language (SQL).
This course provides an in-depth introduction to the fundamentals of Oracle. The course will present the following: developing a database schema; creating and maintaining tables; developing and using views and sequences; creating objects and collection types; maintaining integrity and enforcing security. A programming component will include the use of PL/SQL in understanding the PL/SQL syntax; create, and manipulating data; managing cursors; working with objects; programming collection types; creating triggers and building packages. The course includes a hands-on component in utilizing the SQL and PL/SQL languages. 54 hours lecture.
 
SHORT DESCRIPTION FOR CLASS SCHEDULE
This course provides both conceptual and hands-on experience in the fundamentals of the PL/SQL language and its use and application in the Oracle environment. Basic Relational DBMS concepts will be applied to the Oracle software.
 
ADVISORY ENTRY SKILLS
Before entering the course, students will be able to:
  1. Declaring SQL variables and constants

  2. Establishing SQL constructs to extract desired data from a database

  3. Defining stored procedures and functions within SQL
STUDENT LEARNING OUTCOMES
 Upon successful completion of the course, students should be able to:
Implement Oracle databases. Use Oracle object capabilities to create efficient, reusable code. Utilize SQL and PL/SQL to retrieve and manipulate data. Enforce data integrity and establish security. Write structured PL/SQL code with packages and triggers. Employ methods, VARRAYs, and nested tables. Develop PL/SQL programs to access Oracle databases. Manage data retrieval with explicit and implicit cursors. Create stored procedures. Design database applications.
 
COURSE CONTENT
  TOPICS
 
  1.  Introduction to Oracle Technology
    1.  Discussion of Relational DBMS
    2. Review of SQL fundamentals
    3. Review of SQL Plus fundamentals
  2. Designing the Database Schema in Oracle
    1. Logical data modeling
    2.  Physical database design
    3. Creating users and schemas
    4.  Working with the data dictionary
    5. Developing data types
    6. Using conversion functions
  3. Creating and Managing Tables
    1.  Defining and creating tables
    2. Altering and dropping tables
  4.  Views and Sequences
    1.  Using sequences to generate unique IDs
    2.  Building views to filter data
  5.  Creating Objects
    1.  Declaring Oracle object types
    2. Defining column objects
    3. Creating object tables
    4. Coding object methods
    5. Utilizing VARRAY’s, for array processing
    6. Setting up nested tables
  6.  PL/SQL Language
    1. Declaring variables and constants
    2. Establishing conditional, iterative, and sequential control
    3.  Error handling with predefined exceptions
    4.  Defining stored procedures and functions
  7. Managing Cursors
    1.  Controlling implicit and explicit cursors
    2. Passing parameters to cursors
    3. Utilizing FOR LOOP cursors
  8.  Programming with PL/SQL
    1.  Define statement and row triggers
    2. Control triggers with conditional predicates
    3.  Building column-level update triggers
  9.  Managing Integrity and Security.
    1. Establishing referential integrity
    2. Enforcing business rules
    3. Authenticating with passwords

Students are also assigned reading, writing and other outside assignments equivalent to two hours per one hour lecture.
 
METHODS OF INSTRUCTION
 Methods of instruction used to achieve student learning outcomes may include, but are not limited to:

• Lecture to develop database structures then how to use SQL to extract the data
• Discussion and group programming exercises to define and use SQL constructs
• Hands-on investigation of computer software packages such as Oracle database management system
• Classroom research projects to better define lecture points such as iterative SQL structures
• Distance Education: Online, Hybrid, and Web Enhanced
 
METHODS OF EVALUATION
 Students will be evaluated for progress in and/or mastery of learning outcomes by methods of evaluation which may include, but are not limited to:

• Oral reports/presentations/performance of programming exercises that demonstrate proficiency in SQL structures
• Written reports/presentations especially team programming reports
• Quizzes/examinations to capture the student progress and mastery of  SQL language constructs
• Computer programs to develop database systems with SQL data extraction routines
• Written assignments and research projects to hone mastery of  SQL
• Class and individual projects to assist the students in developing consistent and structured approaches to problem resolution.
• Laboratory projects/performance in a team environment to demonstrate a thorough understanding of SQL.
• 
• Final examination designed to assess students’ mastery of  SQL
ASSIGNMENTS

Required Reading Assignments


Required Writing Assignments


Other Outside-of-Class Assignments
 
COURSE MATERIALS
 All materials used in this course will be periodically reviewed to ensure that they are appropriate for college level instruction. Possible texts include:

  • Abby, Michael, Mike Corey and Ian Abramson. Oracle 9i: A Beginner’s Guide. Berkeley, CA: Osborne/McGraw-Hill, 2002.
06/07
540