| 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 Assignments Week of June 7th Recommend you start earlier |
I recommend that you start this course now rather than waiting until June 7th.
This will either give you the chance to take a vacation without impacting the
course schedule or give you extra time at the end of the summer to catch up
or to take a break before the fall semester starts. I will be out of town from
May 28th through June 3rd and I will not be checking my email during that time.
I would appreciate it if you would wait until I return to send it work and
questions so my email does not clog. 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 Assignments Week of June 14th |
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 Assignments Week of June 21st |
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. 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 Oracle create, maintain and query assignment (due in two weeks) |
| Week #4 Assignments Week of June 28th |
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 Implement your oil design |
| Week #5 Assignments Week of July 5th |
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 July 12th |
Please finish the information about table maintenance from last week and read the information on views and reports. Again let me emphasize that you should be reading the appropriate chapters in the book. 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 |
| Assignments Week #7 Week of July 19th |
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. We will finish SQL this week, so read any notes that are left at the site and focus on additional information in the text. Check back as always to see if I have added additional information. Assignments: Assignment on keys |
| Assignments Week #8 Week of July 26th |
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 |
| Assignments Week #9 Week of August 2nd |
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 #10 Week of August 9th |
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 #11 Week of August 16th |
I had a computer disaster and am currently working on recovering everything and
setting things up - but I am now back on line. Sorry for any problems... 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). Function, procedure and trigger assignment |
| Assignments Week #12 Week of August 23rd |
Continue looking at the topics listed two weeks ago. Assignments: Last quiz Extra credit project Final is posted! |
| Assignments Week #13 Week of August 30th |
The final is due on August 30th. Final Exam Required Status Sheet |