Lead Instructor:
Dr. Frank
Chao
Office:
PLM,
361D
Phone:
(919) 662-3398
Office Hours:Posted In Blackboard
Textbook(s):
Title: Oracle 9i: The Complete
Reference
Author: George Koch and Kevin
Loney
ISBN: 0072225211
Publisher:
Osborne/McGraw
Software used to complete
coursework: Oracle
9i Refer http://otn.oracle.com/software/content.html
Other required
equipment:
Credit Hours: Three (3) Semester
Hours
Pre-requisites: RED 099
Co-requisites: CIS115
Course
Description:
This course is designed to
develop programming proficiency in a selected DBMS. Emphasis is placed on
the Data Definition Language (DDL) and Data Manipulation Language (DML) of
the DBMS as well as on report generation. Upon completion, students should
be able to write programs which create, update, and produce reports
representative of industry requirements. The currently selected database
is Oracle.
Course Goals:
- Provide basic
knowledge of the Oracle database programming language to provide
students with an understanding of standard SQL, Oracle SQL*Plus, and to
help students prepare for the Oracle certification SQL (1Z0-007)
exam.
Course
Objectives:
Upon
successful completion, students will be able to demonstrate (through
completion of classwork and assignments):
- a basic understanding of Oracle database design issues.
- a basic understanding of standard SQL.
- a basic understanding of RDBMS creation, queries, updates
| The Core Values of Wake Technical
Community College |
| Respect |
Instructor and students will foster an
environment that is respectful of all. |
| Responsibility |
Instructor and students will foster an
environment that promotes taking responsibility for one's actions
and obligations. |
| Critical Thinking |
Instructor and students will strive to improve the critical
thinking skills of analysis, synthesis, and evaluation. |
| Communication |
Instructor and students will strive to ensure
that both written and oral communications are clearly
understood. |
| Collaboration |
Instructor and students will strive to develop
collaborative skills. |
| Gradin! g Is As
Follows: |
| Exams |
60 |
30% of each |
| Labs/Projects |
30 |
About 10 homework assignments |
| Attendance |
10 |
Attendance is required |
Classroom
Policies:
- Students are responsible for all of the information presented in the
Wake Technical Community College Student Handbook.
- Please note that computers are to be used at all times for official
course purposes. Use of computers for general web
surfing, email, chat rooms, etc. is not allowed. Violation of this rule
will result in a grade deduction and possible loss of computer
privileges.
- The college forbids t! he use of audible electronic equipment (cell
phones, pagers, etc.) during instructional time.
- If you miss a lecture or arrive late, you are responsible for the
material presented, handouts distributed, and any announcements made
that day. The instructor will not provide notes for missed classes.
Tentative
Schedule
Note: This schedule is
subject to some changes/modifications per Instructor -- This offered
as only a study guide. The pace of each class differs according to
the instructional needs of the students in the class. Always consult
with your instructor. Note** A Final Project may be assigned in leiu
of a Final Exam. |
| Unit |
Coursework |
Textbook/Assignments |
| 1 |
Introduction to Oracle |
|
| 2 |
Writing Basic SQL Statement |
|
| 3 |
Restricting and Sorting Data |
|
| 4 |
Single Row Functions |
|
| 5 |
Displaying Data from Multiple Tables |
|
| 6 |
Aggregating Data Using Group Functions |
|
| 7 |
Writing Subqueries |
|
| 8 |
Midterm |
|
| 9 |
Producing Readable Output with SQL*Plus |
|
| 10 |
Manipulating Data |
|
| 11 |
Creating and Managing Tables |
|
| 12 |
Including Constraints |
|
| 13 |
Creating Views & Other Database Objects |
|
| 14 |
Controlling User Access |
|
| 15 |
Oracle Data Dictionary |
|
| 16 |
Final |
|
Disability Support
Services is available for students who require academic
accommodations due to any physical, psychological, or learning
disability. To determine eligibility, contact the office at 108-S
Holding Hall or call
662-3405 (TDD 779-0668)
|
Copyright
2005/2006 Wake Technical Community College All Rights
Reserved |