|Schedule by week||Information to cover|
|Note that the audio and Smartboard presentations for each class are posted within a couple of days. This
semester, please use 2019 audio and Smartboard 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 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 of January 25th
INFORMATION:Welcome to CIS150 Oracle and SQL For Fall 2020 A new one will be done for Spring 2021.
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 Be very careful when you install, Oracle leaves a lot of footprints that makes reinstalling very difficult.
The first approach to running Oracle will involve using putty to access Oracle.
You should have received the login information you need for this course. If not, let me know.
Two sites that can be used to download PuTTY are:
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 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
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: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
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.
ACCOMPANYING POWERPOINT PRESENTATIONSIntroduction 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
Separate speaker notes for SQL Conditions
TOPIC VIDEOS:Video to accompany Introduction to SQL in Oracle
Video to accompany Create a table in SQL
Video of logging on using putty, establishing a table and testing it
Video to accompany SQL Conditions
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: Note: You can use the commit 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
All assignments must be turned in using the email addresses email@example.com with a cc to the email address I will send you. I like to have backup.
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!
To repeat: For this semesters assignments, I need the code you write and the results unless there are other specifications in the assignment.