I.

II.

Prerequisite:

See recommendation in Course (Catalog) Description

III.

Course (Catalog) Description:

Course provides theoretical and hands-on instruction on data server technology. Content includes relational databases concepts, SQL syntax, SQL commands to create and maintain database objects and to store, retrieve, display, query, and manipulate data, functions, blocks of application code that can be shared by multiple forms, reports, and data management applications; and commands to execute blocks of code. Recommended: CAB140 or comparable experience with a representative database software package and knowledge of a programming language

IV.

Learning Objectives:

Students who successfully complete this course will be "SQL and PL/SQL literate".  Students will be able to:

1. Describe relational database concepts.
2. Retrieve, insert, update, and delete data.
3. Create and maintain database objects.
4. Control transactions.
5. Use basic SQL*Plus commands.
6. Describe the features and syntax of PL/SQL.
7. Conditionally control code flow (loops, control structures, and explicit cursors).

V.

Academic Integrity:

Students and employees at Oakton Community College are required to demonstrate academic integrity and follow Oakton's Code of Academic Conduct. This code prohibits:

There are serious consequences to violations of the academic integrity policy. Oakton's policies and procedures provide students a fair hearing if a complaint is made against you. If you are found to have violated the policy, the minimum penalty is failure on the assignment and, a disciplinary record will be established and kept on file in the office of the Vice President for Student Affairs for a period of 3 years.

Details of the Code of Conduct can be found in the Student Handbook.

VI.

Outline of Topics:

1. Introduction to Relational Databases.  Creating Tables and Inserting Data.
2. Writing basic SQL Statements and Restricting and Sorting Data
3. Single-Row Functions. Displaying data from Multiple Tables
4. Aggregating Data Using Group Functions
5. Writing Subqueries.  Multiple-Column subqueries
6. Producing Reports with SQL*Plus
7. Manipulating Data, Maintaining Tables, Including Constraints
8. Creating Views and Other Database Objects
9. PL/SQL Basics, Declaring Variables, Writing Executable Statements
10. Writing Control structures
11. Working with Composite Datatypes
12. Writing Explicit Cursor, Advanced Cursor Concepts
13. Handling Exceptions

Note: Course outline is subject to change depends on class progress and needs.

VII.

Methods of Instruction:

1. Instruction and hands-on computer exercises in the laboratory
2. On your own, and as background information for each class, you will read the assigned sections or chapters from the text
3. Quizzes and exams
4. Classroom and laboratory assignments

VIII.

Course Practices Required:

1. Appropriate attendance.
2. Completion of assignments and tests.  All quizzes and exams will be done during class/lab.
3. Some material will be presented that is not covered in the book.

IX.

Instructional Materials:

TEXTBOOK: Oracle SQL By Example; Third Edition; Author: Rischert; Published by                        Prentice-Hall
                       Oracle PL/SQL By Example; third Edition; Author: Rosenzweig;                        Published by Prentice-Hall

X.

Methods of Evaluating Student Progress:

1. Minimum of two (2) quizzes (to be determined by instructor)
2. Mid-term exam (multiple choice, fill-in-the-blank, writing simple programs)
3. Final exam (multiple choice, fill-in-the-blank, writing simple programs)
4. Minimum of seven (7) homework assignments

XI.

Other Course Information:

If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations or services. To request accommodations or services, contact the ASSIST office in Instructional Support Services. All students are expected to fulfill essential course requirements. The College will not waive any essential skill or requirement of a course or degree program.