Oracle and SQL (CIS150/50)

Weekly Schedule

Essentially there are three ways for you to be able to work with Oracle:
1) Download the full version of Oracle and install it on your computer and work locally - that is what I have done
2) Work in the BCC labs with the BCC server installed Oracle
3) Access the BCC server installed Oracle from home using putty - there are instructions for that by Eric at my site.

Remember, all assignments including inclass assignments must be done by everyone - that includes online students and students who missed the class.. Play computer means to figure out the results yourself by evaluating the data rather than running the query.

Some students have encountered problems in putty because something has expired. If you encounter a problem, send me an email and I will ask IT to fix it.

Schedule by weekInformation to cover
  Note that the audio and Smartboard presentations for each class are posted within a couple of days.
Please check the weekly schedule multiple times a week, I sometimes add things during the course of the week. You need to pass in the code you write and the output that is produced unless you are told otherwise. Sometimes this involves showing data that was written to a file/table. Please keep copies of all work you submit until you receive your final grade at the end of the semester.
Comment on how I want the assignment: You should take the commands you do in SQL and the results and paste them into a word document. It should be similiar to the way I prepared the notes. You then send me the word document. I do not want you to show the screen itself - they are really hard to read!
Week #1
Week of January 22nd
I am available after 2 on Tuesday or Thursday at 1:45 if you have questions. Check my office K-112 or the classroom K-101 or the central K Buildign lab.
I recommend one of the text books in the syllabus, but a textbook is not required. There is enough material on the web and in my notes that I decided to make the book a recommendation. Please note that many students have found it useful to have a copy of the text. I do recommend that you get one of these books or another book dealing with Oracle SQL (we are using version 11g or 12c this semester) as a reference. We will not do chapter by chapter coverage, the text gives you additional information on topics and a reference if you have questions.
ional database information
LOGIN information:
You need to decide if you want to download Oracle, use the BCC labs or login from home using Putty.
Note that there is a reference to help you download and instal under Using Oracle: Installation and login.
Downloading Be very careful when you install, Oracle leaves a lot of footprints that makes reinstalling very difficult.
You should have received the login information you need for this course. If not, let me know.
PuTTY is available in the labs. Two sites that can be used to download PuTTY are:
PuTTY
PuTTY
Using Putty (copy and paste)
Basic steps to login to putty and get to Oracle:
1) Start putty and put in the hostname as cisweb.bristolcc.edu
2) At the login screen enter your username and your Linux password.
3) When you see that you are at cisweb, enter sqlplus12c.sh
4) You then connect to Oracle and need to enter your username and Oracle password
5) You should see the SQL prompt
Now you can create a table. Note that after you create tables, to see existing tables select table_name from user_tables.
Accompanying step-by-step notes
First we will focus on getting into Oracle and then these are the notes that we will start to cover this week:
Introduction to SQL in Oracle
Create a table in SQL
SQL Conditions
These are the accompanying presentations:
Presentations:
Introduction to SQL in Oracle
      Separate speaker notes for Introduction to SQL in Oracle
Create a table in SQL
      Separate speaker notes for Create a table in SQL
SQL Conditions
      Separate speaker notes for SQL Conditions
NOTES: Note: You can use the committ command to make sure your work gets saved.
Copy from SQLPlus so you can paste it onto the document you are submitting as your assignent
Assignments:
I strongly urge you to do the COMMIT; after the table is created.
Oracle assignment on introductory material (html)
Oracle assignment on introductory material (doc)
Comment on how I want the assignment: You should take the commands you do in SQL and the results and paste them into a word document. It should be similiar to the way I prepared the notes. You then send me the word document. I do not want you to show the screen itself or pictures of the screen - they are really hard to read!


Send e-mail to Mrs. Grocer:
Priscilla.Grocer@bristolcc.edu

Back to the Top
Return to home page