| 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 if you are having trouble accessing them! | |
| Week #1 Week of January 19th |
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, or 9i. Version 9i comes with your book. You can also download from Oracle. See information under Using Oracle. 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, 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! 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. Please read the handout on definitions: Normalization definitions 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 Note this should be done 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 Related Topics (scroll to the bottom of Notes and Handouts). |
| Week #2 Week of January 26th |
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. 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. Under Postings/Notes on my home page, there is a link to some new scholarship information. Assignment: Oracle assignment on introductory material |
| Week #3 Week of February 2nd |
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 University
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 will then move 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 on Friday, 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. I still have a little left last week, so I may not complete everything. More on maintaining an SQL table SQL functions More SQL functions Group SQL functions 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 Assignments: Oracle quiz for in class day students, this will be started in class - must be done by everyone |
| Assignments Week #4 Week of February 9th |
First, we will finish up group functions. 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 I am not sure how far we will get this week, so be sure to check back to find out if we moved beyond this or got stuck on some topic! NOTE: I am going to go over the oil design either Thursday or Friday. You must have it in to me by that time or you will not get credit for the design assignment (the assignment given week #1). I had some email problems this morning and lost some email (mainly things delivered on the morning of the 11th), if you did not get a response or you suspect something did not get through, please send it again. Assignments: Quiz #2 (if you are coming to class, we will start the quiz there) Implement your oil design NOTE: Apparently there was a problem - I am not sure whether the page with week #3 was visible - my apologies and proceed at a rate that makes sense to you! Please let me know if that ever happens again - I honestly do not know what happened! |
| Assignments Week #5 Week of February 16th |
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. Please read the following information about subroutines, maintenance etc. Subqueries More on subqueries Using input variables More on variables with Oracle's SQL*Plus Table maintenance revisited (again) Continuation of table maintenance revisited (again) 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 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) Assignments: Quiz #3 Assignment (mostly on subqueries) |
| Assignments Week #6 Week of February 23rd |
Please finish the information about table maintenance from last week (if you have
not already done so) and read the information on views and reports. Introduction to views Introduction to reports You should also look at the accompanying presentations: Introduction to views Separate speaker notes for Introduction to views Introduction to Reports Separate speaker notes for Introduction to reports You should also start looking at indexes, keys etc. We will cover them in more detail next week. Assignments: Views and reports Review quiz: Oracle create, maintain and query assignment (due in two weeks) |
| Assignments Week #7 Week of March 1st |
Please read the following: Indexes in Oracle - An introduction More on Primary and Foreign keys Notes on key questions 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 More on Primary and Foreign Keys also info from questions Separate speaker notes for More on Primary and Foreign Keys etc. Assignments: Assignment on keys |
| Assignments Week #8 Week of March 8th |
We will finish SQL this week so please read the rest of the notes and look at the
rest of the presentations. Start reading the introductory handout on PL/SQL and look at the PowerPoint presentation! This is one of the areas where I do not like the way Oracle introduced PL/SQL so I would also be sure to read the book Introduction to PL/SQL More examples of inner/outer procedures Introduction to PL/SQL Separate speaker notes for Introduction to PL/SQL You should also get started on the following: Introduction to IF statements More on PL/SQL IF statements Introduction to loops 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 Introduction to loops Separate speaker notes for Introduction to loops I know this is a lot of information, but vacation is next week so hopefully you can spread it out over a little more time. Assignments: First PL/SQL Quiz |
| Vacation Week #9 Week of March 15th |
Hope vacation is/was enjoyable and productive! |
| Assignments Week #10 Week of March 22nd |
Please read the following notes and watch the slide presentations. Data manipulation in PL/SQL - introduction Record and table types Data manipulation in PL/SQL - introduction Separate speaker notes on Data manipulation in PL/SQL - introduction PL/SQL User Defined Types - record and table Separate speaker notes for PL/SQL User Defined Types - record and table This week we will finish dealing with types and introduce cursors. Introduction to Cursors Assignments: Assignment using loops and cursors |
| Assignments Week #11 Week of March 29th |
We will focus on cursors this week. Be sure to look at the handouts on cursors. Please note
that there is a Smartboard explanation of one of the cursor examples. 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 Assignment: Multiple cursor assignment |
| Assignments Week #12 Week of April 5th |
We will continue focusing on cursors this week, and then... The next topics are exceptions, procedures, and triggers. Please read the notes and look at the PowerPoint presentations. We will spend the next couple of weeks on these topics. Introduction to exceptions 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 Exceptions in PL/SQL Separate 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 Assignments: You can do this assignment by modifying existing programs or creating new ones. Use the three kinds of exceptions in a PL/SQL program or programs(s). I have been sick since the weekend, so I have accomplished little or nothing. I am starting to feel better so I am hoping to get some correcting down this afternoon and this evening. |
| Assignments Week #13 Week of April 12th |
Continue looking at the topics listed last week. Assignments: Function, procedure and trigger assignment |
| Assignments Week #14 Week of April 19th |
Continue looking at the topics listed two weeks ago. Assignments: Last quiz Extra credit project |
| Assignments Week #15 Week of April 26th |
Review the information covered this semester. Assignments: Continue with the wrapup of the course including the extra credit project if you decided to do it. The final will be posted next week. No new assignmnets! |
| Assignments Week #16 Week of May 3rd |
Your final exam must be sent to me by 3:30 on Tuesday, May 11th. It should be sent to the usual email address and to pgrocer@bristol.mass.edu. I will send you the final on Sunday, May 2nd along with the required status sheet. Please let me know if you do not get it! |