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 #15 Week of May 5th |
Extra credit (2 problems): 1) You want to write a PL/SQL program that has a cursor that brings in all students with a CI major and a gpa of 3.2 or higher and numcredits > 45 a and who have submitted their intent to graduate form.. Then you want to process the records in the cursor to determine the level of honors. Lets say 3.2 to 3.49 is Cum Laude, Magna Cum Laude is 3.5 to 3.79 and Summa Cum Laude is 3.8 or higher. You want to update the table (gradstatus) with that information. Student (studentid, studentname, majorcode, optioncode, numcredits, formsub, GPA, gradstatus) and run the program and show files and output. 2) You want to write a PL/SQL program that uses two cursors. The first cursor should hold the records from the major table. The second cursor should hold the records from the student table. The program should process the students one majorcode at a time. It should count the number of students in the major, and the numcredits earned by students in that major. That information should be written to a separate table. Input tables: Student(studentid, studentname, majorcode, optioncode, numcredits, formsub, GPA, gradstatus) Output table: Statistics (majorcode, numstudents, numcredits) Run the program you wrote and show files and output. There is no final so homework, quizzes etc count 90% instead of 80%. If you want a final (in the syl) I can give you one but you need to contact me soon so we can talk about how it works. |
Week #14 Week of April 28th |
INFORMATION: Check back for extra credit assignments.ASSIGNMENTS TO DO: Continue working on last weeks assignments and check back.Note that the Status Sheet is required and I do not calculate your grade until I get it. It is your insurance policy and mine as well. If you say you passed something in and I don't have it, I will contact you to straighten it out. Homework is due on Monday, May 12th, but I will take a few things up until the last day of classes, Wednesday, May 14th. I would appreciate them coming in sooner so send them as you complete them.If you owe a lot, I absolutely need to get most of them in the next week and not a load at the end. I have been sick so I am a little behind - sorry! REQUIRED STATUS SHEET |
Week #13 Week of April 21st |
INFORMATION: Please continue to look at the information on cursors. This week we will also introduce exceptions and look at procedures,'functions, triggers etc.The logic of the check digit is in the video. If you would like me to do a Zoom to go over cursors or something else, just let me know and we can make it happen. There is information about tables and records under Notes and Handouts and under Presentations that you should look at. PL/SQL User Defined types - Record and Table PL/SQL User Defined Types - record and table Separate speaker notes for PL/SQL User Defined Types - record and table NOTES/EXAMPLES TO LOOK AT: Example we will look at:Introduction to exceptions type examples We will look at types and then move on to procedures and functions. Here are notes on functions, procedures. Introduction to procedures Introduction to functions Internal procedures More on internal procedures and functions Still more on procedures and functions Introduction to triggers More on triggers ACCOMPANYING POWERPOINT PRESENTATIONS Unfortunately not available still. Exceptions in PL/SQLSeparate speaker notes for Exceptions in PL/SQL Introduction to PL/SQL Procedures Separate speaker notes for Introduction to PL/SQL Procedures Introduction to PL/SQL Functions Separate speaker notes for Introduction to PL/SQL Functions More on Procedures - Internal Procedures Separate speaker notes for More on Procedures - Internal Procedures Introduction to Triggers Separate speaker notes for Introduction to Triggers More and Still More on Procedures and Functions Separate speaker notes for More and Still More on Procedures and Functions More on Triggers Separate speaker notes for More on Triggers TOPIC VIDEOS: ExceptionsIntroduction to Procedures Introduction to Functions More Procedures Internal Procedures & Functions More procedures and functions with cursor Introduction to Triggers More Triggers Check Digit SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Cursors and exceptions (11/12/19) Accompanying audioCursors and exceptions (11/12/19) See notes under Smartboard presentation Cursors and procedures (11/14/19) Accompanying audio Cursors and procedures (11/14/19) See notes under Smartboard presentation Cursors and functions (11/19/19) Accompanying audio Cursors and functions (11/19/19) See notes under Smartboard presentation Procedures, functions, triggers, check digit (11/26/19) Accompanying audio Procedures, functions, triggers, check digit (11/26/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Assignment on procedures, functions and triggers (you have two weeks to do this assignment so next week will be light)Notes on check digits You need to write the routine to calculate a check digit using Mod 11 and to validate a check digit using Mod 11. It can be done in two scripts or one. Check back |
Week #12 Week of April 14th |
INFORMATION: CATCH UP WEEK |
Week #11 Week of April 7th |
INFORMATION: CIS Alum Panel on Zoom at 12 noon on Thursday, April 10th. I will send the address to your Bristol email. Please try to come, it is highly recommended by many students who have attended.This is a part of CIS120, but everyone is invited and since it is about career paths, I think it is valuable.CIS Alum Panel April 10, 2025 - recording audio only I really hope you were able to spend some time on cursors last week and more this week. Let me know if you would like a help session. NOTES/EXAMPLES TO LOOK AT: Another set of cursor examplesSome more examples: payprog.sql payprog1.sql payprog2.sql data.txt Data layout for studentchk.sql studentchk.sql createdonor.sql Script to create donor donorcursor1.sql donorcursor2.sql donorcursor3.sql decodecursor1.sql ACCOMPANYING POWERPOINT PRESENTATIONS Unfortunately not available still. Covers: Another set of cursor exampesSeparate speaker notes for Another set of cursor examples TOPIC VIDEOS: Another set of cursor examples (prob 1)Another set of cursor examples (prob 2) Another set of cursor examples (prob 3) Another set of cursor examples (prob 4) Cursor examples involving payroll Cursor examples involving donor DB SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Still more cursors (11/5/19) Accompanying audioStill more cursors (11/5/19) See notes under Smartboard presentation Cursors and exceptions (11/12/19) Accompanying audio Cursors and exceptions (11/12/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Assignment: Use cursors to solve problems 1,2 and 4.First Problem:Write a PL/SQL program to accomplish the following: Using the sample emp database, give everyone in dept 10 a 5% raise, everyone in dept 20 a 7.5% raise, everyone in department dept 30 a 10% raise. Do this using a simple IF...ELSE and a loop. Second Problem:Modify the problem in #1 to meet the following criteria: IF dept is 10 and the salary is greater than 2000 give a 6% raise otherwise give a 7% raise. IF dept is 20 and the salary is greater than 2500 give a 5% raise otherwise give a 5.5% raise. IF dept is 30 and the salary is greater than 1000 give a 7% raise otherwise give a 6.5% raise. Third Problem: Set up an inventory table which should have an item number, and number on hand and a transaction table that has item number (should match an item number on the inventory table), an amount and a code with S for sales and P for purchases. There is one record per item number on the inventory table and on the transaction table there can be 1 or more transactions for an item number. Create scripts to create the tables and insert data into these tables. Fourth Problem: Using the tables you created in the third problem, process the transactions determine the impact on inventory. Display information that gives the original inventory and the inventory after the sales and purchases have been processed. You need to use cursors. Please check back as usual! |
Week #10 Week of March 31st |
INFORMATION: Remember that if you get something returned with errors that means you do not have a grade and you need to fix and resubmit.We are going to come back to Records and Table types hopefully because I think it will be better to lay the cursor foundation first. So we are going to look at Introduction to Cursors and Example 1 using cursors and its continuation. I suggest you look at the notes when I did this in class as well. Let me know if you want to go over something. If you are far behind, you need to make a decision about dropping the course or continuing. Wednesday, April 2 is the last day for you to withdraw with a W. If you do not withdraw and are not passing at the end of the semester I cannot withdraw you so I will have to give you an F unless there are extenuating circumstances that we have discussed and agreed upon. NOTES/EXAMPLES TO LOOK AT: Introduction to CursorsExample of cursor with while Example 1 using cursors Continuing example 1 using cursors ACCOMPANYING POWERPOINT PRESENTATIONS Currently not available - videos cover the material Covers: Cursors in PL/SQL, cursor example and continuation of first cursor exampleSeparate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example TOPIC VIDEOS: Introduction to CursorsExample 1 using Cursor but I did it with the wrong data The explanation is good though! Example 1 using Cursor with correct data Example with While cursor SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Data manipulation and intro cursors (10/29/19) Accompanying audioData manipulation and intro cursors (10/29/19) See notes under Smartboard presentation More cursors (10/31/19) Accompanying audio More cursors (10/31/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Work on understanding cursors.Use cursors to solve this problem: Note that my example of two cursors using the drive table and the donation table will be very helpful in doing this. Think of drive like dept. Problem #1: I want you to write a script that will handle the inven table and the department table. The script should accumulate the onhand for departments and write to a new table where you will store the dept, the department name and the total of the onhand. I would also like you to use the dbms lines to show the processing that happens. Everyone needs to turn in this script including the dbms output and a listing of what is on the new table. Do it doing the while structure In response to a question the inven table could have an inven number, a dept number (does not have to be a number) and an onhand amount. The dept table could have a dept number (match to dept on inven table) and a department name. You should assume there are multiple inven records per dept number and only one record per dept number on the department table. Problem #2: Re do using the loop structure. Check back as always! |
Week #9 Week of March 24th |
INFORMATION: Remember, I will set up a meeting some night or day to go over this if you want me to. Let me know some days and times that work.NOTES/EXAMPLES TO LOOK AT: More on PL/SQL IF statementsIntroduction to loops Data manipulation in PL/SQL - introduction ACCOMPANYING POWERPOINT PRESENTATIONS As noted before, these are not available - the videos are the replacement.More on PL/SQL IF statements Separate speaker notes for More on PL/SQL IF statements Introduction to loops Separate speaker notes for Introduction to loops Data manipulation in PL/SQL - introduction Separate speaker notes on Data manipulation in PL/SQL - introduction TOPIC VIDEOS: More on PL/SQL IFIntro to Loops Manipulating data Loops examples with Joe Fletcher SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Be sure to review the Intro PL/SQL - if and loop Smartboard and Audio under week #8.Data manipulation and intro cursors (10/29/19) Accompanying audio Data manipulation and intro cursors (10/29/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Oracle Loop AssignmentOracle PL/SQL Intro Quiz Check back! |
Vacation Week Week of March 17th |
Enjoy your vacation but not so much that you don't do a lot of catch up if you are behind. I will be around for questions most of the week although toward the end less so. |
Week #8 Week of March 10th |
INFORMATION: This week we will wrap up the introduction to SQL and move on to look at PL/SQL (Procedual Language/SQL).NOTES/EXAMPLES TO LOOK AT: More on viewsInformation on database objects Script for input data Introduction to PL/SQL Just very briefly to look at the structure we will return to this in a week or so. Introduction to IF statements ACCOMPANYING POWERPOINT PRESENTATIONS As noted before, these are not available - the videos are the replacement.More on views Separate speaker notes for More on views PL/SQL - Using IF statements Separate speaker notes for PL/SQL - Using IF statements TOPIC VIDEOS: More viewsSequence views etc Input Script Example Introduction to PL/SQL and IF statements SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Wrapup SQL (10/17/19) Accompanying audioWrapup SQL (10/17/19) See notes under Smartboard presentation Intro PL/SQL - if and loop (10/22/19) Accompanying audio Intro PL/SQL - if and loops (10/22/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Finish Basic SQLIF assignment In response to questions - think of nested as separate if statements with if and else where compound use AND OR Check back! |
Week #7 Week of March 3rd |
INFORMATION: As always, I am available for individual or group Zoom meetings - get in touch if you want one.Remember that if you get something returned with errors that means you do not have a grade and you need to fix and resubmit. This week we will focus on indexes, constraints and keys. As always, the most important thing are the Notes that essentially make the textbook for this class. You should also use the videos to try and explain. Sorry the powerpoints are still among the missing. NOTES/EXAMPLES TO LOOK AT: Indexes in Oracle - An introductionMore on Primary and Foreign keys Notes on key questions Also please look at the accompanying videos: ACCOMPANYING POWERPOINT PRESENTATIONS (Not available since last falls problems, trying to recover) Indexes in Oracle - An IntroductionSeparate speaker notes for Indexes in Oracle - An Introduction Primary and Foreign constraints with a relational database Separate speaker notes to accompany primary and foreign constraints with a relational database More on Primary and Foreign Keys also info from questions Separate speaker notes for More on Primary and Foreign Keys etc. TOPIC VIDEOS: Indexes and constraintsPrimary keys and foreign keys Key and index notes SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Review groups, relational, subqueries (10/8/19)Keys and constraints (10/10/19) Accompanying audio Keys and constraints (10/10/19) See notes under Smartboard ASSIGNMENTS TO DO: Oracle Key Example(this is a check off assignment) I want you to go through this example and do what I did so you follow and understand the concepts. Pass in your duplicate. Check back as always, I plan to put up another key assignment but I would really like you to do this one (key example) first.Key assignment Don't forget to put data in the table. |
Week #6 Week of February 24th |
INFORMATION: If you would like to set up a meeting to go over material, please let me know.We are going to look at views and reports done through the SQL prompt. NOTES/EXAMPLES TO LOOK AT: There was a question about equijoin and looking at my notes, I could have done better. Try these!Equijoin notes Nonequijoin notes Some subquery examples to look at to make sure you understand subqueries: A few more examples And still more examples Now we are going to move on to views and reports and more on scripts. Introduction to views Introduction to reports Also please look at the accompanying videos: ACCOMPANYING POWERPOINT PRESENTATIONS (Not available since last falls problems, trying to recover) Introduction to viewsSeparate speaker notes for Introduction to views Introduction to Reports Separate speaker notes for Introduction to reports Resource on reports Scripts: To create a script use edit and the name of the script (.sql is added) and to run use @ scriptname or a slash. createdonor.sql Script to create donor Insert data into maintain table Insert data into maintain table ver 2 TOPIC VIDEOS: Introduction to viewsIntroduction to reports SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Views and reports (10/3/19) Accompanying audioViews and reports (10/3/19) See notes under Smartboard presentation ASSIGNMENTS TO DO: Views and ReportsCheck back as always! |
Week #5 Week of February 17th |
INFORMATION: Let me know if you would like some Zoom time to go over things and what days and times work!We are going to continue with Oracle and subqueries and variables and into maintenance and reports. REVIEW EXAMPLES: This is an example that you might find helpful dealing with subqueries:Examples Solution A few more examples NOTES/EXAMPLES TO LOOK AT: We started looking at variables and got through Using Input Variables and some of more on variables.Using input variables More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Continuation of table maintenance revisited (again) ACCOMPANYING POWERPOINT PRESENTATIONS (Not available since last falls problems, trying to recover) Using Input VariablesSeparate speaker notes for Using Input Variables More on variables with Oracle's SQL*Plus Separate speaker notes for More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Separate speaker notes for Table maintenance revisted (again) Continuation of table maintenance revisited (again) Separate speaker notes for Continuation of table maintenance revisted (again) TOPIC VIDEOS: Introduction to variablesMore on variables Maintain again Maintain revisit again SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Variables and maintenance (10/1/19)See accompanying audioVariables and maintenance (10/1/19)See accompanying pdf ASSIGNMENTS TO DO: Coding assignment I want you to play computer (as opposed to running things) and tell what the results would be and why.Check back! |
Week #4 Week of February 10th |
INFORMATION: I am going to be away for a long weekend, still checking my email periodically, but I decided to load the week of early.We are still trying to line up a tutor. 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. The third assignment is to go and see Sabrina our tutor either with a question or just to say hi - ask her to send me am email that you were there. If her hours are absolutely impossible you can set up a Zoom meeting with me. Check back as always! |
Week #3 Week of February 3rd |
INFORMATION: Check with me if you have questions or encounter a problem. I am hear 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 (Not available since last falls problems, trying to recover) Normalization - information on third normal formSeparate speaker notes for normalization presentation Relational database information - information on 1 to 1, 1 to M, and M to M Separate speaker notes for relational database information Relational database notes and examples Goes with notes Introduction to multiple tables (relational) - joins - uses donor, donations and drive tables Separate speaker notes for relational database presentation TOPIC 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 assignmentSomehow for a short time week 2 was under week3 - it is fixed. Extend the deadline until the weekend if you need to. |
Week #2 Week of January 27th |
INFORMATION: 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 Several people are having trouble with the script so I am changing the due date. You have two weeks to do this! It is due the 13th of February. I will make up an instruction set. Check back! |
Week #1 Week of January 20th |
INFORMATION: Intro to Spring 2025 CIS150 courseIntro 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 OracleVideo 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: 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. |