| Schedule by week | Information to cover |
|---|---|
|
PowerPoint Presentations:
Free PowerPoint viewer for 97,2000,2002 users Note that the speaker notes are provided on a separate Word document for many of the presentations if you are having trouble accessing them! Please check the weekly schedule multiple times a week, I sometimes add things during the course of the week. Please keep copies of all work you submit until you receive your final grade at the end of the semester. | |
| Week #15 Assignments Week of December 8th |
This Tuesday (the last week of classes), I am
going to hold an open lab in K101 from 9 to 3:30. This is a catch up day, so if you are behind try
very hard to come for as many hours as you can. The only topic we have left is triggers, we will cover that this week. I was out sick on Thursday, I have put up Smartboard notes on what I would have covered in class and I will go over the trigger information again on Friday. Final Exam Required Status Sheet |
| Week #14 Assignments Week of December 1st |
I am available in K101 on Tues at 11 and from 2:00-2:30, Thurs at 11 and
at 3. Thursday I am also available around 5:30 in K102. Friday I am
avalable in my office at 11. Next Tuesday, we will have another all day help lab in K101. Please read the notes and look at the PowerPoint presentations. We will spend the next couple of weeks on these topics. Internal procedures More on internal procedures and functions Still more on procedures and functions Introduction to triggers More on triggers 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 A site to check out: Tutorials Assignments: Procedure, function, trigger assignment |
| Week #13 Assignments Week of November 24th |
This Tuesday, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. |
| Week #12 Assignments Week of November 17th |
This is advisement week, so during the times I say I am available for help
I may have someone signed up for advisement. Sorry, but I do not know what slots are
taken. I am available for help/advisement at 11 and 2 on Tuesday in K101,
11 and 3 on Thursday in K101 and 6 on Thursday in K102. I am also available Friday at
11 and 1 in my office. Next week, the Tuesday of Thanksgiving week - I am
going to hold an open lab in K101 from 9 to 4 with some time away at 2 for
a meeting. This is a catch up day, so if you are behind try very hard to come for
as many hours as you can. We will look at record and table types and some more at cursors - we hopefully will make it to exceptions as well. That will only leave procedures, functions and triggers for after Thanksgiving. Please check back! Be sure to look at the handouts on cursors. Please note that there are Smartboard explanations on cursor examples and PowerPoint presentations. Please read the following notes and watch the slide presentation. Example 1 using cursors Continuing example 1 using cursors Another set of cursor examples Covers: Cursors in PL/SQL, cursor example and continuation of first cursor example Separate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example Covers: Another set of cursor exampes Separate speaker notes for Another set of cursor examples I would also like you to look at the information on exceptions: Introduction to exceptions Exceptions in PL/SQL Separate speaker notes for Exceptions in PL/SQL Assignments: Multiple cursor assignment |
| Week #11 Assignments Week of November 10th |
Advisement starts this week. You can do online advisement with me using
the usual email address or you can sign up for advisement with me (K112)
or Sil Ferreira (K216) or Igor Kholodov (K211) or Janelle Arruda (networking) or
Raymond Steele (game). Even though you may have me listed as your advisor, you can
go to another member of the CIS Department for advisement. All of the CIS advisors have the transcripts and the information
to help you choose your Spring courses - please plan to see one of us. If you are in game, contact Raymond directly. Advisement check lists - please note these are not official (we have not caught any errors, but for official/confirmed information you should always check the catalog. I will not be in on Wednesday (Tuesday classes), I suggest a working session during the class to help get caught up. On Thursday and Friday I will be combining advisement and help. At 11 on Thursday I will be in K101 and at 6:00 I will be in K102. Depending on who signs up for advisement I will probably be available part of the 3-4 on Thursday and part of the 11-12 on Friday. Friday I will also be working on advisement and available for help from 1 to 4. Please look at the following: (I plan to look at cursors first and then go back to record and table - that is the way I did it last year and it seemed to work well). Record and table types Introduction to cursors PL/SQL User Defined Types - record and table Separate speaker notes for PL/SQL User Defined Types - record and table Covers: Cursors in PL/SQL, cursor example and continuation of first cursor example Separate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example I will continue with cursors so please continue to look at the notes and presentations on this topic. Assignments: Loop and cursor assignment Sorry, I had upload problems. Continue on to next week. |
| Week #10 Assignments Week of November 3rd |
Meditech presentation on campus, Thursday at 11 in K101 Help labs will be at 11 on Tuesday in K101,3 on Thursday in K101. Thursday I will be in K102 at 6:00. I am also available in my office at 11 on Friday. We will start also looking at loops: Introduction to loops Introduction to loops Separate speaker notes for Introduction to loops In class we will work on developing a simple PL/SQL program. After loops, we will go back and look at the first few notes on Introduction to PL/SQL and More examples of inner/outer procedures. If time permits we will then look at Data Manipulation in PL/SQL: Data manipulation in PL/SQL - introduction These topics will probably happen next week, but we might make it. Data manipulation in PL/SQL - introduction Separate speaker notes on Data manipulation in PL/SQL - introduction You should now have looked at the examples and presentations up to Record and table types and cursors. Assignments: IF and LOOP assignment |
| Week #9 Assignments Week of October 27th |
I am available at 11 on Tuesday in K101. I am going to a conference for the rest of the week. I strongly
suggest that you come to K101 during class time and create a study group atmosphere where you can help each
other on back work. Start reading the introductory handout on PL/SQL and look at the PowerPoint presentation! I do not like the introduction to PL/SQL that I followed which is why I will look briefly at the introduction and then will go to the IF statements. I will return to the intro and the more examples this week. Be I would also be sure to read the book and check out the Smartboard/audio. Introduction to PL/SQL Only look at the structure on the first page - we will come back to this later You should also get started on the following: Introduction to IF statements More on PL/SQL IF statements Also please look at the accompany presentations: PL/SQL - Using IF statements Separate speaker notes for PL/SQL - Using IF statements More on PL/SQL IF statements Separate speaker notes for More on PL/SQL IF statements Assignments: First PL/SQL Quiz |
| Week #8 Assignments Week of October 20th |
Meditech presentation on campus I will be available Tuesday and Thursday at 11 in K101, Thursday at 3 in K101 and at 6 in K101 or K102. In addition I will be available Tuesday after 2:30ish and Friday at 11 and in the afternoon in my office. We will finish up what we started to look at last week. Then we will move on. Please check back! Please look at these handouts - they finish up the coverage of SQL. Information on database objects Script for input data Assignments: Oracle keys assignment |
| Week #7 Assignments Week of October 13th |
I am available in K101 on Thursday at 11:00 and 3:00. I will be at a state meeting on Friday, so there will be no class. If you need help, please contact me! Finishing up the discussion on scripts, please read: Script for input data Read the information on indexes, keys etc. We will start them this week. Please read the following (again this will hopefully be started this week and will be completed next week): Indexes in Oracle - An introduction More on Primary and Foreign keys Notes on key questions More on views Be sure you read about indexes, keys etc in your text as well. Also please look at the accompanying presentations: Indexes in Oracle - An Introduction Separate 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. More on views Separate speaker notes for More on views Notes on importing and exporting tables: This is the site I used as a reference. Go to the command prompt and I went to: c:\oracle\ora92\bin Then at c:\oracle\ora92\bin>exp scott/tiger file="h:\emptest2.dmp tables(empver2) I have a table called empver2 that I am exporting - I am putting it on my h drive so I can take it and plug it in on the other computer. When I got the other computer I am using the f drive. Again I go to the command prompt and to c:\oracle\ora92\bin. Then at c:\oracle\ora92\bin>imp scott/tiger file=f:\emptest2.dmp fromuser=scott touser=scott tables=empver2 Assignments: As promised, catch up week! No new assignments. |
| Week #6 Assignments Week of October 6th |
I will have a lab on Tuesday and Thursday at 11:00 in K101 and Thursday at 3:00 as well. Thursday
evening I will be available around 5:30 or 6:00 in K102. We will then start looking at the following topics: Using input variables More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Continuation of table maintenance revisited (again) We are going to start these - may not make it through: Introduction to views Introduction to reports Presentations: Using Input Variables Separate 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) Introduction to views Separate speaker notes for Introduction to views Introduction to Reports Separate speaker notes for Introduction to reports Assignments: Views and reports (due in two weeks) The good news is that next week will be light! No new assignments! |
| Week #5 Assignments Week of September 29th |
Help/support lab Tuesday and Thursday at 11:00 in K101. I will be available until
around 5:00 on Tuesday (starting 3:00 ish) in my office and again on Thursday starting around 5:30 in K102. Keep reading along in the book - picking appropriate chapters to read or using it as a reference - you should make sure you have read the information on all of the topics we cover. If you read about a chapter a week you will be in good shape. Please read the notes and handouts on Oracle Joins. We will start subroutines this week. Please read the following information about subroutines: Subqueries More on subqueries You should also look at the presentation on these topics especially the one that accompanies More on subqueries. Subqueries Separate speaker notes for subqueries More on Subqueries Separate speaker notes for More on subqueries Zipped subqeries and order example from last week This is an example that you might find helpful: Examples Solution Assignments: Quiz #3 If you have not done so, please go to the blog and introduce yourself and enter any success or questions about installing Oracle at home. Assignment (mostly on subqueries) Due in 2 weeks At school, I believe you can access the emp, dept, and salgrade tables by using the scott/tiger login. I am not sure they are available under your log in, please check and let me know. At home you should have them under thes scott tiget login. Please use the create table ... as to make a copy with your name. Please do not change or modify the emp table under scott. Example of how to create a copy of the donor table so you do not mess up the data in the original table.
SQL> create table testdonor as
2 select * from donor;
Table created.
|
| Week #4 Week of September 22nd |
We have not been impacted by the eLearning problems at BCC - it does not relate to this course, so
we will continue with the course on the standard college schedule. Help/support lab Tuesday and Thursday at 11:00 in K101. Please read the following information about relational databases in Oracle. Introduction to multiple tables (relational) - joins Relational database examples Look at the relational examples in these presentations: 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 Normalization - information on third normal form Separate speaker notes for normalization presentation Relational database examples - order system Separate speaker notes for relational database examples - order system Student system relational database example Separate speaker notes for student system relational database example Be sure you read about using JOIN in your textbook and also look at the handout: Oracle Join Check back - I may add something to this list. Quiz #2 Implement your oil design (the one you did during the first week of classes Note that you should have the designed approved by me before you implement. I am looking for a very basic structure of three tables for this implementation (customer, house type, delivery (delivery should have a two part key - even though we are not putting in keys right now)). If I agreed with and graded your design, then I approved it! Note any comments I made! For inclass discussion Students should layout a design and send it in for check off only (I suggest doing this after I have done the discussion in class and posted it). I made the movie card design extra credit. |
| Week #3 Week of September 15th |
I have posted notes from other students in the class about the installs they did using 91 and 10g. They are under
installation and login. I really appreciate the work they did and I am sure anyone having problems will find it
helpful. I want you to use the text as reference and to read along in it one or two chapters a week - I go through the course in the order that it was given at Oracle so I may not be totally in sync with the book. Last week and the beginning of this week we covered what is in chapter #2 and #3. We are then moving into chapter #5 and #6 as we talk about functions. The following week we will do chapter #4 which is joining tables. I have passwords for students who want to use BCC labs - if you were not in class and you plan to use our labs, you need to send me an email asking for your userid and password. 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 I may go further, so do check back. You should also look at the accompanying PowerPoint presentations: More on maintaining an SQL table Separate speaker notes for More on maintaining an SQL table SQL functions - part 1 character Separate speaker notes for SQL functions - part 1 characters SQL functions - part 2 numeric & date Separate speaker notes for SQL functions - part 2 numeric & date More SQL functions (includes DECODE, ways to edit SQL code and nested functions) Separate speaker notes for more SQL functions Group functions Separate speaker notes for group functions We started looking at relational databases - the notes and presentations will be listed under next week, but they are the next thing in the list of notes. Assignments: Oracle create, maintain and query assignment Oracle quiz This will be started in class by inclass students - distance students should do at home - I am interested in having you play computer - I do not want you to use the computer to get the results. You can check your results if you want to, but please do it on your own. |
| Week #2 Week of September 8th |
I have your passwords, if you do not receive one, please contact me. Note, if you signed up late I have
asked for them, but have not gotten them yet. I have sent you an invitation to a class blog. This is a great place to post installation questions and get feedback from other students. On the computer I use everyday, I have open source which is compatible with Office 2003. I have 2007 on a computer that is frequently not on. I would appreciate Office 2007 being saved in 2003 format before things are sent. Thanks! Read chapter #2 in the text. Note that I work more off the notes so sometimes I am not totally in sync with the text. Please use the text also for reference. Look up things that I am covering that have not yet appeared in the text. I really leave reading the text up to you - your responsibility. I suggest reading a chapter or so a week. Read the notes and study the presentations for: Introduction to SQL in Oracle, Create a table in SQL, SQL Conditions and start reading Working with SQL. Many of the notes and presentations were done with an earlier version of Oracle. It does not matter when you are working from the SQL prompt. When it does matter, I will point out the differences. Notes: We actually started the first set of notes on creating a table in class on Friday. There is an audio section on the class activities that can be listened to with the notes. Introduction to SQL in Oracle Create a table in SQL SQL Conditions Working with SQL 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 Working with SQL Separate speaker notes for Working with SQL Note the first few slides in Working with SQL show login procedures using scott and tiger. Assignment: Oracle assignment on introductory material Working with Oracle (lab work not to pass in) A few people are having trouble with the download or the installation, if you are having problems please post what is going wrong on the class blog. Those of you who got things working, please check the blog and try to help those who are having a problem. Thanks! I would also like you to go to the class blog and introduce yourself. A picture would be great! |
| Week #1 Week of September 1st |
Read chapter #1 in the text. You should take this time to get a copy of Oracle if you are working on a computer outside the labs. You can use 7.3, 8, 8i, 9i or 10g. Please do not use Oracle 10g Express or any other express version. You can download from Oracle. See information under Using Oracle. Downloading You will be given a password for using Oracle at BCC - hopefully next week. To give you some time to get a copy of Oracle installed and to get your password, we are going to deal with the theory of relational databases this week. If you are without access to Oracle, please let me know what your problem is so we can try to get you up and running! Be very careful when you install, Oracle leaves a lot of footprints that makes reinstalling ver difficult. Please read information about third normal form and relational databases. I have put a variety of links to sources on the Web on the site under links and links to my site are listed below. Apparently it takes a few days for Oracle to email back the registration key so it would pay to get the process started soon. Please read the handout on definitions: Normalization definitions Please read the two examples - the first two postings under notes. Also view the slide presentation on normalization information about relational databases: Normalization - information on third normal form Separate 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 Other examples can be found at my web site under Notes and handouts - Normalization and Relational Database (scroll down to the bottom of the notes and handouts screen to find them). Assignment: Set up relational database for an oil company (very basic) Note this should be a design only - it should not be done using Oracle Note: Please note that I have put up additional notes that might help with this assignment - they are under Notes and Handouts - Normalization and Relational Database and Misc (scroll to the bottom of Notes and Handouts). You should check back to make sure there have been no additions! |