| 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 #4 Week of September 28th |
INFORMATION: Would you like a Zoom session to go over some of this?NOTES/EXAMPLES TO LOOK AT: Using joinJoin and where Subqueries More on subqueries ACCOMPANYING POWERPOINT PRESENTATIONS (Not available since last years problems, trying to recover) Zipped zersion of subqueries if you find a problem with version online.Subqueries Separate speaker notes for subqueries More on Subqueries Separate speaker notes for More on subqueries TOPIC VIDEOS: Using join to link tablesAccompany notes on Subqueries Explanation of subqueries described in previous notes on subqueries SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Subqueries (9/24/19) Accompanying audioMore Subqueries (9/26/19) Accompanying audio Subqueries (9/24/19) See notes under Smartboard presentation More Subqueries (9/26/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Subquery AssignmentSubquery quiz I do not want these run on a computer, I want you figuring out the logic and showing what you think the output should be. Check back as always! |
| Week #3 Week of September 21st |
INFORMATION: Check with me if you have questions or encounter a problem. I am here to help you succeed! Please take advantage of that. If you want to meet me in Zoom, we can set up a time if that works better and you think it would be helpfulTo repeat: If you need help with something, now would be the time to ask your questions! We are going to start looking at the design of a database and the theory of relational databases. Please read information about third normal form and relational databases. Please read the handout on definitions: Normalization definitions Normalization NOTES/EXAMPLES TO LOOK AT: Please read the two examples - the first two postings under notes.Introduction to multiple tables (relational) - joins Relational database examples Example of non-equijoin: nonequijoin example to accompany notes Also view the slide presentation on normalization information about relational databases: ACCOMPANYING POWERPOINT PRESENTATIONS Normalization - information on third normal formTOPIC VIDEOS: Third Normal FormIntroduction to multiple tables (relational) - joins (accompanying notes) Relational database examples (accompanying notes) SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Oracle quiz and relational databases (9/17/19) Accompanying audioOracle quiz and relational databases (9/17/19) See notes under Smartboard presentation Relational databases and intro subqueries (9/19/19) Accompanying audio Relational databases and intro subqueries (9/19/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Function assignment |
| Week #2 Week of September14th |
INFORMATION: There have been some layout of the screen changes but the only major change to using apporto is the login. Remember: You need to click on University Login.Apporto login using University Login Also another reminder that you cannot use Firefox or Safari. Last year their was a problem with Firefox that had no major impact on what we were doing, but this year you get frozen in FireFox. So be sure to use Chrome or Edge. Please do not change any of the passwords we have given you. I need to be able to get to your site as does the IT staff if there is a problem. NOTES/EXAMPLES TO LOOK AT: These are the notes that I will attempt to get through this week.More on maintaining an SQL table SQL functions More SQL functions Group SQL functions TOPIC VIDEOS: Maintain OracleCharacter Functions in Oracle Other kinds of Oracle Functions Decode Function in Oracle Finally when you have it uploaded onto cisweb, you need to figure out the address to give to others to see the file or files you upload. There is a very short video on that. See page in browser You can do other things as well because you now have access to the files you have set up through the virtual environment. SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Where, maintenace, functions in SQL (9/10/19) Check accompanying audioWhere, maintain, functions in SQL (9/10/19) See notes under Smartboard presentation Functions and groups (9/12/19) Check accompanying audio Functions and groups (9/12/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Please copy and paste onto a document rather than taking a picture. I am finding the black background a problem on some assignments.Second SQL assignment Script to create emp table (createemp.sql) You can enter edit createemp.sql or another name at the SQL prompt. It will go into the editor and ask if you want to create a new script. Enter yes and paste the script in and save it. If it does not ask you can just paste (different versions ask and don't ask). WriteOut and return to the prompt by using the exit and enter @ createemp.sql and it should run and create the table for you. Using putty, remember to have the script text in notepad and highlight it. When you go into the editor the right click will paste it or you can uses shift + ins to paste. You can then write and exit. Back at the SQL prompt is where you run it with the @. If you do a search for Oracle and the emp table/file you will also get a copy you can save to use. Query Quiz Script to create EMP Remember the homework is due on the Thursday of next week (this is week #2 so week #3). It is always due on Thursday of the following week. Check back! |
| Week #1 Week of September 7th |
INFORMATION: This class will deal with SQL and SQL embedded in scripts. SQL is a knowledge in high demand. The basics of SQL are the basics of SQL and have not really changed over time. My notes that I wrote used old dates but I really did not want to redo all the notes and all the database tables to accomodate the date options. I just want to put some information out on dates. . So please excuse the old dates.Please read one of the introductions to my website listed below: Intro to Fall 2025 CIS150 Intro to Spring 2025 CIS150 course 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. We will be using apporto to get into putty and the Oracle. Please be sure to read this article from the college and follow the directions. You will use bristolcc.apporto.com. The tutor for this course is Tom Dunn. I have asked him to set up time at 1:00PM on Thursday, September 10th and again at 7:00PM on Thursday, September 10th to go over using apporto and putty to get to Oracle. I hope one of those works for you. If not he is available from 5:00M to 8:00PM every Monday and Thursday for help. If none of those times work get back to me and we will try to set something up. This is totally optional but I think it will save time and effort. Using apporto and putty etc. 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) 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 and this does not go into using University Login (a change made to working with apporto).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 a while back. Trying to recover them. 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 OracleVideo 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 a previous Spring and a 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. If you use AI to help you figure something out, you need to let me know and explain what you did - your communication. Clearly you should not use AI to attempt the homework. Link to notes on DATE |