I U P U I
CSCI N311 Advanced Database Programming, Oracle (3 Cr.)
Focus on the concepts and skills required for database programming and client server development. Concepts will apply to any modern distributed database management system. Emphasis on developing Oracle SQLPlus scripts, PL/SQL server side programming, and Oracle database architecture. Students with programming experience in ODBC compliant languages will be able to practice connecting such languages to an Oracle database. Lecture and laboratory.
The following Principles of Undergraduate Learning are reflected in CSCI N311:
Core Communication and Quantitative Skills
Integration and Application of Knowledge
Intellectual Depth, Breadth, and Adaptiveness
Understanding Society and Culture
Values and Ethics
Section 24735, Distributed Ed (DE)
Lecture instructor: Dale Roberts, Department of Computer and Information Science, IUPUI
Email: Student correspondence via Oncourse, otherwise firstname.lastname@example.org
(317) 431-4997 (cell) (recommended)
(317) 278-9045 (office)
(317) 274-9727 (CSCI office)
(317) 274-9742 (fax)
Office hours (appointment highly recommended):
TR 3:30P - 4:30P
Office location: SL-275
DE Help Session (attendance optional), M - 7:00P-8:45P, SL-247
Kevin. Oracle Database 10g The Complete Reference.
(ii) PowerPoint lecture slides are available via the web at http://www.cs.iupui.edu/~droberts/n311 .
(iii) Lectures in streaming media format are available via the web at http://www.cs.iupui.edu/~droberts/n311 .
(iv) Other links are also posted on the course web site http://www.cs.iupui.edu/~droberts/n311.
(v) The Loney textbook does not serve as an Oracle language reference. Google "Oracle Language Reference" to find internet references such as the http://tahiti.oracle.com.
N211 or equivalent. Prior procedural programming experienced is required. This requirement is typically met by CSCI 230 or N305 or a prior experience in a procedural programming language such as C, Visual Basic, Java, C++ or C#. Student must understand selection and repetition structures, boolean expressions and procedures and functions with input and output parameters.
Assignments and Grading Policy:
Projects: 40% (All projects are weighted by the number of points assigned)
Final Project: 20%. For DE sections, this is an individual project, or optionally a group of 2 or 3 members.
All Grades will be posted on IUPUI ONCOURSE.
Final Grade Scale:
This is a minimum grade guarantee. You are guaranteed that if you achieve these percentages, that the grade listed will be the lowest grade you receive. It is possible, based on the overall performance in the class, that you may receive a higher grade at the discretion of the instructor. Plus and minus grades may also be assigned at the discretion of the instructor.
TO PASS THE COURSE, IT IS NECESSARY TO OBTAIN A PASSING GRADE (>= 60% POINTS) IN TWO CATEGORIES: TESTS (COMBINED), PROJECTS AND FINAL PROJECT (COMBINED).
Assignments will have to be submitted via OnCourse by uploading to the provided Drop Boxes by 11:55 PM on its due date. Late assignments will not be accepted unless prior arrangements are made with the grader. All the assignments must work on Firebird (under Linux Operating System and Oracle installed there).
The course delivers lecture content through streaming media. Installing the free RealPlayer from http://www.real.com is required. You are encouraged to adapt your lecture experience to your learning style. If you need to lookup a topic from your textbook, just stop the lecture. If you didn't understand a topic, just backup and listen again. If you already know the subject, just fast forward. For OC sections, interactive questions and feedback occurs at the beginning of every lecture. For DE sections, interactive questions and feedback occurs either via email, Oncourse discussion forums, or the DE help session. Note that DE students are always invited the the OC lectures and labs as space permits.
Active Learning Modules
The OC sections of this course require participation in Active Learning Modules (ALMs). The ALMs may take the form of individual or group activities. Often ALMs require presentations, demonstrations, or other forms of public speaking. An encouraging atmosphere shall be maintained at all times.
For On-Campus sections the use of ALMs effectively require attendance in order to earn the Class Participation portion of your grade. Various forms of attendance may be taken to verify participation. Further, preliminary research shows that increased participation improves learning. For Distributed Education sections, warmup exercises are used to measure participation. Credit for completing a warmup is given if the student passes the warmup (100%). The warmups can be repeated as often as necessary before the due date to get a passing grade.
Students are encouraged to discuss the concepts and
principles amongst themselves. Such discussions help in understanding the
material and/or different aspects of the topics taught in the class.
Students may also assist in debugging each others code.
It is unethical to directly transfer any portion of
individual work products, either by printed or electronic means, between
students. Student cooperation should not result in identical or near identical
THE MATERIAL SUBMITTED FOR GRADING MUST BE YOUR OWN EFFORT. If this policy is violated then the following steps may be
taken: (1) rejection of submitted material with an opportunity for
resubmission for a reduced grade, (2) reduction of points by dividing by the
number of students involved in an incident, (3) assignment of a grade of ZERO
for all students involved in an incident, (4) assignment of a grade of F for the
course, and (5) initiation of official action against all students involved in
Internet use warning: The Computer Science department is particularly sensitive to dishonesty leveraging the internet. Presenting information obtained from the internet as your own is just as severe presenting information obtained from another student as your own. It is extremely important to cite works from the internet that are the basis for your own work. Your internet research should not result in work products that are in identical or near identical to the original. Posting any part of the course including homework, exams, or projects is forbidden. Submitting any part of the course to code-for-hire or other support web sites is forbidden. Accessing any online chat, user forum, IRC, or any other interactive discussions during online testing is prohibited.
Subscribe n311 mailing list to receive information:
We have set up a mailing list for this class. All students are required to subscribe to the list by sending an email to email@example.com with one line body: subscribe n311
Setup mail notification in OnCourse:
OnCourse mail is the primary mechanism for communicating among students in the class and with the instructor.
Everyone should check their OnCourse mail regularly. Setup a mail notification on the InTouch tab to notify your regular email account nightly of unread OnCourse mail.
Email communication with the instructor and graders shall be accepted only from OnCourse.
Questions, concerns, discussions and answers regarding the materials covered in this class should ONLY be discussed in OnCourse.
Project and Assignment submittals:
All projects and assignments are to be uploaded to an OnCourse Drop Box. In the new Oncourse, you are responsible for setting up the dropbox folders under your account.
Upload assignments to its OnCourse Drop Box by 11:55 PM on its due date.
Everyone should check their OnCourse mail regularly. Students are responsible for information posted there. If critical information is posted in Oncourse that you must read today, an announcement to check OnCourse will be sent to the mailing list.
Deadline extensions for assignments shall not be granted unless prior arrangements are made with the graders before the due day. Last minute extensions are typically not granted.
All files uploaded to be drop box
must include a comment header block that includes the project name and
student name. Also display the user name.
-- Name: Dale Roberts
-- Project 4
SET ECHO ON
SET SERVEROUTPUT ON
SELECT USER FROM DUAL;
Besides sql files, script outputs are also turned in with a txt extention. Make sure you use the SQLPLUS SPOOL COMMAND, not the spool windows dialog in SQLPLUSW. Do not turn in screen shots unless specifically told to do so.
First time to log on CS Linux system – firebird.cs.iupui.edu:
Firebird only accepts secured connections through SSH. You must install PuTTY before connecting to firebird and to transfer files. FTP does not work. PuTTY is available through IUWare.
Connecting to Oracle running on Firebird
Domain: cs10gorc.cs.iupui.edu (it may have a different name like service)
In classroom laptop use policy:
Since the introduction of the wireless LAN on the IUPUI campus, it has become common place for students to use laptops during the class. Use of a laptop in support of class activities, such as taking notes or viewing slides, is permitted. Disruptive activities are not permitted.
01/11/2009 07:33 PM
01/11/2009 07:33 PM