Oracle and SQL CIS150/50

Welcome to the Oracle and SQL, CIS150/50. This class will cover SQL, Oracle's SQL*Plus and PL/SQL which allows for actual programming within Oracle. We will also deal with the establishment of a relational database appropriate for particular business situations.

If you are taking this as a Web based course it is extremely important that you either own a computer or have daily access to a computer. For students taking the course over the Web, the computer is your only source for information and the way you will communicate with the instructor. If you do not have a computer available and you are not comfortable working on the Web, you should be taking this course using the classroom option (see below).

The Web site:

The Web site that you are currently visiting will contain all information for this course. It is a resource for students in the classroom and the method of delivery for students taking the course over the Web. The class notes, sample Oracle code, as well as PowerPoint presentations of the material are posted.
There is a week by week schedule that includes what you should accomplish during the week. If you follow this schedule, you will stay current. I usually update the site four or five times a week, so be sure to check it on a regular basis. Note: Assignments will not be handed out in class, they are available on the Web.

I have changed the site, so if you find something that does not connect, please let me know about the bad link so I can correct it. Hopefully everything will go smoothly, but perfection I do not expect!

 The way this course works:

Students taking this course have three options:

  1. They may choose to take it as a traditional classroom/lecture course and attend all or at least most classes
  2. They may take the class entirely over the Web meaning that they will get notes and sample code over the Web and they will communicate with me mainly through the board room for general interest questions and e-mail for specific questions.
  3. Students can blend the two approaches described above. If they have questions about the material, if they are confused about a specific topic, or if they just feel like attending class they are welcome to do so. If it is inconvenient to attend class or they feel that they understand the material and don't need the classroom activity, they can work through the Web site.
Unless you are organized and self disiplined, I strongly suggest that you use the in class option. Also, if you are fairly new to computing, the inclass option is recommended.


All students taking the course must have an e-mail address. As soon as you have an e-mail address send me an e-mail so I can put you into my system.

Students taking the course over the Web must communicate with me at least once a week via e-mail just to let me know they are still there!

For everyone in the class: If you miss more than two classes in a row, please send me an e-mail letting me know that you to still exist!

For in class students and Web students, assignments should be turned in the same or following week. Projects have a specified due date that should be met. I accept late papers with no individual penalty or point loss. The problem is that there is a lot of work and if you get behind you risk completing the course. In addition, 10% of your grade is based on participation, quality of work, getting things in on time etc., so chronic lateness will affect your grade.

Students should send me assignments via email. If there is a problem they should contact me. Students should pass in only one assignment per email. The assignment name should be on the subject line. If you have questions or need help, send a separate email with either the word question or help in the subject. I respond first to those emails and file the assignments to be corrected when I have accumulated a group. On most assignments, if you get a bad grade you can either resubmit or do a make-up. If I have heavily corrected the assignment and the answers are there, needless to say you cannot resubmit. Make-up assignments will be posted upon request, if appropriate. Quizzes may not be resubmitted.


If you need help, see me or email me and we will figure out the best response. Better to see as soon as you see signs of a problem! You can send me drafts of assignments with particular questions over e-mail and I will respond as soon as possible. With rare exception I check my Web site every day and on days when I am not at BCC, I usually check it multiple times (that means Wednesday and over the weekend). I am willing to set up review sessions or question and answer sessions for in class students, Web students or both.