CS497F Fundamentals of the Oracle Development Environment
Spring 2001
Wichita State University
Department of Computer Science
Room 128, Jabara Hall
Lecture: MW 5:35 – 6:50 pm
Instructor: John Matrow (pronounced
may-trow)
Office:
Room 038, Jabara Hall (south hallway)
Mail Box:
Room 046, Jabara Hall (Physics Office)
Phone:
(316) 978-5306
Fax:
(316) 978-3350
E-mail:
john.matrow@wichita.edu
(preferred method of contact)
Web Site: http://www.cs.twsu.edu/~matrow/cs497f.htm
Office Hours: Monday - Friday 8:00 – 12:00, 1:00 - 5:00
Textbook: ORACLE8i: The
Complete Reference by George Kock & Kevin Loney, Oracle Press, ISBN 0-07-212364-8
Student Kits: Register at Oracle Academic Initiative
(WSU/Computer Science), login and click on "U.S. only - Order
Student Kits", click on "Take me to the OAI page on the Oracle Store" and
order
1) "OAI: Introduction to Oracle: SQL and PL/SQL (Part # A72591)"
for $75
2) "Develop PL/SQL Program Units (Part # A87110)" for
$75
The Student Kits include Student Guides, Notepad and Pens, Nametags, Misc Collateral,
Corresponding Documentation CDs.
Course Description: Oracle is the most widely used database in the world. It runs on almost all platforms, is highly tunable and extendible. This course will cover basic relational concepts, the SQL query language, PL/SQL, object creation, including indexes, tables, triggers, and stored procedures, Oracle Forms, SQL Loader in the transition of legacy systems and web-enabled applications. Students will work with several real-life projects.
Prerequisites: Any high level programming language (Pascal, C, C++)
with a grade of C or better
Grading Components:
Homework and Quizzes |
25% |
Programming Assignments |
25% |
Exam 1 |
25% |
Exam 2 |
25% |
Grading Scale:
90 - 100% |
A |
80 - 89% |
B |
70 - 79% |
C |
60 - 69% |
D |
59% and below |
F |
General Course Information:
 |
The course will be based on Oracle's "Introduction to Oracle: SQL and PL/SQL" and "Develop PL/SQL Program Units" classes. We will provide the material for the OCP (Oracle Certified Professional) Exam# 1Z0-001 and 1Z0-101. Most of the tracks use 1Z0-001. Look on pp. 11-12 of this Oracle Internet Application Developer Candidate Guide for details on Exam# 1Z0-001 and p.13 for details on Exam# 1Z0-101. |
|
The course will have documents and assignments on WSU's Blackboard system. Students should create one and only one account on Blackboard for all of the classes that use Blackboard. Look for Course ID: CS497F_04920 in the College of Liberal Arts & Sciences. |
|
Exam 1 will be given at mid-term and Exam 2 will be given during the last class period, Monday May 7, 2001. March 19-25 is Spring Break. |
|
Programming assignments must be submitted using email and will be due by 12:00 midnight on the assigned due date. Late assignments will be accepted but will be penalized 10% per calendar day. |
|
Exercises will be on a Computer Science Department machine named tinman. You need to run the TELNET program to access it or click here. The CS Dept. page has "Some tips for getting around in Unix, etc..". If you prefer vi to emacs as a text editor, then see my "Editing Text with VI" |
|
Assignments will be handed out at the end of the lecture period. |
|
Quizzes will be given at the start of the class period and cannot be made up. |
|
You are expected to complete all assignments independently. Any incident of academic dishonestly will be reported to the CS Department for disciplinary action and you will receive an "F" for the assignment. |
|
Make-up examinations are given only if you obtain permission directly from the instructor before the regularly-scheduled examination, and only if the make-up examination can be taken before the next scheduled class meeting. The exams are then arranged with the instructor. |
|
The CS Department policies on make-up exams, incompletes, and withdrawals will apply. |
|
The last day to drop this class with a "W" is March 30, 2001. |
|
Telephone number for weather-related cancellation of classes: 978-6633 |
|
Telephone number for obtaining grades at the end of the semester: 978-6500 |
Tentative Schedule:
|
Week 01: Introduction |
|
Week 02: Writing a Basic SQL Statement; Restricting and Sorting Data |
|
Week 03: Single Row Functions; Displaying Data from Multiple Tables |
|
Week 04: Aggregating Data using Group Functions;Writing Subqueries |
|
Week 05: Multi-Column Subqueries; Producing Readable Output with SQL*Plus |
|
Week 06: Manipulating Data; Creating and Managing Tables |
|
Week 07: Including Constraints; Creating Views |
|
Week 08: Other Database Objects; Mid-term exam |
|
Week 09: Controlling User Access; SQL Workshop |
|
Week 10: Declaring Variables; Writing Executable Statements |
|
Week 11: Interacting with the Oracle Server; Writing Control Structures |
|
Week 12: Working with Composite Datatypes; Writing Explicit Cursors |
|
Week 13: Advanced Explicit Cursor Concepts |
|
Week 14: Handling Exceptions |
|
Week 15: Exam |