CS465 Oracle Development Environment
Spring 2007
Wichita State University
Department of Computer Science
Room 128,
Jabara Hall
Lecture: MW 3:30-4:45 pm
Instructor: John Matrow (pronounced
may-trow)
Office:
Room 011, 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.wichita.edu/~matrow/cs465.htm
Office Hours: Monday - Friday 8:00 – 12:00, 1:00 - 5:00
Textbook: 1) Oracle10g SQL by Joan Casteel. 2) Oracle9i Developer: PL/SQL Programming by Casteel. Both cover material for several OCP exams. Supplementary information for the course is available from the publisher at http://www.course.com.
Book Descriptions: Oracte10g SQL prepares students for the first exam in both the Oracle Database Administrator (DBA) and Oracle Forms Developer certification tracks and offers them a solid understanding of Oracle10g and how to use it effectively. This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. PL/SQL Programming offers complete coverage of the subject of programming with PL/SQL, including an introduction to PL/SQL at the beginning up through coverage of advanced topics. Also helps to prepare students for the Oracle9i PL/SQL Programming certification exam.
Course Description: Oracle is a widely used database management system. Course covers basic relational database 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 real-life projects.
Prerequisites: CS 211 with a grade of C or better or department
consent. Consent will be granted for MIS 310.
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 the textbooks. We will provide the material for the OCP (Oracle Certified Professional) Exam# 1Z0-001 and 1Z0-147. 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 will have one and only one account on Blackboard for all of the classes that use Blackboard. Look for Course ID: CS-465-23375-200720 in the College of Liberal Arts & Sciences. The optional lab will be CS-465L-24352-200720. |
|
|
Exam 1 will be given online at mid-term and Exam 2 will be given online by the scheduled final exam period. Spring Break is March 19-25. |
|
|
Programming assignments must be submitted using email and will be due in one week by classtime. Late assignments will be accepted but will be penalized 10% per calendar day. |
|
|
Exercises will be conducted on a client-server basis. Oracle clients are available in 204 Jabara when the room in not in use. The server is a Computer Science Department machine named tinman. |
|
|
Oracle Personal Edition CD will be available for $2. You have to be a member of the Oracle Academic Initiative to be licensed for the software. |
|
|
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 April 2. |
|
|
Telephone number for weather-related cancellation of classes: 978-6633 |
Course Objectives:
|
|
Offers complete coverage of Oracle10g SQL and how to use this technology on the job |
|
|
Maps to the Oracles Certification Exam #IZ0-007, Introduction to Oracle10g: SQL, as well as Exam #lZ0-001, Introduction to Oracle: SQL and PL/SQL |
|
|
Uses hundreds of examples to help illustrate key concepts and techniques, and offers extensive end-of-chapter work that.provides valuable practice |
|
|
Offers full coverage of PL/SQL, from the basics for those new to the language, up through advanced topics, and is perfectly suited for a course on the subject |
|
|
Helps prepare individuals for the new Oracle Certification exam, Oracle9i: Program with PL/SQL (#1Z0-147) |
|
|
Offers hundreds of opportunities for valuable hands-on practice, including step-by-step tutorials as well as review questions, hands-on assignments, and case projects in every chapter |
|
|
Uses SQL*Plus as the tool of choice for hands-on tasks, and includes two debugging appendices dedicated to Procedure Builder and "TOAD" (Tool for Oracle Application Developers) |