Oracle and SQL (CIS150/50)

Weekly Schedule

Please do not change your Linux or Oracle passwords.

Essentially there are two 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 takes a lot of room and leaves a lot of footprints.
2) Access the BCC server installed Oracle from home using putty - there are instructions for that by Eric at my site.

Assignments are individual projects. Play computer means to figure out the results yourself by evaluating the data rather than running the query. When you are asked to write code you should also show the results that the code generated unless specifically told not to.

If you get an assignment back without a grade you need to fix it and resubmit to get a grade.

The college wants you to use the Bristol email account when communicating with me.

Comment on how I want the assignment: You should take the commands you do in SQL and the results and paste them into a text or word document. It should be similiar to the way I prepared the notes. You then send me the text or word document. I do not want you to show the screen itself - they are really hard to read!

Remember HELP is available on Zoom - see HELP section below.

Schedule by week	Information to cover
	This semester, please use 2019/2020 audio and Smartboard as an extra resource since we do not meet in class. 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. Play computer means to figure out the results yourself by evaluating the data rather than running the query. 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 text or word document. It should be similiar to the way I prepared the notes. You then send me the text or word document. I do not want you to show the screen itself - they are really hard to read!
HELP schedule	I will set up some optional class Zoom meetings that you can attend, but I need to know some times and days that work for you. I am available by request/appointment (give me a few time day options) especially while we get other support in place. I have been meeting with a lot of students that request it, maybe something you should consider doing. You can email me with a couple of times you can meet and usually one of those will work. I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me. Downloading WinSCP on your PC by SI Joe Fletcher There is access to WiFi from your car under the solar canopies on the Fall River Campus.
Week #1 Week of January 19th	INFORMATION: Intro to Spring26 Intro to Fall 2025 CIS150 Intro to Spring 2025 CIS150 course Intro to Fall 2024 CIS150 course Intro to Fall 2023 courses Welcome to Oracle and SQL - Fall 2022 (youtube version) Zoom recording: Intro Zoom recording from 9/4/2024 I recommend one of the text books in the syllabus if you like having a textbook, 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. These books or another book dealing with Oracle SQL (we are using version 19c this semester) can be helpful as a reference. LOGIN INFORMATION: You can download Oracle, but that would not be my recommendation unless you are very experienced in complex downloads. Downloading - enterprise edition 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. Using Putty (copy and paste) Using putty in Apporto (Janelle) Stepping through SQL in putty in Apporto Basic steps to login to putty and get to Oracle: 1) Start putty and put in the hostname as cisweb.bristolcc.edu and the port as 220 2) At the login screen enter your username and your Linux password. 3) When you see that you are at cisweb, enter sqlplus19c.sh (some handouts have an older version, be sure to use sqlplus19c.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. NOTES/EXAMPLES TO LOOK AT: Notes from a prior version - currently we use sqlplus19c.sh and a port of 220. 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 Note that in many of the notes, the dates are quite old. SQL is SQL is SQL. Changes tend to be at the high end and not at the beginning. These notes were written after my first Oracle training, I have been back but have not seen the need to change the examples. When things are different, I will enter additional notes. The accompanying PowerPoint presentations got lost in the technical problems last year. They were a nice supplement but not necessary. I did the topic videos to take their place. TOPIC VIDEOS: Video to accompany Introduction to SQL in Oracle Video to accompany Introduction to SQL in Oracle (youtube version) Video to accompany Create a table in SQL Video to accompany Create a table in SQL (youtube version) Video of logging on using putty, establishing a table and testing it Video of logging on using putty, establishing a table and testing it (youtube version) Video to accompany SQL Conditions Video to accompany SQL Conditions (youtube version) SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: These are lectures from last Spring and the previous Fall that I recorded. The accompanying Smartboard presentations show what was on the Smartboard and the audio includes my explanation. Intro to Oracle (9/3/19) Smartboard notes with accompanying audio Intro to Oracle (9/3/19) See notes under Smartboard presentation to accompany this audio Putty and more SQL (9/5/19) Smartboard notes with accompanying audio Putty and more SQL (9/5/19) See notes under Smartboard presentation to accompany this audio ASSIGNMENTS TO DO: NOTES: Please copy and paste onto a document rather than taking a picture. I am finding the black background a problem on some assignments. Note: You should use the COMMIT command to make sure your work gets saved. Copy from SQLPlus (but I actually prefer copy and paste and not having the black background) All assignments must be turned in using the email addresses priscilla.grocer@bristolcc.edu. Your goal should be to get homework in on the Thursday after the week it was assigned. 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! So to repeat: For this semesters assignments, I need the code you write and the results unless there are other specifications in the assignment. Please send me an email explaining any computing background you have: courses you have taken, experience in programming or other areas of computing etc.

Schedule by week

Information to cover

This semester, please use 2019/2020 audio and Smartboard as an extra resource since we do not meet in class.
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.
Play computer means to figure out the results yourself by evaluating the data rather than running the query.
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 text or word document. It should be similiar to the way I prepared the notes. You then send me the text or word document. I do not want you to show the screen itself - they are really hard to read!

HELP schedule

I will set up some optional class Zoom meetings that you can attend, but I need to know some times and days that work for you.
I am available by request/appointment (give me a few time day options) especially while we get other support in place. I have been meeting with a lot of students that request it, maybe something you should consider doing. You can email me with a couple of times you can meet and usually one of those will work.
I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me.
Downloading WinSCP on your PC by SI Joe Fletcher
There is access to WiFi from your car under the solar canopies on the Fall River Campus.

Week #1
Week of January 19th

INFORMATION:

Intro to Spring26
Intro to Fall 2025 CIS150
Intro to Spring 2025 CIS150 course
Intro to Fall 2024 CIS150 course
Intro to Fall 2023 courses
Welcome to Oracle and SQL - Fall 2022 (youtube version)
Zoom recording:
Intro Zoom recording from 9/4/2024
I recommend one of the text books in the syllabus if you like having a textbook, 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. These books or another book dealing with Oracle SQL (we are using version 19c this semester) can be helpful as a reference.

LOGIN INFORMATION:

You can download Oracle, but that would not be my recommendation unless you are very experienced in complex downloads. Downloading - enterprise edition 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.
Using Putty (copy and paste)
Using putty in Apporto (Janelle)
Stepping through SQL in putty in Apporto
Basic steps to login to putty and get to Oracle:
1) Start putty and put in the hostname as cisweb.bristolcc.edu and the port as 220
2) At the login screen enter your username and your Linux password.
3) When you see that you are at cisweb, enter sqlplus19c.sh (some handouts have an older version, be sure to use sqlplus19c.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.

NOTES/EXAMPLES TO LOOK AT:

Notes from a prior version - currently we use sqlplus19c.sh and a port of 220.
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
Note that in many of the notes, the dates are quite old. SQL is SQL is SQL. Changes tend to be at the high end and not at the beginning. These notes were written after my first Oracle training, I have been back but have not seen the need to change the examples. When things are different, I will enter additional notes.
The accompanying PowerPoint presentations got lost in the technical problems last year. They were a nice supplement but not necessary. I did the topic videos to take their place.

TOPIC VIDEOS:

Video to accompany Introduction to SQL in Oracle
Video to accompany Introduction to SQL in Oracle (youtube version)
Video to accompany Create a table in SQL
Video to accompany Create a table in SQL (youtube version)
Video of logging on using putty, establishing a table and testing it
Video of logging on using putty, establishing a table and testing it (youtube version)
Video to accompany SQL Conditions
Video to accompany SQL Conditions (youtube version)

SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019:

These are lectures from last Spring and the previous Fall that I recorded. The accompanying Smartboard presentations show what was on the Smartboard and the audio includes my explanation.
Intro to Oracle (9/3/19) Smartboard notes with accompanying audio
Intro to Oracle (9/3/19) See notes under Smartboard presentation to accompany this audio
Putty and more SQL (9/5/19) Smartboard notes with accompanying audio
Putty and more SQL (9/5/19) See notes under Smartboard presentation to accompany this audio

ASSIGNMENTS TO DO:

NOTES: Please copy and paste onto a document rather than taking a picture. I am finding the black background a problem on some assignments.
Note: You should use the COMMIT command to make sure your work gets saved.
Copy from SQLPlus (but I actually prefer copy and paste and not having the black background)
All assignments must be turned in using the email addresses priscilla.grocer@bristolcc.edu.
Your goal should be to get homework in on the Thursday after the week it was assigned.
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!
So to repeat: For this semesters assignments, I need the code you write and the results unless there are other specifications in the assignment. Please send me an email explaining any computing background you have: courses you have taken, experience in programming or other areas of computing etc.