CS465 Oracle Development Environment
Fall 2009
Wichita State University
Department of Electrical Eng & Computer Science
Room 261,
Jabara Hall
Lecture: MW 5:35-6:50 pm
Instructor: John Matrow (pronounced
may-trow)
Office:
Room 011, Jabara Hall (south hallway)
Mail Box:
Room 233, Jabara Hall (UCATS Office)
Phone:
(316) 978-5306
Fax:
(316) 978-3894
E-mail:
john.matrow@wichita.edu
(preferred method of contact)
Web Site:
http://www.cs.wichita.edu/~matrow/cs465.htm
Office Hours: Monday - Friday TBD
Textbook: 1) Oracle11G: SQL by Joan Casteel. 2) Oracle10g 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: ORACLE 11G: SQL is an introduction to the fundamental SQL language used in all relational databases today. This textbook is not simply a study guide; it is written for those who have just a basic knowledge of databases and can be used in a course on this latest implementation of SQL from Oracle. Learning these concepts and techniques prepares students for the first exam in both the Oracle Database Administrator and Oracle Developer Certification Exam paths and offers a solid understanding of using Oracle 11g SQL effectively. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning.
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 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. |
|
|
Exam 1 will be given online at mid-term and Exam 2 will be given online by the scheduled final exam period. |
|
|
Programming assignments must be submitted using email and will be due as shown on Blackboard by classtime. Late assignments will be accepted but will be penalized 10% per calendar day. |
|
|
Exercises will be conducted on the Internet. The server is a EECS Department machine named tinman. |
|
|
You are expected to complete all assignments independently. Any incident of academic dishonestly will be reported to the EECS 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 EECS Department policies on make-up exams, incompletes, and withdrawals will apply. |
|
|
Telephone number for weather-related cancellation of classes: 978-6633 |
Course Objectives: