| 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! | |
| Week #15 Assignments Week of December 10th |
Catch up week! We will finish anything we did not get to last week and the rest of the time we will
work on last weeks assignments in class. This looks helpful: Oracle PL/SQL Cheatsheet Final Exam and Status Sheet Assignments: Required Status Sheet for Fall 2007 The status sheet can be passed in at any time for confirmation, the final version must be passed in with the final. The final will be posted today/tonight. It must be passed in by the scheduled day and time of the final which means by Monday, December 17, 2007 at 8:00. If I do not receive the final by that time, you must come to the scheduled final and take/complete it at that time. Final Exam Fall 2007 Given the weather, if you use the labs at BCC and the snow on Friday and Sunday presented a problem, let me know and we can extend the final due date. |
| Week #14 Week of December 3rd |
We will have an open lab in K101 on Tuesday from 9 until at lest 2:00 - if people are interested
I can stay, probably until 4:00. We will continue functions and procedures and introduce triggers next week. 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: I am going to list the assignments for the rest of the semester so you can work on your own schedule. Assignment: 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). Extra credit project If you have had a pattern of lateness, if you have received some bad grades, if you are nervous about doing well on the final or just if you want to learn more about Oracle, the extra credit project is for you! Function, procedure and trigger assignment Last quiz we will have time for you to do this in class |
| Week #13 Assignments Week of November 26th |
I will be available in K101 at 11:00 on Tuesday and K116 at 3:00 on Thursday. First, we will finish the cursor examples from last week. Then, we will move to exceptions and start looking at procedures and functions. We will continue working on the examples below next week if we need more time. Introduction to exceptions Introduction to procedures Introduction to functions 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 Assignments: Multiple cursor assignment |
| Week #12 Week of November 19th |
Happy Thanksgiving! This week is catch up week - on Tuesday there will be an open lab in K101 from 9:00 until 2:00. I will be there as well as Shawn and Stephanie - if you are behind or need help, please come for as many hours as you can. Let's get caught up! I can do a little advisement as well! |
| Week #11 Week of November 12th |
Advisement starts this week! We will return to last week's postings to look at Record and table types. Advisement starts this week. I will be available for online advisement on Monday from 9-10 and then on campus accourding to the signup on my door. You can also email me or IM me for advisement. We will focus on cursors this week (actually we started them last week). 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 Check back! Assignments: Loop and cursor assignment |
| Week #10 Week of November 5th |
We have been having some problem with my things stored on the server at BCC. If you cannot access something, please let me know. Lab in K101 at 11:00 on Tuesday also Thursday 4:00 - 6:00 probably in K116. Check my door! As I said in class, 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. We will start also looking at loops: Introduction to loops Data manipulation in PL/SQL - introduction I actually skipped Records and Tables, and started to look at cursors. I will cover Records and tables next week along with more on cursors. I did the introduction to cursors except for the last example which I will return to next week after I do Record and table types. Introduction to cursors Note that there is also a PowerPoint presentation listed under next week or under presentations. Record and table types Introduction to loops Separate speaker notes for Introduction to loops Then we will go back and look at the introductory material in PL/SQL. I feel more confident that it will make sense after you have looked at if and loops. 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 Assignments: IF and LOOP assignment |
| Week #9 Assignments Week of October 29th |
Keep reading about SQL - I suggest you take a look at the security chapter. Look at these notes and presentation. Information on database objects Script for input data Database Objects in Oracle Separate speaker notes for Database Objects in Oracle We will start looking at PL/SQL and then come back and tie up some loose ends at the end of the semester. 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 Check back and see how we are doing! Assignments: First PL/SQL Quiz |
| Week #8 Assignments Week of October 22nd |
I am available in K101 on Tuesday at 11:00 and in K116 on Thursday at 3:00 as well as office hours.
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 Assignments: Oracle keys assignment |
| Week #7 Assignments Week of October 15th |
I have to go to a conference this Thursday and Friday. I will be available Tuesday at 11:00 in
K101 and Stephanie will have an open lab on Thursday from 9:00 - 11:00 and from 12:00 - 2:00. 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 Between being sick and being away, I am behind in homework. Hopefully I will get caught up soon. Sorry! Assignments: Views and reports |
| Week #6 Assignments Week of October 8th |
We will start off by finishing subroutines. 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) 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: Assignment (mostly on subqueries) At school, I believe you can access the emp, dept, and salgrade tables by using the scott/tiger 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. |
| Week #5 Assignments Week of October 1st |
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. I started dealing with subroutines on Friday of last week - I am not sure how far I will get on Tuesday, so whatever is left will be finished next week. This week I will be out on Thursday and Friday, but Stephanie will run an open lab in K101 from 9-11 and 12-2. It makes sense to come and work on homework. Please do not send me a lot of homework this week or my email will clog - I will check my BCC account so if you have questions, use that while I am gone. 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 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. Also you will find a posting about renaming columns. At school, I believe you can access the emp, dept, and salgrade tables by using the scott/tiger 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.
SQL> create table testdonor as
2 select * from donor;
Table created.
|
| Week #4 Assignments Week of September 24th |
Help/support lab Tuesday at 11:00 in K101. I have gotten a little ahead in class, so I started looking at relational databases last
week. 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. If I agreed with and graded your design, then I approved it! 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). Check back! |
| Week #3 Week of September 17th |
A distance learning student has requested a webhuddle meeting. I have sent you information if you
want to participate (it was sent to your BCC account). Let me know if you want to set up another. 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. 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 I will probably 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 done 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 10th |
Read chapter #2 in the text (hopefully it will be in this week). 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. 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 two sets of notes in class on Friday. Theere 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. If you want an Oracle password for BCC please let me know. Check back - we may look at more on maintaining an SQL table. We did look at maintenance and infact started looking at functions. Next week we will slow down a little and inclass students will have the opportunity to work on assignments. 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. |
| Week #1 Week of September 3rd |
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. 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 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! |