|
|
|||||||||
|
|
|||||||||
| Class Hours: 3.0 | Credit Hours: 4.0 | ||||||||
| Laboratory Hours: 3.0 | Date Revised: Spring 00 | ||||||||
| Catalog Course Description: | |||||||||
| A comprehensive introduction to the SQL/Oracle relational database system. Hands-on training will include set-up, installation, SQL*PLUS, database design and creation, data queries, view definition and use, operators and functions, use of Oracle tools, security, calculation, indexing, utilities, and data transport. | |||||||||
| Entry Level Standards: | |||||||||
| The student should be able to use a standard keyboard and maintain 10 words per minute error-free typing rate. The student must have math, writing, verbal and English language skills at the college entry level. | |||||||||
| Prerequisite: | |||||||||
| CST 1110 or department approval | |||||||||
| Textbook(s) and Other Reference Materials Basic to the Course: | |||||||||
| Textbook:
Oracle 8 the Complete Reference, by G. Koch, McGraw-Hill, 1997. Supplies: Three 3-1/4" HD floppy diskettes |
|||||||||
| I. Week/Unit/Topic Basis: | |||||||||
| Week | Topic | ||||||||
| 1 | Introduction, Relational and Object-oriented databases, Normalization | ||||||||
| 2 | Basic SQL, Sub-queries, Tables, Views | ||||||||
| 3-7 | Indexes, Datatypes, Objects, Constraints, Advanced sub-queries, Complex views | ||||||||
| 8 | SQLPLUS: Reports and Commands | ||||||||
| 9-11 | INSERT, UPDATE, views and methods | ||||||||
| 12-13 | LOBs, Procedure Builder, PL/SQL procedures and functions | ||||||||
| 14-15 | Development tools, Optimizer | ||||||||
| 16 | Final Exam | ||||||||
| II. Course Objectives*: | |||||||||
| A. | Develop a working understanding of the terminology associated with relational database processing. III, VII, VIII, IX | ||||||||
| B. | Become familiar with, have a working knowledge of, and demonstrate efficient use of: SQL, ORACLE and the SQL* product enhancement tools. IV, VI, V, VII, VIII, IX, XII | ||||||||
| C. | Develop a working relational database and develop restrictive access conditions appropriate for entering, modifying and producing output to an I/O device. III,IV,VI | ||||||||
| D. | Set-up, create file space and provide environmental conditions to provide a user with a working SQL relational database. III,IV | ||||||||
| E. | Become familiar with issues related to data access, security, file allocation and process control. III, VII, VIII, IX | ||||||||
| *Roman numerals after course objectives reference goals of the Business and Computer Technologies department. | |||||||||
| III. Instructional Processes*: | |||||||||
| Students will: | |||||||||
| 1. | Use professional tools to produce software components and documentation. Technological Literacy Outcome, Transitional Strategy, Personal Development Outcome | ||||||||
| 2. | Create database forms and reports based on client input. Communication Outcome, Problem Solving and Decision Making Outcome, Technological Literacy Outcome, Information Literacy Outcome, Active Learning Strategy | ||||||||
| 3. | Participate in a team using shared resources. Communication Outcome, Problem Solving and Decision Making Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 4. | Practice elements of the work ethic such as punctuality, professionalism, dependability, cooperation, and contribution. Personal Development Outcome | ||||||||
| 5. | Use professionally accepted methods and materials in their approach to completion of applications. Technological Literacy Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| *Strategies and outcomes listed after instructional processes reference Pellissippi State’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process. | |||||||||
| IV. Expectations for Student Performance*: | |||||||||
| Upon successful completion of this course, the student should be able to: | |||||||||
| 1. | Demonstrate proficient use of terminology associated with computers, software and database applications products. A,B,C,D,E | ||||||||
| 2. | Demonstrate an understanding of the use of hardware, firmware and systems terminology. A,B,C,D,E | ||||||||
| 3. | Demonstrate effective use of various manuals, documentation, tutorials, on-line directives and guides. A,B,C,D | ||||||||
| 4. | Demonstrate knowledge and use of major Oracle functions, commands and processes. A,B,C,D,E | ||||||||
| 5. | Demonstrate proficient use of the keyboard and mouse in accessing programs, data and/or files. A,B,C,D,E | ||||||||
| 6. | Demonstrate use of major SQL* tools commands and processes. B,D,E | ||||||||
| 7. | Demonstrate use of all major SQL programming commands and selections. B,D,E | ||||||||
| 8. | Demonstrate effective use of Oracle as a business tool. A,B,C,D,E | ||||||||
| *Letters after performance expectations reference the course objectives listed above. | |||||||||
| V. Evaluation: | |||||||||
| A. Testing Procedures: | |||||||||
| There will be three tests which count 200 points each, or 600 points total. Tests may consist of multiple choice, matching, fill-in-the-blank or short answer questions. There will be no make-up tests unless prior arrangements are made with the instructor. | |||||||||
| B. Laboratory Expectations: | |||||||||
| Lab attendance is required. Assignments will be given and must be completed and handed in at the expected date and time. Assignments turned in late may be reduced by a late penalty. No assignment will be accepted more than one week late unless approved in advance by the lab instructor. Lab assignments will count 400 points total. A term project may be included in the lab exercises. Students MUST earn at least 200 points in lab to pass this course. | |||||||||
| C. Field Work: | |||||||||
| None | |||||||||
| D. Other Evaluation Methods: | |||||||||
| None | |||||||||
| E. Grading Scale: | |||||||||
| Grades
will be assigned in accordance with the following scale:
900 -1000 pts. (w/min 200
in lab) A
|
|||||||||
| VI. Policies: | |||||||||
| Attendance Policy: | |||||||||
| Pellissippi State Technical Community College expects students to attend all scheduled instructional activities. As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course. | |||||||||